mysql ²é¿´Ë÷ÒýʹÓÃÇé¿ö
ÕâÊÇÒÔ¶ÁΪÖ÷µÄÏßÉÏ¿â
root@read 02:28:07>show status like ‘Handler_read%’;
+———————–+——-+
| Variable_name | Value |
+———————–+——-+
| Handler_read_first | 0 |
| Handler_read_key | 0 |
| Handler_read_next | 0 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_next | 61 |
+———————–+——-+
6 rows in set (0.41 sec)
Handler_read_first ´ú±í¶ÁÈ¡Ë÷ÒýÍ·µÄ´ÎÊý£¬Èç¹ûÕâ¸öÖµºÜ¸ß£¬ËµÃ÷È«Ë÷ÒýɨÃèºÜ¶à¡£
Handler_read_key´ú±íÒ»¸öË÷Òý±»Ê¹ÓõĴÎÊý£¬Èç¹ûÎÒÃÇÐÂÔö¼ÓÒ»¸öË÷Òý£¬¿ÉÒԲ鿴Handler_read_keyÊÇ·ñÓÐÔö¼Ó£¬Èç¹ûÓÐÔö¼Ó£¬ËµÃ÷sqlÓõ½Ë÷Òý¡£
Handler_read_next ´ú±í¶ÁÈ¡Ë÷ÒýµÄÏÂÁУ¬Ò»°ã·¢Éúrange scan¡£
Handler_read_prev ´ú±í¶ÁÈ¡Ë÷ÒýµÄÉÏÁУ¬Ò»°ã·¢ÉúÔÚORDER BY … DESC¡£
Handler_read_rnd ´ú±íÔڹ̶¨Î»ÖöÁÈ¡ÐУ¬Èç¹ûÕâ¸öÖµºÜ¸ß£¬ËµÃ÷¶Ô´óÁ¿½á¹û¼¯½øÐÐÁËÅÅÐò¡¢½øÐÐÁËÈ«±íɨÃè¡¢¹ØÁª²éѯûÓÐÓõ½ºÏÊʵÄKEY¡£
Handler_read_rnd_next ´ú±í½øÐÐÁ˺ܶà±íɨÃ裬²éѯÐÔÄܵÍÏ¡£
Ïà¹ØÎĵµ£º
1. ʹÓÃGRANTÓï¾äÌí¼Ó£ºÊ×ÏÈÔÚÊý¾Ý¿â±¾»úÉÏÓÃROOTÓû§
µÇ¼MySql£¨ÎÒÊÇÓÃÔ¶³Ì¿ØÖÆlinux·þÎñÆ÷£¬Ï൱ÓÚÔÚ·þÎñÆ÷±¾»úµÇ¼MySqlÁË£©£¬È»ºóÊäÈ룺
mysql>GRANT ALL PRIVILEGES ON *.* TO admin@localhost IDENTIFIED BY 'something' WITH GRANT OPTION;
Ìí¼ÓÒ»¸öÓû§admin²¢ÊÚȨͨ¹ý±¾µØ»ú£¨localhost)·ÃÎÊ£¬ÃÜÂë“s ......
Ä¿Ç°Óв»ÉÙAMP£¨Apache\MySQL\PHP£©µÄ¼¯³ÉÈí¼þ£¬¿ÉÒÔÈÃÎÒÃÇÒ»´Î°²×°²¢ÉèÖúá£Õâ¶ÔÓÚ²»ÊìϤAMPµÄÓû§À´Ëµ£¬ºÃ´¦¶à¶à¡£
Ò»¡¢Ê¹ÓÃAMP¼¯³ÉÈí¼þµÄÓŵ㣺
1¡¢¿É±ÜÃâÓÉÓÚȱ·¦AMPµÄ֪ʶ£¬¶øÎÞ·¨ÕýÈ·ÉèÖû·¾³£»
2¡¢¿É¿ìËÙ°²×°²¢ÉèÖúÃAMP»·¾³£¬ÈÃÎÒÃÇÖ±½Ó¿ªÊ¼ÕæÕý¸ÐÐËȤµÄÈí¼þ£¬Èçxoops£»
3¡¢¿É·½±ãµÄ´î½¨²âÊÔ»·¾³£¬¶ÔÓÚ² ......
ÔÚʹÓÃJDBC²Ù×÷Êý¾Ý¿â ÔÚÏòÊý¾Ý¿âÖвåÈëͼƬʱ£¬³ÌÐòÀÏÊÇÅ×Òì³£
ÔÀ´µÄMYSQL×Ö·û¼¯ÊÇGBK µ«ÊÇÕâÖÖ×Ö·û¼¯ËäȻ֧³ÖÖÐÎÄ µ«Êǵ±²åÈëͼƬµÈ¶þ½øÖÆÊý¾Ýʱ »á³öÏÖ´íÎó
½â¾ö·½·¨£º
½«Êý¾Ý¿â×Ö·û¼¯¸ü¸ÄΪgb2312»òutf-8
1.ÔÚMYSQL DOS½çÃæÖÐÊäÈë show variables like "%char%";
+---- ......
¡¡¡¡
¡¡¡¡±¾ÎÄÖ÷Òª½éÉÜmysqlÊý¾Ý¿âÏÂshowÃüÁîµÄÖ÷ÒªÓ÷¨£º
¡¡¡¡a. show tables»òshow tables from database_name; -- ÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ¡£
¡¡¡¡b. show databases; -- ÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ¡£
¡¡¡¡c. show columns from table_name from database_name; »òshow columns from database_name.table_n ......