[ת]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.ʲô½Ð×ö×Ö·û¼¯
×Ö·û¼¯¾ÍÊÇÒ»Ì×·ûºÅºÍ×Ö·û±àÂëµÄ¼¯ºÏ¡£
2.ʲô½Ð×öУ¶Ô¹æÔò
У¶Ô¹æÔò¾ÍÊÇÔÚ×Ö·û¼¯ÄÚÓÃÓڱȽÏ×Ö·ûµÄÒ»Ì×¹æÔò¡£
MYSQL5.1Êý¾Ý¿â¿ÉÒÔ×öµ½
· ʹÓöàÖÖ×Ö·û¼¯À´´æ´¢×Ö·û´®
· ʹÓöàÖÖУ¶Ô¹æÔòÀ´±È½Ï×Ö·û´®
· ÔÚͬһ̨·þÎñÆ÷¡¢Í¬Ò»¸öÊý¾Ý¿â»òÉõ ......
×î½üÓöµ½Ò»¸öÐèÇóÒªÔÚlinuxÏÂÓÃjava µ÷ÓÃmysql¿Í»§¶ËÔ¶³ÌµÇ½mysql·þÎñÆ÷£¬´Ó¿Í»§¶Ë»úÆ÷µ¼Èëmysql½Å±¾£¬´Ómysql·þÎñÆ÷¶Ëµ¼³ö±íÖеÄÊý¾Ý¡£ÒÔÏÂÊÇÓõ½µÄÖ÷Òª·½·¨£º
Java ´úÂë
/**
* µ¼ÈëÊý¾Ý
* @param ½Å±¾µÄµØÖ·ºÍÃû³Æ
* @return ÊÇ·ñ³ ......
×î½ü¹¤×÷Éϳ£Óõ½MySQL£¬·¢ÏÖMySQLµÄ´íÎóÌáʾÒô±È½Ï·³ÈË£¬ÉÏÍøËÑË÷ÁËһϣ¬ÓÐÒÔÏÂÈýÖֹرոÃÌáʾÒôµÄ·½·¨£º
·½·¨1. ʹÓÃÖÕ¶ËÃüÁî
ʹÓÃMySQLµÄÃüÁîÖÕ¶Ëʱ£¬Ê¹ÓÃmysql --no-beep¼´¿É¡£
·½·¨2. ÐÞ¸ÄMySQLÅäÖÃÎļþmy.ini
ÔÚ[mysql] ϼÓÈëÒ»ÐÐ
no-beep
&nb ......
my.iniÎļþÅäÖ㺠[mysql] default-character-set=GBK #´Ë´¦µÄ±àÂëÊÇMySQL¿ØÖÆ̨ÏÔʾµÄ±àÂ뷽ʽ£¬Ó¦¸ÃÉèÖÃΪGBK [mysqld] default-character-set=utf8 #´Ë´¦µÄ±àÂëÊÇMySQLÊý¾Ý´æ´¢µÄ¸ñʽ£¬Ó¦¸ÃÉèÖÃΪutf8£¬¿ÉÒÔ´æ´¢ÊÀ½çÉϾø´ó¶àÊý×Ö·û ......
1. ¶¨Òå
/*
Plugin system variables.
*/
static long sysvar_one_value;
static char *sysvar_two_value;
static MYSQL_SYSVAR_LONG(simple_sysvar_one, sysvar_one_value,
PLUGIN_VAR_RQCMDARG,
"Simple fulltext parser example system variab ......