14,958
edits
(→PHP) |
(→MySQL) |
||
| Line 72: | Line 72: | ||
==== MySQL ==== | ==== MySQL ==== | ||
[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 ==== | ||