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¼à¿ØÆ÷ÖÐÖ´Ðеģº
a. show tables»òshow tables from database_name; // ÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ
b. show databases; // ÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ
c. show columns from table_name from database_name; »òshow columns from databa ......
L1¡¢HTML¾²Ì¬»¯
Æäʵ´ó¼Ò¶¼ÖªµÀ£¬Ð§ÂÊ×î¸ß¡¢ÏûºÄ×îСµÄ¾ÍÊÇ´¿¾²Ì¬»¯µÄhtmlÒ³Ãæ£¬ËùÒÔÎÒÃǾ¡¿ÉÄÜʹÎÒÃǵÄÍøÕ¾ÉϵÄÒ³Ãæ²É Óþ²Ì¬Ò³ÃæÀ´ÊµÏÖ£¬Õâ¸ö×î¼òµ¥µÄ·½·¨ÆäʵҲÊÇ×îÓÐЧµÄ·½·¨¡£µ«ÊǶÔÓÚ´óÁ¿ÄÚÈݲ¢ÇÒÆµ·±¸üеÄÍøÕ¾£¬ÎÒÃÇÎÞ·¨È«²¿ÊÖ¶¯È¥°¤¸öʵÏÖ£¬ÓÚÊdzöÏÖÁËÎÒÃdz£¼ûµÄÐÅÏ¢ ·¢²¼ÏµÍ³CMS£¬ÏñÎÒÃdz£·ÃÎʵĸ÷¸öÃÅ»§Õ¾µãµÄÐ ......
Ê×ÏÈ¿´MySQL 5.0²Î¿¼ÊÖ²áÖйØÓÚ´´½¨´æ´¢¹ý³ÌµÄÓ﷨˵Ã÷£º
CREATE
[DEFINER = { user | CURRENT_USER }]
PROCEDURE sp_name ([proc_parameter[,...]])
[characteristic ...] routine_body
proc_parameter:
......
ͨ¹ý·ÖÇø£¨Partition£©ÌáÉýMySQLÐÔÄÜ
×÷Õߣºfoxcai À´Ô´:foxcai µÄ Blog (2006-05-08 14:30:34)
ͨ¹ý·ÖÇø£¨Partition£©ÌáÉýMySQLÐÔÄÜ
——MySQL5.1ÐÂÌØÐÔ·ÒëϵÁÐ
¼¸Äêǰ£¬°³Ð´¹ýһƪÌâΪ“The Founda ......
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" ......