Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
If you want to see English page, please click "English" Button at Left.
[
タイトル一覧
|
ページ一覧
|
新規
|
単語検索
|
最終更新
|
ヘルプ
]
mmeasure
をテンプレートにして作成
[
トップ
]
[ ]
開始行:
** mmeasure
- http://d.hatena.ne.jp/hogem/20100730/1280506394
- table_cache => table_open_cache
#br
** DB
*** DB の変数名が変わってる
**** v5.5.45 → 10.0.21
- $variables[ 'log_slow_queries'] の log_slow_queries 等
-- log_slow_queries → slow_query_log
-- log → general_log
#br
*** Socket の場所
- /var/lib/mysql/mysql.sock → /tmp/mysql.sock
- /var/lib/mysql/mysql.sock から /tmp/mysql.sock へシンボ...
#br
*** 設定法
**** v5
- 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
- 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 (一時的)
- set global slow_query_log=ON;
- set general_log=ON;
#br
*** Sample
- 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/m...
| 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/m...
| log_output | FILE ...
| log_queries_not_using_indexes | OFF ...
| log_slave_updates | OFF ...
| log_slow_filter | admin,file...
| log_slow_queries | ON ...
| log_slow_rate_limit | 1 ...
| log_slow_verbosity | ...
| log_warnings | 1 ...
| max_binlog_cache_size | 1844674407...
| max_binlog_size | 1073741824...
| max_binlog_stmt_cache_size | 1844674407...
| max_relay_log_size | 0 ...
| relay_log | ...
| relay_log_index | ...
| relay_log_info_file | relay-log....
| relay_log_purge | ON ...
| relay_log_recovery | OFF ...
| relay_log_space_limit | 0 ...
| slow_query_log | ON ...
| slow_query_log_file | /var/log/m...
| 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/m...
| 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/m...
| log_output | FILE ...
| log_queries_not_using_indexes | OFF ...
| log_slave_updates | OFF ...
| log_slow_filter | admin,file...
| log_slow_rate_limit | 1 ...
| log_slow_verbosity | ...
| log_warnings | 1 ...
| max_binlog_cache_size | 1844674407...
| max_binlog_size | 1073741824...
| max_binlog_stmt_cache_size | 1844674407...
| max_relay_log_size | 1073741824...
| relay_log | ...
| relay_log_index | ...
| relay_log_info_file | relay-log....
| relay_log_purge | ON ...
| relay_log_recovery | OFF ...
| relay_log_space_limit | 0 ...
| slow_query_log | ON ...
| slow_query_log_file | /var/log/m...
| 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)
終了行:
** mmeasure
- http://d.hatena.ne.jp/hogem/20100730/1280506394
- table_cache => table_open_cache
#br
** DB
*** DB の変数名が変わってる
**** v5.5.45 → 10.0.21
- $variables[ 'log_slow_queries'] の log_slow_queries 等
-- log_slow_queries → slow_query_log
-- log → general_log
#br
*** Socket の場所
- /var/lib/mysql/mysql.sock → /tmp/mysql.sock
- /var/lib/mysql/mysql.sock から /tmp/mysql.sock へシンボ...
#br
*** 設定法
**** v5
- 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
- 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 (一時的)
- set global slow_query_log=ON;
- set general_log=ON;
#br
*** Sample
- 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/m...
| 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/m...
| log_output | FILE ...
| log_queries_not_using_indexes | OFF ...
| log_slave_updates | OFF ...
| log_slow_filter | admin,file...
| log_slow_queries | ON ...
| log_slow_rate_limit | 1 ...
| log_slow_verbosity | ...
| log_warnings | 1 ...
| max_binlog_cache_size | 1844674407...
| max_binlog_size | 1073741824...
| max_binlog_stmt_cache_size | 1844674407...
| max_relay_log_size | 0 ...
| relay_log | ...
| relay_log_index | ...
| relay_log_info_file | relay-log....
| relay_log_purge | ON ...
| relay_log_recovery | OFF ...
| relay_log_space_limit | 0 ...
| slow_query_log | ON ...
| slow_query_log_file | /var/log/m...
| 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/m...
| 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/m...
| log_output | FILE ...
| log_queries_not_using_indexes | OFF ...
| log_slave_updates | OFF ...
| log_slow_filter | admin,file...
| log_slow_rate_limit | 1 ...
| log_slow_verbosity | ...
| log_warnings | 1 ...
| max_binlog_cache_size | 1844674407...
| max_binlog_size | 1073741824...
| max_binlog_stmt_cache_size | 1844674407...
| max_relay_log_size | 1073741824...
| relay_log | ...
| relay_log_index | ...
| relay_log_info_file | relay-log....
| relay_log_purge | ON ...
| relay_log_recovery | OFF ...
| relay_log_space_limit | 0 ...
| slow_query_log | ON ...
| slow_query_log_file | /var/log/m...
| 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)
ページ名:
サイト内 検索
高度な検索
ログイン
ユーザー名:
パスワード:
パスワード紛失
新規登録
サブ メニュー
新着情報
Books
リンク
サイトマップ
e-Learning
TUIS 認証局証明書
ミニカレンダー
2025年 5月
日
月
火
水
木
金
土
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<今日>
オンライン状況
74 人のユーザが現在オンラインです。 (2 人のユーザが xpwiki を参照しています。)
登録ユーザ: 0
ゲスト: 74
もっと...
アクセスカウンタ
今日 :
昨日 :
総計 :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com