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

ÓÅ»¯mysqlÐÔÄܵö²ÎÊýµÄ½éÉÜ

(1)¡¢back_log£º
ÒªÇó MySQL ÄÜÓеÄÁ¬½ÓÊýÁ¿¡£µ±Ö÷ÒªMySQLÏß³ÌÔÚÒ»¸öºÜ¶Ìʱ¼äÄڵõ½·Ç³£¶àµÄÁ¬½ÓÇëÇó£¬Õâ¾ÍÆð×÷Óã¬È»ºóÖ÷Ï̻߳¨Ð©Ê±¼ä(¾¡¹ÜºÜ¶Ì)¼ì²éÁ¬½Ó²¢ÇÒÆô¶¯Ò»¸öÐÂÏ̡߳£
back_log
ÖµÖ¸³öÔÚMySQLÔÝʱֹͣ»Ø´ðÐÂÇëÇó֮ǰµÄ¶Ìʱ¼äÄÚ¶àÉÙ¸öÇëÇó¿ÉÒÔ±»´æÔÚ¶ÑÕ»ÖС£Ö»ÓÐÈç¹ûÆÚÍûÔÚÒ»¸ö¶Ìʱ¼äÄÚÓкܶàÁ¬½Ó£¬ÄãÐèÒªÔö¼ÓËü£¬»»¾ä»°Ëµ£¬ÕâÖµ
¶Ôµ½À´µÄTCP/IPÁ¬½ÓµÄÕìÌý¶ÓÁеĴóС¡£ÄãµÄ²Ù×÷ϵͳÔÚÕâ¸ö¶ÓÁдóСÉÏÓÐËü×Ô¼ºµÄÏÞÖÆ¡£ÊÔͼÉ趨back_log¸ßÓÚÄãµÄ²Ù×÷ϵͳµÄÏÞÖÆ½«ÊÇÎÞЧµÄ¡£
µ±
Äã¹Û²ìÄãµÄÖ÷»ú½ø³ÌÁÐ±í£¬·¢ÏÖ´óÁ¿ 264084 | unauthenticated user | xxx.xxx.xxx.xxx | NULL
| Connect | NULL | login | NULL µÄ´ýÁ¬½Ó½ø³Ìʱ£¬¾ÍÒª¼Ó´ó back_log
µÄÖµÁË¡£Ä¬ÈÏÊýÖµÊÇ50£¬ÎÒ°ÑËü¸ÄΪ500¡£
(2)¡¢interactive_timeout£º
·þÎñÆ÷ÔڹرÕËüǰÔÚÒ»¸ö½»»¥Á¬½ÓÉϵȴýÐж¯µÄÃëÊý¡£Ò»¸ö½»»¥µÄ¿Í»§±»¶¨ÒåΪ¶Ô mysql_real_connect()ʹÓà CLIENT_INTERACTIVE Ñ¡ÏîµÄ¿Í»§¡£ ĬÈÏÊýÖµÊÇ28800£¬ÎÒ°ÑËü¸ÄΪ7200¡£
(3)¡¢key_buffer_size£º
Ë÷Òý¿éÊÇ»º³åµÄ²¢ÇÒ±»ËùÓеÄÏ̹߳²Ïí¡£key_buffer_sizeÊÇÓÃÓÚË÷Òý¿éµÄ»º³åÇø´óС£¬Ôö¼ÓËü¿ÉµÃµ½¸üºÃ´¦ÀíµÄË÷Òý(¶ÔËùÓжÁºÍ¶àÖØÐ´)£¬µ½Äã
Äܸºµ£µÃÆðÄÇÑù¶à¡£Èç¹ûÄãʹËüÌ«´ó£¬ÏµÍ³½«¿ªÊ¼»»Ò³²¢ÇÒÕæµÄ±äÂýÁË¡£Ä¬ÈÏÊýÖµÊÇ8388600(8M)£¬ÎÒµÄMySQLÖ÷»úÓÐ2GBÄڴ棬ËùÒÔÎÒ°ÑËü¸ÄΪ
402649088(400MB)¡£
(4)¡¢max_connections£º
ÔÊÐíµÄͬʱ¿Í»§µÄÊýÁ¿¡£Ôö¼Ó¸ÃÖµÔö¼Ó mysqld ÒªÇóµÄÎļþÃèÊö·ûµÄÊýÁ¿¡£Õâ¸öÊý×ÖÓ¦¸ÃÔö¼Ó£¬·ñÔò£¬Ä㽫¾­³£¿´µ½ Too many connections ´íÎó¡£ Ä¬ÈÏÊýÖµÊÇ100£¬ÎÒ°ÑËü¸ÄΪ1024 ¡£
(5)¡¢record_buffer£º
ÿ¸ö½øÐÐÒ»¸ö˳ÐòɨÃèµÄÏß³ÌΪÆäɨÃèµÄÿÕűí·ÖÅäÕâ¸ö´óСµÄÒ»¸ö»º³åÇø¡£Èç¹ûÄã×öºÜ¶à˳ÐòɨÃ裬Äã¿ÉÄÜÏëÒªÔö¼Ó¸ÃÖµ¡£Ä¬ÈÏÊýÖµÊÇ131072(128K)£¬ÎÒ°ÑËü¸ÄΪ16773120 (16M)
(6)¡¢sort_buffer£º
ÿ¸öÐèÒª½øÐÐÅÅÐòµÄÏ̷߳ÖÅä¸Ã´óСµÄÒ»¸ö»º³åÇø¡£Ôö¼ÓÕâÖµ¼ÓËÙORDER BY»òGROUP BY²Ù×÷¡£Ä¬ÈÏÊýÖµÊÇ2097144(2M)£¬ÎÒ°ÑËü¸ÄΪ 16777208 (16M)¡£
(7)¡¢table_cache£º
ΪËùÓÐÏ̴߳ò¿ª±íµÄÊýÁ¿¡£Ôö¼Ó¸ÃÖµÄÜÔö¼ÓmysqldÒªÇóµÄÎļþÃèÊö·ûµÄÊýÁ¿¡£MySQL¶Ôÿ¸öΨһ´ò¿ªµÄ±íÐèÒª2¸öÎļþÃèÊö·û¡£Ä¬ÈÏÊýÖµÊÇ64£¬ÎÒ°ÑËü¸ÄΪ512¡£
(8)¡¢thread_cache_size£º
¿ÉÒÔ¸´Óõı£´æÔÚÖеÄÏ̵߳ÄÊýÁ¿¡£Èç¹ûÓУ¬ÐµÄÏ̴߳ӻº´æÖÐÈ¡µÃ£¬µ±¶Ï¿ªÁ¬½ÓµÄʱºòÈç¹ûÓпռ䣬¿Í»§µÄÏßÖÃÔÚ»º´æÖС£Èç¹ûÓкܶàеÄỊ̈߳¬ÎªÁËÌá¸ßÐÔÄÜ¿É


Ïà¹ØÎĵµ£º

mysqlË÷ÒýÏê½â,Õª×Ô¡¶MySQL 5ȨÍþÖ¸ÄÏ¡·

mysqlË÷ÒýÏê½â,Õª×Ô¡¶MySQL 5ȨÍþÖ¸ÄÏ¡·
        ±¾ÎĽéÉÜÁËÊý¾Ý¿âË÷Òý£¬¼°ÆäÓÅ¡¢È±µã¡£Õë¶ÔMySQLË÷ÒýµÄÌØµã¡¢Ó¦ÓýøÐÐÁËÏêϸµÄÃèÊö¡£·ÖÎöÁËÈçºÎ±ÜÃâMySQLÎÞ·¨Ê¹Óã¬ÈçºÎʹÓÃEXPLAIN·ÖÎö²éѯÓï¾ä£¬ÈçºÎÓÅ»¯MySQLË÷ÒýµÄÓ¦Óᣱ¾ÎÄÕª×Ô¡¶MySQL 5ȨÍþÖ¸ÄÏ¡·(3rd)µÄ8.9½Ú¡£(2007.07.0 ......

MySQLµÄcµ÷ÓÃ


1. ¸½¼ÓÏîÒ»¶¨ ¼ÓÉÏlibmysql.lib¡£
2. include Ò»¶¨¼ÓÉÏ mysqlµÄinclude£¨ÒòΪҪÅÜÕâ¹Ø¼üÒ»¾ä
#include <mysql.h>£©
3  lib Ò»¶¨¼ÓÉÏ mysqlµÄlib
 
ºÃÁËÏÂÃæÊÇʵÀýºÍphpº¯Êý»ù±¾Ò»ÑùµÄ¡£±¾È˲»¿ÉÄܸøÄã·­ÒëÎĵµ£¬º¯Êý²»¶®×Ô¼º¿´¡£
#include
<windows.h>//ÓÃÕâ¸ö·½±ã£¬°üº¬winsock.hËùÒ ......

MYSQL³£ÓÃÃüÁî


Java´úÂë < width="14" height="15" src="/javascripts/syntaxhighlighter/clipboard_new.swf" pluginspage="http://www.macromedia.com/go/getflashplayer">
//¿´µ±Ç°Ê¹ÓõÄÊÇÄĸöÊý¾Ý¿â  
mysql> SELECT DATABASE();  
+------------+ 
| DATABASE() | 
+------- ......

MySQL µÄǶÌײéѯ

×î½üÔÚMySQLÉÏ×öÁ˵㹤×÷£¬·¢ÏֺܶàÈ˶¼ÔÚѯÎÊMySQLǶÌײéѯµÄÎÊÌ⣬Ðí¶àÈ˶¼¾õµÃMySQL²»Ö§³ÖǶÌײéѯ£¬ÆäʵMySQl´Ó4.11°æºóÒѾ­Íêȫ֧³ÖǶÌײéѯÁË£¬ÄÇôÏÂÃæÎÒ¾ÙЩ¼òµ¥µÄǶÌײéѯµÄÀý×Ó°É£¨Ô´³ÌÐòÀ´×ÔMySQL User Manual£©£º
1. SELECTÓï¾äµÄ×Ó²éѯ:
Óï·¨: SELECT ... from (subquery) AS name ...
ÏÈ´´½¨Ò»¸ö±í:
......

mysqlµÄmaster/slaveÊý¾Ýͬ²½ÅäÖÃ[ת]

ÎҵIJâÊÔ»·¾³.»ù±¾ÉÏÊý¾ÝÊÇ˲¼äͬ²½£¬Ï£Íû¶Ô´ó¼ÒÓаïÖú

redhat 9.0
mysql3.23.57


mysqlÊý¾Ýͬ²½±¸·Ý

A·þÎñÆ÷£º 192.168.1.2 Ö÷·þÎñÆ÷master
B·þÎñÆ÷£º 192.168.1.3 ¸±·þÎñÆ÷slave


A·þÎñÆ÷ÉèÖÃ

#mysql –u root –p
mysql>GRANT FILE ON *.* TO backup@192.168.1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ