Mysql Explain Ïê½â[Ç¿ÁÒÍÆ¼ö]
Mysql Explain Ïê½â
Ò».Óï·¨
explain < table_name >
ÀýÈç: explain select * from t3 where id=3952602;
¶þ.explainÊä³ö½âÊÍ
+----+-------------+-------+-------+-------------------+---------+---------+-------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+-------+-------------------+---------+---------+-------+------+-------+
1.id
ÎÒµÄÀí½âÊÇSQLÖ´ÐеÄ˳ÀûµÄ±êʶ,SQL´Ó´óµ½Ð¡µÄÖ´ÐÐ.
ÀýÈç:
mysql> explain select * from (select * from ( select * from t3 where id=3952602) a) b;
+----+-------------+------------+--------+-------------------+---------+---------+------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+------------+--------+-------------------+---------+---------+------+------+-------+
| 1 | PRIMARY | <derived2> | system | NULL | NULL | NULL | NULL | 1 | |
| 2 | DERIVED | <derived3> | system | NULL | NULL | NULL | NULL | 1 | |
| 3 | DERIVED | t3 | const | PRIMARY,idx_t3_id | PRIMARY | 4 | | 1 | |
+----+-------------+------------+--------+-------------------+---------+---------+------+------+-------+
ºÜÏÔÈ»ÕâÌõSQLÊÇ´ÓÀïÏòÍâµÄÖ´ÐÐ,¾ÍÊÇ´Óid=3 ÏòÉÏÖ´ÐÐ.
2. select_type
¾ÍÊÇselectÀàÐÍ,¿ÉÒÔÓÐÒÔϼ¸ÖÖ
(1) SIMPL
Ïà¹ØÎĵµ£º
ÔÚÔËÐÐmysql administratorµÄʱºò,ÎÞ·¨µÇ¼mysql·þÎñÆ÷,²éÕÒ´íÎó,ÀÏÊÇÎÞ·¨½øÐÐ.ÔÚ½øÈëwindowsϵĹÜÀí¹¤¾ßµÄ·þÎñÖÐ,ÒÀÈ»ÎÞ·¨Æô¶¯,Ìáʾ˵ÊÇ´íÎó1067.½â¾ö·½°¸ÈçÏÂ:
1\½øÈëÃüÁîÌáʾ·û,ÊäÈë sc delete mysql
ÌáʾÈôÊÇdelete service success,Ö¤Ã÷ɾ³ý·þÎñ³É¹¦;
2\ÔËÐÐmysqlµÄbinĿ¼ÏÂÃæµÄmysqlinstanceconfig,¶Ômysql½øÐ ......
1. mysql Èë¿âÂÒÂëÎÊÌâ
½â¾ö°ì·¨
Ê×ÏÈ °²×°µÄʱºò±ØÐëÑ¡Ôñutf-8×Ö·û¼¯
Èç¹û²»ÊÇ¿ÉÒÔ½øÐÐÔÙ´ÎÅäÖûòÕßÉèÖÃÏà¹Ø±äÁ¿
£¨¿ÉÒÔÓà SHOW VARIABLES LIKE %CHARACTER%; ²é¿´ Óà set CHARACTER_** = UTF8£©
Æä´ÎÁ¬½ÓµÄʱºò Ö¸¶¨×Ö·û¼¯
jdbc:mysql://localhost/guestbooktes ......
°²×°ºó
/etc/init.d/mysql start (stop) ΪÆô¶¯ºÍÍ£Ö¹·þÎñÆ÷
/etc/mysql/ Ö÷ÒªÅäÖÃÎļþËùÔÚλÖà my.cnf
/var/lib/mysql/ ·ÅÖõÄÊÇÊý¾Ý¿â±íÎļþ¼Ð£¬ÕâÀïµÄmysqlÏ൱ÓÚwindowsÏÂmysqlµÄdateÎļþ¼Ð
Æô¶¯mysqlºó£¬ÒÔrootµÇ¼mysql
isher@isher-ubuntu:~$ mysql -u root
>show variables like 'character%'; #Ö´ÐбàÂëÏ ......
MySQL ÂÒÂëµÄ¸ùÔ´ÊÇµÄ MySQL ×Ö·û¼¯ÉèÖò»µ±µÄÎÊÌ⣬±¾ÎÄ»ã×ÜÁËÓйز鿴 MySQL ×Ö·û¼¯µÄÃüÁî¡£°üÀ¨²é¿´ MySQL Êý¾Ý¿â·þÎñÆ÷×Ö·û¼¯¡¢²é¿´ MySQL Êý¾Ý¿â×Ö·û¼¯£¬ÒÔ¼°Êý¾Ý±íºÍ×ֶεÄ×Ö·û¼¯¡¢µ±Ç°°²×°µÄ MySQL ËùÖ§³ÖµÄ×Ö·û¼¯µÈ¡£
Ò»¡¢²é¿´ MySQL Êý¾Ý¿â·þÎñÆ÷ºÍÊý¾Ý¿â×Ö·û¼¯¡£
mysql> show variables like '%char%';
+-- ......
1¡¢Ê×ÏÈ×Ô¼ºÐ½¨µÄÊý¾Ý¿â±àÂë¸ñʽÉèΪUTF-8
2¡¢½«mysql-connector-java-5.1.6-bin¿½±´µ½tomcat\LibĿ¼Ï¡£
3¡¢ÐÞ¸ÄTomcat\conf\ϵÄcontext.xmlÎļþÄÚÈÝÈçÏ£º
<Context>
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Resource
name="jdbc/mysqlds"
t ......