Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 ´ú±í½øÐÐÁ˺ܶà±íɨÃ裬²éѯÐÔÄܵÍÏ¡£


Ïà¹ØÎĵµ£º

ÔÚMySqlÖÐÌí¼ÓÔ¶³Ì³¬¼¶Óû§

1. ʹÓÃGRANTÓï¾äÌí¼Ó£ºÊ×ÏÈÔÚÊý¾Ý¿â±¾»úÉÏÓÃROOTÓû§
µÇ¼MySql£¨ÎÒÊÇÓÃÔ¶³Ì¿ØÖÆlinux·þÎñÆ÷£¬Ï൱ÓÚÔÚ·þÎñÆ÷±¾»úµÇ¼MySqlÁË£©£¬È»ºóÊäÈ룺
mysql>GRANT ALL PRIVILEGES ON *.* TO admin@localhost IDENTIFIED BY 'something' WITH GRANT OPTION;
Ìí¼ÓÒ»¸öÓû§admin²¢ÊÚȨͨ¹ý±¾µØ»ú£¨localhost)·ÃÎÊ£¬ÃÜÂë“s ......

ʹÓÃWAMP5´î½¨Apache+MySQL+PHP»·¾³

 Ä¿Ç°Óв»ÉÙAMP£¨Apache\MySQL\PHP£©µÄ¼¯³ÉÈí¼þ£¬¿ÉÒÔÈÃÎÒÃÇÒ»´Î°²×°²¢ÉèÖúá£Õâ¶ÔÓÚ²»ÊìϤAMPµÄÓû§À´Ëµ£¬ºÃ´¦¶à¶à¡£
Ò»¡¢Ê¹ÓÃAMP¼¯³ÉÈí¼þµÄÓŵ㣺
1¡¢¿É±ÜÃâÓÉÓÚȱ·¦AMPµÄ֪ʶ£¬¶øÎÞ·¨ÕýÈ·ÉèÖû·¾³£»
2¡¢¿É¿ìËÙ°²×°²¢ÉèÖúÃAMP»·¾³£¬ÈÃÎÒÃÇÖ±½Ó¿ªÊ¼ÕæÕý¸ÐÐËȤµÄÈí¼þ£¬Èçxoops£»
3¡¢¿É·½±ãµÄ´î½¨²âÊÔ»·¾³£¬¶ÔÓÚ² ......

ʹÓÃMYSQLÊý¾Ý¿â²åÈëͼƬʱ¹ØÓÚÊý¾Ý¿â×Ö·û¼¯µÄ´íÎó

 ÔÚʹÓÃJDBC²Ù×÷Êý¾Ý¿â ÔÚÏòÊý¾Ý¿âÖвåÈëͼƬʱ£¬³ÌÐòÀÏÊÇÅ×Òì³£
Ô­À´µÄMYSQL×Ö·û¼¯ÊÇGBK  µ«ÊÇÕâÖÖ×Ö·û¼¯ËäȻ֧³ÖÖÐÎÄ µ«Êǵ±²åÈëͼƬµÈ¶þ½øÖÆÊý¾Ýʱ »á³öÏÖ´íÎó
½â¾ö·½·¨£º
½«Êý¾Ý¿â×Ö·û¼¯¸ü¸ÄΪgb2312»òutf-8
1.ÔÚMYSQL DOS½çÃæÖÐÊäÈë  show  variables  like "%char%";
+---- ......

½éÉÜmysqlÊý¾Ý¿âÏÂshowÃüÁîµÄÖ÷ÒªÓ÷¨


¡¡¡¡
¡¡¡¡±¾ÎÄÖ÷Òª½éÉÜ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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ