2: 2013-04-23 (火) 18:06:02 iseki  |
現: 2016-06-10 (金) 11:06:18 iseki |
| | ** mmeasure [#k0ffb34a] | | ** mmeasure [#k0ffb34a] |
| | + | - http://d.hatena.ne.jp/hogem/20100730/1280506394 |
| | - table_cache => table_open_cache | | - table_cache => table_open_cache |
| | + | |
| | + | #br |
| | + | ** DB [#f602ff2b] |
| | + | |
| | + | *** DB の変数名が変わってる [#r345aa25] |
| | + | **** v5.5.45 → 10.0.21 [#d4c3c501] |
| | + | - $variables[ 'log_slow_queries'] の log_slow_queries 等 |
| | + | -- 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 |
| | + | |
| | + | *** 設定法 [#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 general_log=ON; |
| | + | #br |
| | + | |
| | + | *** Sample [#l47f6693] |
| | + | - v5.5.45 |
| | + | MariaDB [mysql]> show variables like '%log%'; |
| | + | +-------------------------------------------+--------------------------------------------------------------------------------------------------------------+ |
| | + | | Variable_name | Value | |
| | + | +-------------------------------------------+--------------------------------------------------------------------------------------------------------------+ |
| | + | | aria_checkpoint_log_activity | 1048576 | |
| | + | | aria_log_file_size | 1073741824 | |
| | + | | aria_log_purge_type | immediate | |
| | + | | aria_sync_log_dir | NEWFILE | |
| | + | | back_log | 50 | |
| | + | | binlog_annotate_row_events | OFF | |
| | + | | binlog_cache_size | 32768 | |
| | + | | binlog_checksum | NONE | |
| | + | | binlog_direct_non_transactional_updates | OFF | |
| | + | | binlog_format | STATEMENT | |
| | + | | binlog_optimize_thread_scheduling | ON | |
| | + | | binlog_stmt_cache_size | 32768 | |
| | + | | expire_logs_days | 0 | |
| | + | | general_log | ON | |
| | + | | general_log_file | /var/log/mysql/query.log | |
| | + | | innodb_flush_log_at_trx_commit | 1 | |
| | + | | innodb_locks_unsafe_for_binlog | OFF | |
| | + | | innodb_log_block_size | 512 | |
| | + | | innodb_log_buffer_size | 8388608 | |
| | + | | innodb_log_file_size | 67108864 | |
| | + | | innodb_log_files_in_group | 2 | |
| | + | | innodb_log_group_home_dir | ./ | |
| | + | | innodb_mirrored_log_groups | 1 | |
| | + | | innodb_recovery_update_relay_log | OFF | |
| | + | | innodb_use_global_flush_log_at_trx_commit | ON | |
| | + | | log | ON | |
| | + | | log_bin | OFF | |
| | + | | log_bin_trust_function_creators | OFF | |
| | + | | log_error | /var/log/mysql/mysqld.log | |
| | + | | log_output | FILE | |
| | + | | log_queries_not_using_indexes | OFF | |
| | + | | log_slave_updates | OFF | |
| | + | | log_slow_filter | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk | |
| | + | | log_slow_queries | ON | |
| | + | | log_slow_rate_limit | 1 | |
| | + | | log_slow_verbosity | | |
| | + | | log_warnings | 1 | |
| | + | | max_binlog_cache_size | 18446744073709547520 | |
| | + | | max_binlog_size | 1073741824 | |
| | + | | max_binlog_stmt_cache_size | 18446744073709547520 | |
| | + | | max_relay_log_size | 0 | |
| | + | | relay_log | | |
| | + | | relay_log_index | | |
| | + | | relay_log_info_file | relay-log.info | |
| | + | | relay_log_purge | ON | |
| | + | | relay_log_recovery | OFF | |
| | + | | relay_log_space_limit | 0 | |
| | + | | slow_query_log | ON | |
| | + | | slow_query_log_file | /var/log/mysql/slow.log | |
| | + | | sql_log_bin | ON | |
| | + | | sql_log_off | OFF | |
| | + | | sync_binlog | 0 | |
| | + | | sync_relay_log | 0 | |
| | + | | sync_relay_log_info | 0 | |
| | + | +-------------------------------------------+--------------------------------------------------------------------------------------------------------------+ |
| | + | 54 rows in set (0.00 sec) |
| | + | |
| | + | - v10.0.21 |
| | + | MariaDB [mysql]> show variables like '%log%'; |
| | + | +-------------------------------------------+--------------------------------------------------------------------------------------------------------------+ |
| | + | | Variable_name | Value | |
| | + | +-------------------------------------------+--------------------------------------------------------------------------------------------------------------+ |
| | + | | aria_checkpoint_log_activity | 1048576 | |
| | + | | aria_log_file_size | 1073741824 | |
| | + | | aria_log_purge_type | immediate | |
| | + | | aria_sync_log_dir | NEWFILE | |
| | + | | back_log | 150 | |
| | + | | binlog_annotate_row_events | OFF | |
| | + | | binlog_cache_size | 32768 | |
| | + | | binlog_checksum | NONE | |
| | + | | binlog_commit_wait_count | 0 | |
| | + | | binlog_commit_wait_usec | 100000 | |
| | + | | binlog_direct_non_transactional_updates | OFF | |
| | + | | binlog_format | STATEMENT | |
| | + | | binlog_optimize_thread_scheduling | ON | |
| | + | | binlog_stmt_cache_size | 32768 | |
| | + | | expire_logs_days | 0 | |
| | + | | general_log | ON | |
| | + | | general_log_file | /var/log/mysql/query.log | |
| | + | | gtid_binlog_pos | | |
| | + | | gtid_binlog_state | | |
| | + | | innodb_api_enable_binlog | OFF | |
| | + | | innodb_flush_log_at_timeout | 1 | |
| | + | | innodb_flush_log_at_trx_commit | 1 | |
| | + | | innodb_locks_unsafe_for_binlog | OFF | |
| | + | | innodb_log_arch_dir | ./ | |
| | + | | innodb_log_arch_expire_sec | 0 | |
| | + | | innodb_log_archive | OFF | |
| | + | | innodb_log_block_size | 512 | |
| | + | | innodb_log_buffer_size | 8388608 | |
| | + | | innodb_log_checksum_algorithm | innodb | |
| | + | | innodb_log_compressed_pages | ON | |
| | + | | innodb_log_file_size | 67108864 | |
| | + | | innodb_log_files_in_group | 2 | |
| | + | | innodb_log_group_home_dir | ./ | |
| | + | | innodb_mirrored_log_groups | 1 | |
| | + | | innodb_online_alter_log_max_size | 134217728 | |
| | + | | innodb_undo_logs | 128 | |
| | + | | innodb_use_global_flush_log_at_trx_commit | ON | |
| | + | | log_bin | OFF | |
| | + | | log_bin_trust_function_creators | OFF | |
| | + | | log_error | /var/log/mysql/mysqld.log | |
| | + | | log_output | FILE | |
| | + | | log_queries_not_using_indexes | OFF | |
| | + | | log_slave_updates | OFF | |
| | + | | log_slow_filter | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk | |
| | + | | log_slow_rate_limit | 1 | |
| | + | | log_slow_verbosity | | |
| | + | | log_warnings | 1 | |
| | + | | max_binlog_cache_size | 18446744073709547520 | |
| | + | | max_binlog_size | 1073741824 | |
| | + | | max_binlog_stmt_cache_size | 18446744073709547520 | |
| | + | | max_relay_log_size | 1073741824 | |
| | + | | relay_log | | |
| | + | | relay_log_index | | |
| | + | | relay_log_info_file | relay-log.info | |
| | + | | relay_log_purge | ON | |
| | + | | relay_log_recovery | OFF | |
| | + | | relay_log_space_limit | 0 | |
| | + | | slow_query_log | ON | |
| | + | | slow_query_log_file | /var/log/mysql/slow.log | |
| | + | | sql_log_bin | ON | |
| | + | | sql_log_off | OFF | |
| | + | | sync_binlog | 0 | |
| | + | | sync_relay_log | 0 | |
| | + | | sync_relay_log_info | 0 | |
| | + | +-------------------------------------------+--------------------------------------------------------------------------------------------------------------+ |
| | + | 64 rows in set (0.00 sec) |
