ÔõôÑùÐÞ¸Ämysqlµ¼ÈëÎļþ´óСÏÞÖÆ
×Ô¼ºµçÄÔÉÏ×°µÄWAMP£¬ÔÚµ¼ÈëÊý¾Ý¿â±È½Ï´ó£¨´óÓÚ2M£©Ê±Óöµ½´íÎ󣬲»Äܵ¼Èë¡£
ÕÒµ½½â¾ö·½·¨£º php.iniÅäÖÃÎļþÖÐÓÐÈý´¦µØ·½ÐèÒª¸Ä¶¯£º
upload_max_filesize
memory_limit
post_max_size
ÕâÈý¸öÖµ¶¼¹¤¾ßʵ¼ÊÇé¿ö¸ÄÏ£¬ÖØÆô·þÎñÆ÷ÒÔºó£¬ËäÈ»µ¼ÈëʱÈÔÈ»ÏÔʾÊÇ ×î´óÏÞÖÆ£º2,048 KB) £» µ«Êµ¼ÊÉÏÒѾ¿ÉÒÔµ¼ÈëºÜ´óµÄÊý¾Ý¿âÁË¡£¡£¡£
Ïà¹ØÎĵµ£º
MySQL´¥·¢Æ÷
Ò»¡¢ MySQL´¥·¢Æ÷¸ÅÄî
MySQL5.0ÒÔÉϰ汾֧³Ö´¥·¢Æ÷£¬´¥·¢Æ÷ÊÇÓë±íÓйصÄÃüÃûÊý¾Ý¿â¶ÔÏ󣬵±±í³öÏÖÌØ¶¨Ê¼þʱ£¬½«¼¤»î¸Ã¶ÔÏó¡£
¶þ¡¢ MySQL´¥·¢Æ÷Óï·¨
CREATE TRIGGER trigger_name trigger_time trigger_event
ON tbl_name FOR EACH ROW trigger_stmt
trigger ......
2009-12-08 18:53
sql½Å±¾Êǰüº¬Ò»µ½¶à¸ösqlÃüÁîµÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ½«ÕâЩsql½Å±¾·ÅÔÚÒ»¸öÎı¾ÎļþÖУ¨ÎÒÃdzÆÖ®Îª“sql½Å±¾Îļþ”£©£¬È»ºóͨ¹ýÏà¹ØµÄÃüÁîÖ´ÐÐÕâ¸ösql½Å±¾Îļþ¡£»ù±¾²½ÖèÈçÏ£º
1¡¢´´½¨°üº¬sqlÃüÁîµÄsql½Å±¾Îļþ
ÎļþÖаüº¬Ò»Ð©ÁеÄsqlÓï¾ä£¬Ã¿ÌõÓï¾ä×îºóÒÔ;½á⣬ÎļþÄÚÈÝʾÀýÈçÏ£º
--´´½ ......
1, MySQL profiling
mysql> set profiling = 1;
mysql> select count(*) from test;
mysql> show profiles;
mysql> show profile for query 1;
2,mysql ¼à¿Ø
http://bbs.linuxtone.org/thread-1854-1-1.html
http://code.google.com/p/mysql-cacti-templates/ -> Hig ......
MySQLÖÐÓÃselectʵÏÖTOP N¹¦ÄÜ
ÏÈ˵¼¸¸ö¹Ø¼ü×Ö£º
distinct ·µ»Ø²»Öظ´µÄ¶àÁÐ
count() ¼ÆÊý
limit m,n µÚm¸öÆðn¸ö
ÄÇô£¬Èç¹ûÐèÒª²éÕÒÃûΪcolµÄijһ¸öÁеÄTop N£¬²¢Áгö¶ÔÓ¦µÄÖµµÄselectÓï¾ä¾ÍÈçÏ£º
select dinstinct(col),count(col) from tablename group by 1 order  ......