MYSQLµÄÂý²éѯ·ÖÎö
http://www.cnblogs.com/amboyna/archive/2009/11/16/1603867.html
ÓÐÒ»¶ÎÈÕ×ÓÁË£¬Ôø¾ÉèÖÃÁËÒ»´Î¼Ç¼ÔÚmysqlÖвéѯÂýÓÚ1ÃëÖÓµÄSQLÓï¾ä¡£¸Õ²ÅͻȻ»ØÏëÉèÖõķ½·¨£¬Óм¸¸ö²ÎÊýµÄÃû³ÆËÀ»î»ØÒä²»ÆðÀ´ÁË£¬ÓÚÊÇÖØÐÂÕûÀíһϣ¬×Ô¼º×ö¸ö±Ê¼Ç¡£
¶ÔÓÚÅŲéÎÊÌâÕÒ³öÐÔÄÜÆ¿¾±À´Ëµ£¬×îÈÝÒ×·¢ÏÖ²¢½â¾öµÄÎÊÌâ¾ÍÊÇMYSQLµÄÂý²éѯÒÔ¼°Ã»ÓеÃÓÃË÷ÒýµÄ²éѯ¡£
OK£¬¿ªÊ¼ÕÒ³ömysqlÖÐÖ´ÐÐÆðÀ´²»“ˬ”µÄSQLÓï¾ä°É¡£
=========================================================
·½·¨Ò»£º Õâ¸ö·½·¨ÎÒÕýÔÚÓ㬺Ǻǣ¬±È½Ïϲ»¶ÕâÖÖ¼´Ê±ÐԵġ£
Mysql5.0ÒÔÉϵİ汾¿ÉÒÔÖ§³Ö½«Ö´ÐбȽÏÂýµÄSQLÓï¾ä¼Ç¼ÏÂÀ´¡£
mysql> show variables like 'long%'; ×¢£ºÕâ¸ölong_query_timeÊÇÓÃÀ´¶¨ÒåÂýÓÚ¶àÉÙÃëµÄ²ÅËã“Âý²éѯ”
+-----------------+-----------+
| Variable_name | Value |
+-----------------+-----------+
| long_query_time | 10.000000 |
+-----------------+-----------+
1 row in set (0.00 sec)
mysql> set long_query_time=1; ×¢£º ÎÒÉèÖÃÁË1, Ò²¾ÍÊÇÖ´ÐÐʱ¼ä³¬¹ý1ÃëµÄ¶¼ËãÂý²éѯ¡£
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like 'slow%';
+---------------------+---------------+
| Variable_name | Value |
+---------------------+---------------+
| slow_launch_time | 2 |
| slow_query_log | ON | ×¢£ºÊÇ·ñ´ò¿ªÈÕÖ¾¼Ç¼
| slow_query_log_file | /tmp/slow.log | ×¢£º ÉèÖõ½Ê²Ã´Î»ÖÃ
+---------------------+---------------+
3 rows in set (0.00 sec)
mysql> set global slow_query_log='ON' ×¢£º´ò¿ªÈÕÖ¾¼Ç¼
Ò»µ©slow_query_log±äÁ¿±»ÉèÖÃΪON£¬mysql»áÁ¢¼´¿ªÊ¼¼Ç¼¡£
/etc/my.cnf ÀïÃæ¿ÉÒÔÉèÖÃÉÏÃæMYSQLÈ«¾Ö±äÁ¿µÄ³õʼֵ¡£
long_query_time=1
slow_query_
Ïà¹ØÎĵµ£º
±ÊÕߣ¨mqboss£©½üÆÚÔÚ×öMySQL¼¯ÈºµÄ¼¼Êõµ÷ÑУ¬»á½Ðø°Ñ×Ô¼ºµÄÐĵÃÌå»áд³öÀ´ºÍ´ó¼Ò·ÖÏí£¬Çë´ó¼Ò¼ÌÐø¹Ø×¢¡£
1.´Ómysq¹Ù·½ÍøÕ¾ÏÂÔØ°²×°Îļþmysql-cluster-gpl-7.0.9-solaris10-sparc-64bit.tar.gz£¬²¢Í¨¹ýFTPÉÏ´«µ½Solaris·þÎñÆ÷ÉÏ£»
2.Ìí¼ÓÓû§×émysqlºÍÓû§mysql(×¢£ºmysqlÓû§ÊôÓÚmysqlÓû§×é)
shell> groupadd mys ......
MYSQL where id inÎÊÌâ
SELECT * from product WHERE id IN (‘1522,1523,1524′)ORDER BY id DESC
ÔÚMYSQLÀïÃæÖ´ÐÐÕâ¸öÓï¾äÖ»·µ»Ø1522µÄÖµ¡£
Ö´ÐÐ
SELECT * from product WHERE instr(‘1522,1523,1524′,id) ORDER BY id DESC
»òÕß
SELECT * from product WHERE instr(‘1522,1523,1524 ......
MySQLÐÔÄÜÓÅ»¯µÄ×î¼Ñ20+Ìõ¾Ñé
ÎÄÕ·ÖÀà:Êý¾Ý¿â
from£ºhttp://www.uml.org.cn/sjjm/201001041.asp
½ñÌ죬Êý¾Ý¿âµÄ²Ù×÷Ô½À´Ô½³ÉΪÕû¸öÓ¦ÓõÄÐÔÄÜÆ¿¾±ÁË£¬Õâµã¶ÔÓÚWebÓ¦ÓÃÓÈÆäÃ÷ÏÔ¡£¹ØÓÚÊý¾Ý¿âµÄÐÔÄÜ£¬Õâ²¢²»Ö»ÊÇDBA²ÅÐèÒªµ£ÐĵÄÊ£¬¶øÕâ¸üÊÇÎÒÃdzÌÐòÔ±ÐèҪȥ¹Ø×¢µÄÊÂÇé¡£µ±ÎÒÃÇÈ¥Éè¼ÆÊý¾Ý¿â±í½á¹¹£¬¶Ô²Ù×÷Êý¾Ý¿âʱ£¨ÓÈÆäÊ ......
mysql
ÓÐÒ»¸ö¹¦ÄܾÍÊÇ¿ÉÒÔlogÏÂÀ´ÔËÐеıȽÏÂýµÄsqlÓï¾ä£¬Ä¬ÈÏÊÇûÓÐÕâ¸ölogµÄ£¬ÎªÁË¿ªÆôÕâ¸ö¹¦ÄÜ£¬ÒªÐÞ¸Ämy.cnf»òÕßÔÚmysql
Æô¶¯µÄʱºò¼ÓÈëһЩ²ÎÊý¡£
Èç¹ûÔÚmy.cnfÀïÃæÐ޸ģ¬ÐèÔö¼ÓÈçϼ¸ÐÐ
long_query_time = 10
log-slow-queries =
long_query_time
ÊÇÖ¸Ö´Ðг¬¹ý¶à¾ÃµÄsql»á±»logÏÂÀ´£¬ÕâÀïÊÇ10Ãë¡£
log-slo ......