Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Á¬½Óʱ¿ìʱÂýµÄÎÊÌâ½â¾ö

 my.iniÀïµÄÄǸötmp_table_sizeµÄÖµ.Ô­À´tmp_table_size=16M.ÎÒ¸ÄΪ32M
È»ºóÖØÆôMYSQL»¹ÊÇû½â¾öÎÊÌâ.
Ö»ºÃÖØÆô·þÎñÆ÷ÊÔÊÔÁË,½á¹ûÖØÆôºóCPUÕý³£ÁË.²»¹ý»¹ÊÇûÕÒ³öÊÇʲôԭÒòµ¼ÖÂMYSQLÕ¼ÓÃÄÇô¶àCPU×ÊÔ´.
=====================================
ÐÞ¸ÄhostsÎļþ£¬¼ÓÈëÒ»ÐР  
172.16.59.12   & ......

mysql¼Ü¹¹·½°¸

Scale Out£ººáÏòÀ©Õ¹£¬Ôö¼Ó´¦Àí½ÚµãÌá¸ßÕûÌå´¦ÀíÄÜÁ¦
Scale Up£º×ÝÏòÀ©Õ¹£¬Í¨¹ýÌáÉýµ¥¸ö½ÚµãµÄ´¦ÀíÄÜÁ¦´ïµ½ÌáÉýÕûÌå´¦ÀíÄÜÁ¦µÄÄ¿µÄ
Replication
MySQLµÄreplicationÊÇÒì²½µÄ£¬ÊÊÓÃÓÚ¶ÔÊý¾ÝʵʱÐÔÒªÇó²»ÊÇÌØ±ð¹Ø¼üµÄ³¡¾°¡£slave¶ËµÄIOÏ̸߳ºÔð´Ómaster¶ÁÈ¡ÈÕÖ¾£¬SQLÏß ³ÌרߺÔðÔÚslave¶ËÓ¦ÓôÓmaster¶Á¹ýÀ´µÄÈÕÖ¾£¨ÔçÆÚ ......

MYSQL¸ß²¢·¢¼Ü¹¹

L1¡¢HTML¾²Ì¬»¯
Æäʵ´ó¼Ò¶¼ÖªµÀ£¬Ð§ÂÊ×î¸ß¡¢ÏûºÄ×îСµÄ¾ÍÊÇ´¿¾²Ì¬»¯µÄhtmlÒ³Ãæ£¬ËùÒÔÎÒÃǾ¡¿ÉÄÜʹÎÒÃǵÄÍøÕ¾ÉϵÄÒ³Ãæ²É Óþ²Ì¬Ò³ÃæÀ´ÊµÏÖ£¬Õâ¸ö×î¼òµ¥µÄ·½·¨ÆäʵҲÊÇ×îÓÐЧµÄ·½·¨¡£µ«ÊǶÔÓÚ´óÁ¿ÄÚÈݲ¢ÇÒÆµ·±¸üеÄÍøÕ¾£¬ÎÒÃÇÎÞ·¨È«²¿ÊÖ¶¯È¥°¤¸öʵÏÖ£¬ÓÚÊdzöÏÖÁËÎÒÃdz£¼ûµÄÐÅÏ¢ ·¢²¼ÏµÍ³CMS£¬ÏñÎÒÃdz£·ÃÎʵĸ÷¸öÃÅ»§Õ¾µãµÄÐ ......

MySQL+PHP²úÉúÂÒÂëµÄÔ­Òò¼°½â¾ö·½·¨

MySQL+PHP²úÉúÂÒÂëÔ­Òò£º
¡¡¡¡¡ô MySQLÊý¾Ý¿âĬÈϵıàÂëÊÇutf8,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄPHPÍøÒ³²»Ò»ÖÂ,¿ÉÄܾͻáÔì³ÉMySQLÂÒÂë;
¡¡¡¡¡ô MySQLÖд´½¨±íʱ»áÈÃÄãÑ¡ÔñÒ»ÖÖ±àÂë,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄÍøÒ³±àÂë²»Ò»ÖÂ,Ò²¿ÉÄÜÔì³ÉMySQLÂÒÂë;
¡¡¡¡¡ô MySQL´´½¨±íʱÌí¼Ó×Ö¶ÎÊÇ¿ÉÒÔÑ¡Ôñ±àÂëµÄ,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄÍøÒ³±àÂë²»Ò»ÖÂ,Ò²¿ÉÄÜÔì³É ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ