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

MYSQL ÄÚ´æ»úÖÆ


¶ÔÓÚÈκÎÒ»¸öÊý¾Ý¿â¹ÜÀíϵͳÀ´Ëµ£¬ÄÚ´æµÄ·ÖÅäʹÓþø¶Ô¿ÉÒÔËãµÄÉÏÊÇÆäºËÐÄÖ®Ò»ÁË£¬ËùÒԺܶàÏ£Íû¸üΪÉîÈëÁ˽âijÊý¾Ý¿â¹ÜÀíϵͳµÄÈË£¬¶¼»áÏ£ÍûÒ»¿ú¾¿¾¹£¬ÎÒÒ²²»ÀýÍâ¡£   
  
´ÓÄÚ´æµÄʹÓ÷½Ê½MySQL Êý¾Ý¿âµÄÄÚ´æÊ¹ÓÃÖ÷Òª·ÖΪÒÔÏÂÁ½Àà   
  
  
Ï̶߳ÀÏíÄÚ´æ    
È«¾Ö¹²ÏíÄÚ´æ   
  
Ï̶߳ÀÏíÄÚ´æ   
  
ÔÚ MySQL ÖУ¬Ï̶߳ÀÏíÄÚ´æÖ÷ÒªÓÃÓÚ¸÷¿Í»§¶ËÁ¬½ÓÏ̴߳洢¸÷ÖÖ²Ù×÷µÄ¶ÀÏíÊý¾Ý£¬ÈçÏß³ÌÕ»ÐÅÏ¢£¬·Ö×éÅÅÐò²Ù×÷£¬Êý¾Ý¶Áд»º³å£¬½á¹û¼¯ÔÝ´æµÈµÈ£¬¶øÇÒ´ó¶àÊý¿ÉÒÔͨ¹ýÏà¹Ø²ÎÊýÀ´¿ØÖÆÄÚ´æµÄʹÓÃÁ¿¡£   
  
Ïß³ÌÕ»ÐÅϢʹÓÃÄÚ´æ(thread_stack)£ºÖ÷ÒªÓÃÀ´´æ·Åÿһ¸öÏß³Ì×ÔÉíµÄ±êʶÐÅÏ¢£¬ÈçÏß³Ìid£¬Ïß³ÌÔËÐÐʱ»ù±¾ÐÅÏ¢µÈµÈ£¬ÎÒÃÇ¿ÉÒÔͨ¹ý thread_stack ²ÎÊýÀ´ÉèÖÃΪÿһ¸öÏß³ÌÕ»·ÖÅä¶à´óµÄÄÚ´æ¡£   
  
ÅÅÐòʹÓÃÄÚ´æ(sort_buffer_size)£ºMySQLÓôËÄÚ´æÇøÓò½øÐÐÅÅÐò²Ù×÷£¨filesort£©£¬Íê³É¿Í»§¶ËµÄÅÅÐòÇëÇó¡£µ±ÎÒÃÇÉèÖõÄÅÅÐòÇø»º´æ´óСÎÞ·¨Âú×ãÅÅÐòʵ¼ÊËùÐèÄÚ´æµÄʱºò£¬MySQL»á½«Êý¾ÝдÈë´ÅÅÌÎļþÀ´Íê³ÉÅÅÐò¡£ÓÉÓÚ´ÅÅ̺ÍÄÚ´æµÄ¶ÁдÐÔÄÜÍêÈ«²»ÔÚÒ»¸öÊýÁ¿¼¶£¬ËùÒÔsort_buffer_size²ÎÊý¶ÔÅÅÐò²Ù×÷µÄÐÔÄÜÓ°Ïì¾ø¶Ô²»¿ÉСÊÓ¡£   
  
Join²Ù×÷ʹÓÃÄÚ´æ(join_buffer_size)£ºÓ¦ÓóÌÐò¾­³£»á³öÏÖһЩÁ½±í£¨»ò¶à±í£©JoinµÄ²Ù×÷ÐèÇó£¬MySQLÔÚÍê³ÉijЩ Join ÐèÇóµÄʱºò£¨all/indexjoin£©£¬ÎªÁ˼õÉÙ²ÎÓëJoinµÄ“±»Çý¶¯±í”µÄ¶ÁÈ¡´ÎÊýÒÔÌá¸ßÐÔÄÜ£¬ÐèҪʹÓõ½ Join Buffer À´Ð­ÖúÍê³É Join²Ù×÷¡£µ± Join Buffer Ì«Ð¡£¬MySQL ²»»á½«¸Ã Buffer ´æÈë´ÅÅÌÎļþ£¬¶øÊÇÏȽ«Join BufferÖеĽá¹û¼¯ÓëÐèÒª JoinµÄ±í½øÐРJoin ²Ù×÷£¬È»ºóÇå¿Õ Join Buffer ÖеÄÊý¾Ý£¬¼ÌÐø½«Ê£ÓàµÄ½á¹û¼¯Ð´Èë´Ë BufferÖУ¬Èç´ËÍù¸´¡£ÕâÊÆ±Ø»áÔì³É±»Çý¶¯±íÐèÒª±»¶à´Î¶ÁÈ¡£¬³É±¶Ôö¼Ó IO ·ÃÎÊ£¬½µµÍЧÂÊ¡£   
  
˳Ðò¶ÁÈ¡Êý¾Ý»º³åÇøÊ¹ÓÃÄÚ´æ(read_buffer_size)£ºÕⲿ·ÖÄÚ´æÖ÷ÒªÓÃÓÚµ±ÐèҪ˳Ðò¶ÁÈ¡Êý¾ÝµÄʱºò£¬ÈçÎÞ·¢Ê¹ÓÃË÷ÒýµÄÇé¿öϵÄÈ«±íɨÃ裬ȫË÷ÒýɨÃèµÈ¡£ÔÚÕâÖÖʱºò£¬MySQL°´ÕÕÊý¾ÝµÄ´æ´¢Ë³ÐòÒÀ´Î¶ÁÈ¡Êý¾Ý¿é£¬Ã¿´Î¶ÁÈ¡µÄÊý¾Ý¿ìÊ×ÏÈ»


Ïà¹ØÎĵµ£º

mysql Ë÷Òý key µÄÓ÷¨

mysql> desc aa;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | YES  |     | NULL    |     &n ......

mysql 4.1.12


MySQL 4.1.12°²×°Æª
[Ïà¹ØÈí¼þÏÂÔØ£º]
Mysql 4.1.12-win32 -
For Windows ( Mysql 4.1.12-win32.exe ) -- Êý¾Ý¿â·þÎñ
ÏÂÔØµØÖ·£º
http://cdgwbn.downloadsky.com:8080/down/mysql-4.1.12-win32.zip
Connector/ODBC
- MySQL ODBC driver ( MyODBC-3.51.11-1-win.exe ) -- Êý¾ÝÔ´
ÏÂÔØµØÖ·£º
http://down.21sun.ne ......

mysql Ìí¼ÓÓû§µÄÃüÁî

Ò»¡¢´´½¨Óû§µÄÃüÁî
mysql> create user 'username'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.06 sec)
¶þ¡¢¸øÐ¼ÓÓû§ÊÚÓèȨÏÞ
mysql> grant all privileges on test.* to 'username'@'localhost';
Query OK, 0 rows affected (0.00 sec)
˵Ã÷£ºÕâÌõÃüÁîÊÚÓè username ¶ÔÊý¾Ý¿â te ......

½â¾öMySQL²»ÔÊÐí´ÓÔ¶³Ì·ÃÎʵķ½·¨

½â¾ö·½·¨£º
1¡£ ¸Ä±í·¨¡£
¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
mysql -u root -p vmware mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mys ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ