mysqlÐÔÄܵļì²éºÍµ÷ÓÅ·½·¨
ÎÒÒ»Ö±ÊÇʹÓÃmysqlÕâ¸öÊý¾Ý¿âÈí¼þ£¬Ëü¹¤×÷±È½ÏÎȶ¨£¬Ð§ÂÊÒ²ºÜ¸ß¡£ÔÚÓöµ½ÑÏÖØÐÔÄÜÎÊÌâʱ£¬Ò»°ã¶¼ÓÐÕâô¼¸ÖÖ¿ÉÄÜ£º
1¡¢Ë÷ÒýûÓн¨ºÃ£»
2¡¢sqlд·¨¹ýÓÚ¸´ÔÓ£»
3¡¢ÅäÖôíÎó£»
4¡¢»úÆ÷ʵÔÚ¸ººÉ²»ÁË£»
1¡¢Ë÷ÒýûÓн¨ºÃ
Èç¹û¿´µ½mysqlÏûºÄµÄcpuºÜ´ó£¬¿ÉÒÔÓÃmysqlµÄclient¹¤¾ßÀ´¼ì²é¡£
ÔÚlinuxÏÂÖ´ÐÐ
/usr/local/mysql/bin/mysql -hlocalhost -uroot -p
ÊäÈëÃÜÂ룬Èç¹ûûÓÐÃÜÂ룬Ôò²»ÓÃ-p²ÎÊý¾Í¿ÉÒÔ½øµ½¿Í»§¶Ë½çÃæÖС£
¿´¿´µ±Ç°µÄÔËÐÐÇé¿ö
show full processlist
¿ÉÒÔ¶àÔËÐм¸´Î
Õâ¸öÃüÁî¿ÉÒÔ¿´µ½µ±Ç°ÕýÔÚÖ´ÐеÄsqlÓï¾ä£¬Ëü»á¸æÖªÖ´ÐеÄsql¡¢Êý¾Ý¿âÃû¡¢Ö´ÐеÄ״̬¡¢À´×ԵĿͻ§¶Ëip¡¢ËùʹÓõÄÕʺš¢ÔËÐÐʱ¼äµÈÐÅÏ¢
ÔÚÎÒµÄcacheºó¶Ë£¬ÕâÀïÃæ´ó²¿·Öʱ¼äÊÇ¿´²»µ½ÏÔʾÈκÎsqlÓï¾äµÄ£¬ÎÒÈÏΪÕâÑù²ÅËã±È½ÏÕý³£¡£Èç¹û¿´µ½ÓкܶàsqlÓï¾ä£¬ÄÇôÕą̂mysql¾ÍÒ»¶¨»áÓÐÐÔÄÜÎÊÌâ
Èç¹û³öÏÖÁËÐÔÄÜÎÊÌ⣬Ôò¿ÉÒÔ½øÐзÖÎö£º
1¡¢ÊDz»ÊÇÓÐsqlÓï¾ä¿¨×¡ÁË£¿
ÕâÊdzöÏֱȽ϶àµÄÇé¿ö£¬Èç¹ûÊý¾Ý¿âÊDzÉÓÃmyisam£¬ÄÇôÓпÉÄÜÓÐÒ»¸öдÈëµÄÏ̻߳á°ÑÊý¾Ý±í¸øËø¶¨ÁË£¬Èç¹ûÕâÌõÓï¾ä²»½áÊø£¬ÔòÆäËüÓï¾äÒ²ÎÞ·¨ÔËÐС£
²é¿´processlistÀïµÄtimeÕâÒ»Ï¿´¿´ÓÐûÓÐÖ´ÐÐʱ¼äºÜ³¤µÄÓï¾ä£¬ÒªÁôÒâÕâЩÓï¾ä¡£
2¡¢´óÁ¿ÏàͬµÄsqlÓï¾äÕýÔÚÖ´ÐÐ
Èç¹û³öÏÖÕâÖÖÇé¿ö£¬ÔòÓпÉÄÜÊǸÃsqlÓï¾äÖ´ÐеÄЧÂʵÍÏ£¬Í¬ÑùÒªÁôÒâÕâЩÓï¾ä¡£
È»ºó°ÑÄãËù»³ÒɵÄÓï¾äͳͳ¼¯ºÏһϣ¬ÓÃdesc£¨explain£©À´¼ì²éÕâЩÓï¾ä¡£
Ê×ÏÈ¿´¿´Ò»¸öÕý³£µÄdescÊä³ö£º
mysql> desc select * from imgs where imgid=1651768337;
+----+-------------+-------+-------+---------------+---------+---------+-------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+-------+---------------+---------+---------+-------+------+-------+
| 1 | SIMPLE | imgs | const | PRIMARY | PRIMARY | 8 | const | 1 | |
+----+-------------+-------+-------+---------------+---------+---------+-------+------+-------+
1 row in set (0.00 sec)
×¢Òâkey¡¢rowsºÍExtraÕâÈýÏÕ
Ïà¹ØÎĵµ£º
1£¬ÉèÖÃmysqlĬÈϱàÂë
Ê×ÏȲéѯһÏÂshow variables like 'character%';
È·¶¨ËùÓеÄcharacter¶¼ÉèÖóÉutf-8
²Î¿¼ http://www.diybl.com/course/7_databases/mysql/myxl/20081127/152726.html
mysql>show variables like 'character%';
+--------------------------+--------------------------- ......
ÓÉÓÚ°²×°MySQLµÄʱºò£¬ÊèºöûÓÐÑ¡Ôñµ×²ã±àÂ뷽ʽ£¬²ÉÓÃĬÈϵÄASCIIµÄ±àÂë¸ñʽ£¬ÓÚÊǽӶþÁ¬ÈýµÄÖÐÎÄת»»ÎÊÌâËæÖ®¶øÀ´£¬¾ÍÏëжÔØÁËÖØа²×°MYSQL£¬ÕâһжÔص¹ÊdzöÁËÎÊÌ⣬µ¼Ö°²×°µÄʱºò°²×°²»ÉÏ£¬ÔÚÍøÉÏÕÒÁËÒ»¸ö¶àСʱҲû½â¾ö¡£
ÖØװϵͳÓÀÔ¶ÊǸöºÃ°ì·¨£¬µ«ÓÐËϲ»¶Õâô×öѽ:(
ºóÀ´ÎÞÒâ·¢ÏÖÊÇжÔصÄʱºòûÓÐжÔØÍêÈ«µ¼Ö£ ......
ÍêÈ«°²×°°ü
http://mysql.isu.edu.tw/Downloads/MySQL-5.1/mysql-5.1.38-win32.msi
°üº¬ÁË°²×°MySQLËùÐèÒªµÄÈ«²¿ÎļþÓëÅäÖÃÏòµ¼ÒÔ¼°¿ÉÑ¡×é¼þ£¬Èç»ù×¼Ì×¼þºÍǶÈëʽ·þÎñÆ÷
»ù±¾°²×°°ü
http://mysql.isu.edu.tw/Downloads/MySQL-5.1/mysql-essential-5.1.38-win32.msi
Ö»°üº¬ÁË°²×°MySQLËùÐèÒªµÄ»ù±¾ÎļþÓëÅäÖÃÏòµ¼£¬µ«ÊÇ ......
Ô±¾µÄÄ¿µÄÊǽ«Êý¾Ý¿â´ÓMS SQL 2000ǨÒƵ½MySQLÖУ¬µ«ÌáʾJDBCÁ¬½Óʧ°Ü£¬ÎÞÄÎÖ®¼«£¬Ö»ºÃÑ¡ÔñÖмäÇÅÁºAccessÍê³ÉÕâÏîÁîÈËÌÖÑáµÄ¹¤×÷ÁË¡£
´ó¸Å²½ÖèÈçÏ£º
1£¬´ÓMS SQL 2000½«Êý¾Ýµ¼³öµ½AccessÖУ¬ÓÐ¹Ø±í¶¨ÒåºÃÖ÷¼üºÍ×Ô¶¯±àºÅ²¿·Ö²»È»Ç¨ÒƺóÓÖµÃÐÞ¸ÄMySQLµÄ±í¡£
2£¬ÐÞ¸ÄAccess±íÖйÜÀíÔ±×é¡¢¹ÜÀíÔ±µÄȨÏÞ£¬±£Ö¤AccessµÄÄÚÖà ......
MySQL Reference Manual for version 4.1.0-alpha.
¡¡ÒëÕßÐò
¡¡ÁÐÀàÐÍÓ뺯ÊýË÷Òý
6 MySQL ÓïÑԲο¼
6.1 ÓïÑԽṹ
6.1.1 ÎÄ×Ö£ºÔõôд×Ö·û´®ÓëÊý×Ö
6.1.1.1 ×Ö·û´®
6.1.1.2 Êý×Ö
6.1.1.3 Ê®Áù½øÖÆÖµ
......