Network System Laboratory - Source of mmeasure

View the diff.
Go to mmeasure.
** mmeasure [#k0ffb34a]
- http://d.hatena.ne.jp/hogem/20100730/1280506394
- 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)
« Prev
Backup list of mmeasure
Backup source of mmeasure(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
- Cur: 2016-06-10 (Fri) 11:06:18 iseki
Source of mmeasure

Site Search

Login

Sub Menu

Books

mini Calendar

Who's Online

Access Counter
