MySQL 5.4µÄÐÂÌØÐÔ½âÎö
Author: Ivan@mysqlab.net/Ì·¿¡Çà ×ªÔØÇë×¢Ã÷À´Ô´URIÁ´½Ó:
http://www.mysqlab.net/blog/2009/04/mysql-54µÄÐÂÌØÐÔ½âÎö/
MySQL 5.4 Ö®ËùÒÔÃüÃûΪ5.4£¬¶ø²»ÊÇ5.2 ÊÇÒòΪ֮ǰµÄ5.2°æ±¾±»ÃüÃûΪ6.0ÁË£¨Õâ¸öÓ¦¸ÃÊÇÉÌÒµÉϵÄÔÒò£¬¾ÍÏñjava1.6±»ÃüÃûΪ6.0£©¡£ÏÖÔÚµÄ5.4 preview release ÊÇÔÚµ±Ç°MySQL5.1µÄ»ù´¡ÉÏ£¬¶Ô Innodb ½øÐÐÁËһЩÓÅ»¯,ÕâЩ²¹¶¡À´×Ôgoogle£¬°üÀ¨£ºInnodbIoTuning, InnodbAsyncIo, InnodbStatus , NewShowInnodbStatus , SmpPerformance µÈ¡£
´ÓËù´òµÄÄÇЩ²¹¶¡£¬ÎÒÃÇ¿ÉÒÔ¿´³ö£¬¶Ôinnodb×öÁ˺ܶàÓÅ»¯£¬ÌرðÊÇioµÄÓÅ»¯ºÍsmp¶àºËcpuµÄÓÅ»¯¡£
ÏÂÃæ¾ÍһЩÐÂÔö²ÎÊýºÍĬÈÏÖµµÄ¸ü¸Ä×öЩ˵Ã÷£º
innodb_io_capacity
Õâ¸öÔÚ֮ǰµÄinnodb°æ±¾ÖÐÊDZ»Ð´ËÀµÄ£¬Ä¬ÈÏÖµÊÇ100£¬ÔÚ5.4ÖÐĬÈÏÖµÒѾ¸Ä³É200¡£
innodb_extra_dirty_writes
Õâ¸öÊǷdz£ÓÐÓõÄÒ»¸öÌØÐÔ£¬µ±·þÎñÆ÷×ÊÔ´idleµÄʱºò£¬»á×öcheckpoint£¬½«ÔàÊý¾ÝҳдÈë±í¿Õ¼ä£¬¼°Ê±Ã»Óе½´ïÉèÖõıÈÀý(innodb_dirty_pages_pct,innodb_max_dirty_pages_pct)¡£
innodb_buffer_pool_size
ĬÈÏÖµÓÉÔÀ´µÄ8M¸ÄΪ1G£¬ÆäʵÔÚ´óЩµÄdbÖУ¬Õâ¸ö»¹ÊÇÔ¶Ô¶²»¹»µÄ¡£¿ÉÒÔ½«1°ë£¬ÉõÖÁ2/3µÄÄÚ´æÓÃÔÚÕâÉÏÃæ¡£
innodb_log_file_size
ĬÈÏÖµÔöÖÁ128M ÔÚ´ÅÅÌÐÔÄܺÃЩµÄ»úÆ÷ÉÏ£¬Ó¦¸Ã»¹ÒªÔö¼Ó£¬ÅäºÏinnodb_dirty_pages_pct, ÒÔʵÏÖ¸ü¼ÓºÃµÄÐÔÄÜ¡£
innodb_thread_concurrency
InnodbÖеIJ¢·¢¿ØÖƲÎÊý£¬Ä¬ÈÏÖµÓÉ8¸Ä0£¬Õâ¸ö¶¼µÃÒÔÓÚgoogleµÄsmpperformance²¹¶¡£¬ÒÔǰ²¢·¢³¬¹ý8ʱ£¬ÐÔÄÜ»ù±¾ÉÏ»áϽµ¡£
ÁíÍâÐèÒªÌáÐѵÄÊÇ£ºÄ¿Ç°MySQL5.4»¹ÊÇpreview release£¬²»½¨ÒéÓÃÓÚÉú²ú»·¾³¡£
Ïà¹ØÎĵµ£º
ÔÚ¶Ômysql½øÐе÷ÊÔµÄʱºò£¬ÓÉÓÚmysql´æÔÚquery»º´æ£¬³£³£²»ÄÜ·´Ó³ÕæÊµÇé¿ö¡£
ÓÐʱºò£¬ÓÐûÓÐʹÓÃFLUSH
QUERY
CACHEµÄȨÏÞ£»
ÔÚ query_cache_type ´ò¿ªµÄÇé¿öÏ£¬Èç¹ûÄã²»ÏëʹÓûº´æ£¬ÐèÒªÖ¸Ã÷
select sql_no_cache id,name from tableName;
»òÕß»¹Óиü¼òµ¥µÄ°ì·¨£¬ÐÞ¸ÄÒ»ÏÂsqlÀïij¸ö×Öĸµ ......
°²×°Íêphpmyadmin
´ó¼Ò¾³£³öÏÖµÄÎÊÌâ¾ÍÊDZ¨´í£º“ÎÞ·¨ÔØÈëmysqlÀ©Õ¹£¬Çë¼ì²éphpÅäÖÔ¡£
Èç¹ûÄãʹÓõÄÊÇphp5.2ÒÔÉϵİ汾£¬Çë×¢Ò⣺php¶Ô·þÎñµÄÀ©Õ¹¹¦ÄÜ×öÁËÒ»¶¨µÄ¸Ä¶¯£¬Ò²¾ÍÊÇ˵£¬Äã°²×°phpºÍÀ©Õ¹µÄ·½Ê½Ò²Òª×öµ÷ÕûÁË¡£
Ö÷ÒªµÄµ÷ÕûÓÐÁ½·½Ã棬һÊÇPHP5.2ÒÔÉϵİ汾ÖУ¬PHP.INIÎļþÎÞÐèÌí¼Óµ½WINDOWSĿ¼Ï¡£¶þ ......
Unix&Linux£º
1.ÓÃroot»òÕßÔËÐÐmysqldµÄÓû§µÇ¼ϵͳ£»
2£®ÀûÓÃkillÃüÁî½áÊøµômysqldµÄ½ø³Ì£»
3£®Ê¹ÓÃ--skip-grant-tables²ÎÊýÆô¶¯MySQL Server
shell>mysqld_safe --skip-grant-tables &
4.Ϊroot@localhostÉèÖÃÐÂÃÜÂë
shell>mysqladmin -u root flush-privileges password "newpassword" ......
MySQL ×Ö·û´®½ØÈ¡º¯Êý£ºleft(), right(), substring(), substring_index()¡£»¹ÓÐ mid(), substr()¡£ÆäÖУ¬mid(), substr() µÈ¼ÛÓÚ substring() º¯Êý£¬substring() µÄ¹¦Äܷdz£Ç¿´óºÍÁé»î¡£
1. ×Ö·û´®½ØÈ¡£ºleft(str, length)
mysql> select left('sqlstudy.com', 3);
+-------------------------+
| left('sq ......