Testing: Difference between revisions

Jump to navigation Jump to search
15 bytes added ,  9 July 2012
Line 72: Line 72:


==== MySQL ====
==== MySQL ====
* [http://dev.mysql.com/doc/refman/5.1/en/server-logs.html MySQL Server Logs]: enable logging /var/log/mysql.log (location was set up in the configuration file /etc/my.cnf or my.ini) and restart MySQL service<ref>[http://blog.longwin.com.tw/2005/10/mysql_query_slow_find/ 找出 MySQL 哪些 Query 速度較慢 | Tsung's Blog]</ref>
[http://dev.mysql.com/doc/refman/5.1/en/server-logs.html MySQL Server Logs]:
* step1: enable logging /var/log/mysql.log (location was set up in the configuration file /etc/my.cnf or my.ini) <ref>[http://blog.longwin.com.tw/2005/10/mysql_query_slow_find/ 找出 MySQL 哪些 Query 速度較慢 | Tsung's Blog]</ref>
<pre>
<pre>
[mysqld]  
[mysqld]  
Line 82: Line 83:
log-long-format
log-long-format
</pre>
</pre>
* step2: restart MySQL service


==== PHP ====
==== PHP ====

Navigation menu