Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÖÐshow ÃüÁîÓ÷¨Ïêϸ½éÉÜ

 ÒÔÏÂËùÓÐÃüÁî¶¼ÊÇÔÚ½øÈë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 ......

MYSQL¸ß²¢·¢¼Ü¹¹

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

MySQL 5.0´æ´¢¹ý³Ì

Ê×ÏÈ¿´MySQL 5.0²Î¿¼ÊÖ²áÖйØÓÚ´´½¨´æ´¢¹ý³ÌµÄÓ﷨˵Ã÷£º
 
CREATE
    [DEFINER = { user | CURRENT_USER }]
    PROCEDURE sp_name ([proc_parameter[,...]])
    [characteristic ...] routine_body
   
proc_parameter:
    ......

ͨ¹ý·ÖÇø£¨Partition£©ÌáÉýMySQLÐÔÄÜ

 
ͨ¹ý·ÖÇø£¨Partition£©ÌáÉýMySQLÐÔÄÜ
×÷Õߣºfoxcai À´Ô´:foxcai µÄ Blog (2006-05-08 14:30:34)
ͨ¹ý·ÖÇø£¨Partition£©ÌáÉýMySQLÐÔÄÜ
               ——MySQL5.1ÐÂÌØÐÔ·­ÒëϵÁÐ
¼¸Äêǰ£¬°³Ð´¹ýһƪÌâΪ“The Founda ......

ÖØÐÂÕÒµ½MySQLÊý¾Ý¿âµÄrootÃÜÂë

 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" ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ