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

mysqlÏà¹Ø

ÏÔʾ¡¢ÉèÖÃ×Ô¶¯Ìá½» show variable like 'autocommit'    set autocommit=1 or 0
ÉèÖÃÈÕÖ¾£º
ÔÚ/etc/mysql/my.cnfÖÐÉèÖÃÈçÏ¿ÉÔÙslow.logÖÐÊä³öÔËÐÐʱ¼ä³¬¹ýÒ»ÃëµÄsqlÓï¾ä
[mysqld]
log-slow-queries = /tmp/slow.log
long_query_time = 1
ÉèÖÃÈÕÖ¾Êä³öÔËÐг¬¹ý1ÃëµÄsqlÓï¾ä set global long_query_time = 1;
ÉèÖÃÈÕÖ¾Êä³ö·½Ê½ÎªÎļþ set global log_output=file;
ÉèÖÃgeneralÎļþ´æ·Å·¾¶ set global general_log_file='/tmp/general.log';
ÉèÖÃslowÎļþ´æ·Å·¾¶ set global slow_query_log_file='/tmp/slow.log';
ÆôÓÃgeneralºÍslow set global general_log=on;
set global slow_query_log=on;
°ÑûÓÐʹÓÃË÷ÒýµÄ²éѯ¼Ç¼µ½ÂýËÙ²éѯÈÕÖ¾ÖÐ SET GLOBAL log_queries_not_using_indexes = 1 
¼ì²éÊÇ·ñÆôÓÃÁËÈÕÖ¾ show variables like 'log_bin';
ÏÔʾµ±Ç°ÈÕÖ¾ÎļþÃû show master status;
²éѯ long_query_time µÄÖµ show variables like 'long%';
·ÖÎöslow.logÎļþ¹¤¾ß
mysqldumpslow -s c -t 20 host-slow.log
mysqldumpslow -s r -t 20 host-slow.log
ÉÏÊöÃüÁî¿ÉÒÔ¿´³ö·ÃÎÊ´ÎÊý×î¶àµÄ20¸ösqlÓï¾äºÍ·µ»Ø¼Ç¼¼¯×î¶àµÄ20¸ösql¡£
mysqldumpslow -t 10 -s t -g “left join” host-slow.log
Õâ¸öÊǰ´ÕÕʱ¼ä·µ»ØÇ°10ÌõÀïÃæº¬ÓÐ×óÁ¬½ÓµÄsqlÓï¾ä¡£
show status like 'last_query_cost'; ÉÏÒ»´Î²éѯÔì³É¶àÉÙ´ÎËæ¼´¶ÁÈ¡
ÖÜÆÚÐÔÔËÐÐshow status²¢ºÍǰһ´Î×÷±È½Ï mysqladmin extended -r -i 10
Ö÷´Ó·þÎñÆ÷ͬ²½
show slave status\G;
start slave;
stop slave;
¼ì²é·þÎñÆ÷¶Ë¿ÚʹÓÃÇé¿ö -i: ¶Ë¿ÚºÅ£¬-p ½ø³ÌºÅ
lsof -i:8009 | wc -l
mysql»º´æ
have_query_cache ÊÇ·ñÖ§³Ö²éѯ»º´æÇø “YES”±íÊÇÖ§³Ö²éѯ»º´æÇø
query_cache_limit ¿É»º´æµÄSelect²éѯ½á¹ûµÄ×î´óÖµ 1048576 byte /1024 = 1024kB ¼´×î´ó¿É»º´æµÄselect²éѯ½á¹û±ØÐëСÓÚ1024KB
query_cache_min_res_unit Ã¿´Î¸øquery cache½á¹û·ÖÅäÄÚ´æµÄ´óС ĬÈÏÊÇ 4096 byte Ò²¼´ 4kB query_cache_min_res_unit = (query_cache_size - Qcache_free_memory) / Qcache_queries_in_cache
Qcache_free_memory ±íʾ²éѯ»º´æÇøÏÖÔÚ»¹ÓжàÉٵĿÉÓÃÄÚ´æ
Qcache_hits ±íʾ²éѯ»º´æÇøµÄÃüÖиöÊý£¬Ò²¾ÍÊÇÖ±½Ó´Ó²éѯ»º´æÇø×÷³öÏìÓ¦´¦ÀíµÄ²éѯ¸öÊý
Qcache_inserts ±íʾ²éѯ»º´æÇø´


Ïà¹ØÎĵµ£º

½â¾öFlex+amfphp+MySQLÖÐÎÄÂÒÂëµÄ·½·¨


Ê×ÏÈ£ºÈ·¶¨Êý¾Ý¿âµÄ±àÂëΪutf8£¬Õý³£´¢´æÖÐÎÄ£¨ÓÃMySQL-Front²é¿´ÖÐÎÄÊÇ·ñÕý³££©
È»ºó£ºServices²éѯMySQLʱʹÓÃ"SET NAMES 'utf8'"£¬ÇÒͨ¹ý"amfphp/browser"ÔËÐп´¿´ÊÇ·ñÖÐÎÄ£¬Èç¹ûÂÒÂëÔòÐÞ¸Ägateway.phpÎļþ£¬È¥µô $gateway->setCharsetHandler("utf8_decode", "ISO-8859-1", "ISO-8859-1");
×îºó£ºÔËÐÐFlex³ÌÐòÏÔ ......

ÐÞ¸ÄMYSQLÃÜÂë


ÏÈÓÃrootµÇ½mysql   -u   root   -p  
  mysql>show   databases;  
  mysql>use   mysql;  
update   user   set   password=password('ÄãÏëÉèÖõÄÃÜÂë')  
where   user='root';   ......

UbuntuÎÞ·¨µÇ¼mysqlµÄ½â¾ö·½·¨

/**********************by garcon1986***************************************/
´íÎó´úÂëÈçÏ£º
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
$cd /etc/mysql
$mysql -u root -p
³öÏÖ´íÎó#1045
³¢ÊÔÁ˺ܶ෽·¨ºó£¬ÔÚÍøÂçÉÏÕÒµ½Á˽â¾ö·½·¨¡£
$cd /etc/mysql
$gedit debian.cnf
ÕÒµ½ ......

mysql ʱ¼äº¯Êý

1.DATE_FORMAT('2010-05-15 15:47:36','%H:%i:%s')   ->       ½á¹û£º15:47:36
    ½«ÈÕÆÚ¸ñʽ¸ù¾ÝÌõ¼þ²»Í¬×ª»»³ÉËùÐèÒªµÄÈÕÆÚ¡¢Ê±¼ä¸ñʽ
2.timediff('23:40:00', ' 18:30:00')  ->     ½á¹û£º05:10:00
    ......

½«mysqlµÄ±íµ¼³öµ½excel

  ÓÃMYSQLÓï¾ä£º  
  mysql   -uroot   -p^^^^^  -e   "select   *   from   test.table2"   >   d:\a.xls
ÆäÖÐtestΪÊý¾Ý¿â table2ΪÆäÖÐµÄ±í    d:\a.xlsΪ±íλÖà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ