14,958
edits
Testing: Difference between revisions
Jump to navigation
Jump to search
→MySQL
m (→case 1: Access the server from outside network ex: WAN: install telnet client on Mac) |
(→MySQL) |
||
| Line 214: | Line 214: | ||
==== MySQL ==== | ==== MySQL ==== | ||
[http://dev.mysql.com/doc/refman/5.1/en/server-logs.html MySQL Server Logs]: | [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> | * step1: verify the system variable<ref>[https://dev.mysql.com/doc/refman/5.7/en/show-variables.html MySQL :: MySQL 5.7 Reference Manual :: 13.7.5.39 SHOW VARIABLES Syntax]</ref> | ||
<pre> | |||
mysql> SHOW VARIABLES LIKE '%general_log%'; | |||
mysql> SHOW GLOBAL VARIABLES LIKE '%general_log%'; | |||
</pre> | |||
* step2: 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 228: | Line 233: | ||
</pre> | </pre> | ||
* | * step3: restart MySQL service | ||
==== Microsoft SQL Server ==== | ==== Microsoft SQL Server ==== | ||