4: 2016-06-09 (Thu) 02:35:32 iseki  |
Cur: 2016-06-10 (Fri) 11:06:18 iseki  |
| | | |
| *** DB の変数名が変わってる [#r345aa25] | | *** DB の変数名が変わってる [#r345aa25] |
- | - $variables[ 'log_slow_queries'] の log_slow_queries 等 (v5.5.45 → 10.0.21) | + | **** v5.5.45 → 10.0.21 [#d4c3c501] |
- | - log_slow_queries → slow_query_log | + | - $variables[ 'log_slow_queries'] の log_slow_queries 等 |
- | - log → general_log | + | -- log_slow_queries → slow_query_log |
| + | -- log → general_log |
| + | #br |
| + | *** Socket の場所 [#k65fff64] |
| + | - /var/lib/mysql/mysql.sock → /tmp/mysql.sock |
| + | - /var/lib/mysql/mysql.sock から /tmp/mysql.sock へシンボリックリンクを張る |
| #br | | #br |
| | | |
| *** 設定法 [#sf27ce4a] | | *** 設定法 [#sf27ce4a] |
| + | **** v5 [#m5b6c1c7] |
| + | - my.cnf |
| + | slow_query_log |
| + | slow_query_log-file=/var/log/mysql/slow.log |
| + | long_query_time=5 |
| + | |
| + | log=/var/log/mysql/query.log |
| + | |
| + | **** v10 [#j269c186] |
| + | - my.cnf |
| + | slow_query_log=ON |
| + | slow_query_log-file=/var/log/mysql/slow.log |
| + | long_query_time=5 |
| + | |
| + | general_log |
| + | general_log_file=/var/log/mysql/query.log |
| + | |
| + | **** DB Command (一時的) [#t33982fc] |
| - set global slow_query_log=ON; | | - set global slow_query_log=ON; |
| - set general_log=ON; | | - set general_log=ON; |
|
Today : |
    |
Yesterday : |
    |
Total : |
        |
|
|