mysql´¦Àíº£Á¿Êý¾ÝµÄÓÅ»¯ÅäÖÃ
³£³£Óöµ½´óÊý¾ÝÁ¿Æµ·±¶ÁÐ´ÊÆ±Ø»áµ¼Ö·þÎñÆ÷µÄÐÔÄÜϽµ¡£ÏÂÃæ¼Ç¼һ϶ÔmysqlµÄÓÅ»¯ÅäÖÃ
1.Ê×ÏȹرÕauto commit¡£
2.¶ÔÓÚÊý¾Ý±íʹÓÃInnoDB¡£
3.¹Ø±ÕÍâ¼üÔ¼Êø¡£
4.²ÉÓöàÖµ²åÈë“INSERT INTO ±íÃû VALUES (1,2), (5,5), ...;” Èç¹ûÓдóÁ¿²¢·¢¿ÉÒÔÓøü¸ÄINSERT INTOΪ INSERT DELAYED INTO¿ÉÒÔÔڳ̶ÈÉϽâ¾ö×èÈûÎÊÌâ¡£
5.ÈÕÖ¾ÎļþÉèÖõĴóÒ»µã£¬ µ«ÈÕÖ¾»º³åÉ趨ҪÊʵ±¡£
6.¼Ó´óbuffer pool ¡£
innodb_buffer_pool_size = 600M£¨×îºÃСÓÚµÈÓÚ»úÆ÷ÄÚ´æµÄ75%²»Òª³¬¹ý£©¡£
innodb_additional_mem_pool_size = 64M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 256M
#innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
innodb_file_per_table
ÆäÖÐinnodb_flush_log_at_trx_commitºÍinnodb_file_per_table¶ÔI/OÐÔÄÜÓ°Ïì×î´ó
Ïà¹ØÎĵµ£º
linux:
Èç¹û MySQL ÕýÔÚÔËÐУ¬Ê×ÏÈɱ֮£º killall -TERM mysqld¡£
Æô¶¯ MySQL £º/usr/bin/safe_mysqld --skip-grant-tables &
¾Í¿ÉÒÔ²»ÐèÒªÃÜÂë¾Í½øÈë MySQL ÁË¡£
È»ºó¾ÍÊÇ
>use mysql
>update user set password=password("new_pass") where user="root";
>flush privileges;
ÖØÐÂɱ MySQL £¬ ......
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 ½ø ......
InnoDBÊÇmysqlÊý¾Ý¿âÖÐΨһһ¸öÖ§³ÖÍâ¼üµÄÒýÇæ£¬µ«ÊDzîÖµµÄʱºòÈ´µÃ×¢ÒâÒ»ÏÂ
±ÈÈçÓÐÁ½ÕÅ±í£¬album(id,name,path) £¬picture(id,name,path,parent_album)£¬ÆäÖбí2ÖÐparent_albumÊÇÍâ¼ü
´Ëʱ²îÖµinsert into picture (name,path,parent_album) values ("pic","path",68) (68ÊÇÒ»¸öÏà²áµÄid)
mysql»á±¨´í"Failed to read a ......
£Û×ªÔØ£ÝMySQL£ºMySQL ´´½¨´æ´¢¹ý³Ì£¨MySQL 5.0£©
2008-09-11 22:14
MySQL ´æ´¢¹ý³ÌÊÇ´Ó MySQL 5.0 ¿ªÊ¼Ôö¼ÓµÄй¦ÄÜ¡£´æ´¢¹ý³ÌµÄÓŵãÓÐÒ»Âá¿ð¡£²»¹ý×îÖ÷ÒªµÄ»¹ÊÇÖ´ÐÐЧÂʺÍSQL ´úÂë·â×°¡£ÌرðÊÇ SQL ´úÂë·â×°¹¦ÄÜ£¬Èç¹ûûÓд洢¹ý³Ì£¬ÔÚÍⲿ³ÌÐò·ÃÎÊÊý¾Ý¿âʱ£¨ÀýÈç PHP£©£¬Òª×éÖ¯ºÜ¶à SQL Óï¾ä¡£ÌرðÊÇÒµÎñÂß¼¸´ÔÓµÄʱº ......
Èý²½×ߣº
1.ÔÚwindows-->perspective-->DB browser
2.Create a database connection profile
Çý¶¯ÏÂÔØ£º http://dev.mysql.com/downloads/
ÎļþÃû£ºmysql-connector-java-5.0.4-bin
3.Open a database connection
Á´½Óʱ¿ÉÄܳöÏÖ´íÎó£¬ÄÇôÇë³¢ÊÔÈçÏ·½·¨£º
Err ......