4: 2016-06-09 (Thu) 02:35:32 iseki  |
Cur: 2016-06-10 (Fri) 11:06:18 iseki |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| *** 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; | ||
- Backup list of mmeasure
- Backup diff of mmeasure vs current(No. All)
- 1: 2013-04-23 (Tue) 17:57:49 iseki
- 2: 2013-04-23 (Tue) 18:06:02 iseki
- 3: 2013-04-25 (Thu) 10:00:15 iseki
- 4: 2016-06-09 (Thu) 02:35:32 iseki
