MySQLserverlogmanage-创新互联
####
Binary Log
binlog_cache_size的大小必须为4096的倍数，不然会有一个warning， “Warning | 1292 | Truncated incorrect binlog_cache_size value: '33792'”，然后向下取最接近n个4096的值。
mysql> show warnings;
+---------+------+------------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------------+
| Warning | 1292 | Truncated incorrect binlog_cache_size value: '33792' |
+---------+------+------------------------------------------------------+
1 row in set (0.0
SET GLOBAL binlog_format = 'STATEMENT';
SET GLOBAL binlog_format = 'ROW';
SET GLOBAL binlog_format = 'MIXED';
SET SESSION binlog_format = 'STATEMENT';
SET SESSION binlog_format = 'ROW';
SET SESSION binlog_format = 'MIXED';
set global binlog_cache_size=4096*n;
log_bin = /data/my3306/bin_log/mysql_bin
binlog_format = row
binlog_cache_size=4096*n
#################
general log
mysql> SHOW global variables like '%general%';
+------------------+---------------------------+
| Variable_name | Value |
+------------------+---------------------------+
| general_log | OFF |
| general_log_file | /data/my3306/centos65.log |
+------------------+---------------------------+
set global general_log=1;
set global general_log_file='/data/my3306/centos65_general.log';
mysql> SHOW global variables like '%general%';
+------------------+-----------------------------------+
| Variable_name | Value |
+------------------+-----------------------------------+
| general_log | ON |
| general_log_file | /data/my3306/centos65_general.log |
+------------------+-----------------------------------+
2 rows in set (0.00 sec)
#################
slow_query_log
mysql> show variables like '%slow%';
+---------------------------+--------------------------------+
| Variable_name | Value |
+---------------------------+--------------------------------+
| log_slow_admin_statements | OFF |
| log_slow_slave_statements | OFF |
| slow_launch_time | 2 |
| slow_query_log | OFF |
| slow_query_log_file | /data/my3306/centos65-slow.log |
+---------------------------+--------------------------------+
5 rows in set (0.00 sec)
mysql> set global slow_query_log=1;
Query OK, 0 rows affected (0.33 sec)
mysql> set global long_query_time=1;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%quer%';
+----------------------------------------+--------------------------------+
| Variable_name | Value |
+----------------------------------------+--------------------------------+
| binlog_rows_query_log_events | OFF |
| ft_query_expansion_limit | 20 |
| have_query_cache | YES |
| log_queries_not_using_indexes | OFF |
| log_throttle_queries_not_using_indexes | 0 |
| long_query_time | 1.000000 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 1048576 |
| query_cache_type | OFF |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| slow_query_log | ON |
| slow_query_log_file | /data/my3306/centos65-slow.log |
+----------------------------------------+--------------------------------+
15 rows in set (0.00 sec)
#################
innodb_log_file
To change the number or the size of your InnoDB redo log files, perform the following steps:
1 Stop the MySQL server and make sure that it shuts down without errors.
2 Edit my.cnf to change the log file configuration. To change the log file size,
configure innodb_log_file_size. To increase the number of log files, configure innodb_log_files_in_group.
3 Start the MySQL server again.
If InnoDB detects that the innodb_log_file_size differs from the redo log file size,
it will write a log checkpoint, close and remove the old log files, create new log files at the requested size, and open the new log files.
mysql> show variables like '%innodb%log%';
+----------------------------------+-----------+
| Variable_name | Value |
+----------------------------------+-----------+
| 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_buffer_size | 8388608 |
| innodb_log_compressed_pages | ON |
| innodb_log_file_size | 50331648 |
| 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 |
+----------------------------------+-----------+
12 rows in set (0.00 sec)
innodb_log_group_home_dir = /hbdata/mysqldata/3306/binlog
innodb_log_file_size = 1300M
innodb_log_files_in_group = 3
2016-06-02 11:16:17 4299 [Warning] InnoDB: Resizing redo log from 5*12800 to 4*9600 pages, LSN=23031318
2016-06-02 11:16:17 4299 [Warning] InnoDB: Starting to delete and rewrite log files.
2016-06-02 11:16:17 4299 [Note] InnoDB: Setting log file ./ib_logfile101 size to 150 MB
InnoDB: Progress in MB: 100
2016-06-02 11:16:18 4299 [Note] InnoDB: Setting log file ./ib_logfile1 size to 150 MB
InnoDB: Progress in MB: 100
2016-06-02 11:16:19 4299 [Note] InnoDB: Setting log file ./ib_logfile2 size to 150 MB
InnoDB: Progress in MB: 100
2016-06-02 11:16:20 4299 [Note] InnoDB: Setting log file ./ib_logfile3 size to 150 MB
InnoDB: Progress in MB: 100
2016-06-02 11:16:21 4299 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2016-06-02 11:16:21 4299 [Warning] InnoDB: New log files created, LSN=23031318
Binary Log
binlog_cache_size的大小必须为4096的倍数，不然会有一个warning， “Warning | 1292 | Truncated incorrect binlog_cache_size value: '33792'”，然后向下取最接近n个4096的值。
mysql> show warnings;
+---------+------+------------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------------+
| Warning | 1292 | Truncated incorrect binlog_cache_size value: '33792' |
+---------+------+------------------------------------------------------+
1 row in set (0.0
SET GLOBAL binlog_format = 'STATEMENT';
SET GLOBAL binlog_format = 'ROW';
SET GLOBAL binlog_format = 'MIXED';
SET SESSION binlog_format = 'STATEMENT';
SET SESSION binlog_format = 'ROW';
SET SESSION binlog_format = 'MIXED';
set global binlog_cache_size=4096*n;
log_bin = /data/my3306/bin_log/mysql_bin
binlog_format = row
binlog_cache_size=4096*n
#################
general log
mysql> SHOW global variables like '%general%';
+------------------+---------------------------+
| Variable_name | Value |
+------------------+---------------------------+
| general_log | OFF |
| general_log_file | /data/my3306/centos65.log |
+------------------+---------------------------+
set global general_log=1;
set global general_log_file='/data/my3306/centos65_general.log';
mysql> SHOW global variables like '%general%';
+------------------+-----------------------------------+
| Variable_name | Value |
+------------------+-----------------------------------+
| general_log | ON |
| general_log_file | /data/my3306/centos65_general.log |
+------------------+-----------------------------------+
2 rows in set (0.00 sec)
#################
slow_query_log
mysql> show variables like '%slow%';
+---------------------------+--------------------------------+
| Variable_name | Value |
+---------------------------+--------------------------------+
| log_slow_admin_statements | OFF |
| log_slow_slave_statements | OFF |
| slow_launch_time | 2 |
| slow_query_log | OFF |
| slow_query_log_file | /data/my3306/centos65-slow.log |
+---------------------------+--------------------------------+
5 rows in set (0.00 sec)
mysql> set global slow_query_log=1;
Query OK, 0 rows affected (0.33 sec)
mysql> set global long_query_time=1;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%quer%';
+----------------------------------------+--------------------------------+
| Variable_name | Value |
+----------------------------------------+--------------------------------+
| binlog_rows_query_log_events | OFF |
| ft_query_expansion_limit | 20 |
| have_query_cache | YES |
| log_queries_not_using_indexes | OFF |
| log_throttle_queries_not_using_indexes | 0 |
| long_query_time | 1.000000 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 1048576 |
| query_cache_type | OFF |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| slow_query_log | ON |
| slow_query_log_file | /data/my3306/centos65-slow.log |
+----------------------------------------+--------------------------------+
15 rows in set (0.00 sec)
#################
innodb_log_file
To change the number or the size of your InnoDB redo log files, perform the following steps:
1 Stop the MySQL server and make sure that it shuts down without errors.
2 Edit my.cnf to change the log file configuration. To change the log file size,
configure innodb_log_file_size. To increase the number of log files, configure innodb_log_files_in_group.
3 Start the MySQL server again.
If InnoDB detects that the innodb_log_file_size differs from the redo log file size,
it will write a log checkpoint, close and remove the old log files, create new log files at the requested size, and open the new log files.
mysql> show variables like '%innodb%log%';
+----------------------------------+-----------+
| Variable_name | Value |
+----------------------------------+-----------+
| 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_buffer_size | 8388608 |
| innodb_log_compressed_pages | ON |
| innodb_log_file_size | 50331648 |
| 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 |
+----------------------------------+-----------+
12 rows in set (0.00 sec)
innodb_log_group_home_dir = /hbdata/mysqldata/3306/binlog
innodb_log_file_size = 1300M
innodb_log_files_in_group = 3
2016-06-02 11:16:17 4299 [Warning] InnoDB: Resizing redo log from 5*12800 to 4*9600 pages, LSN=23031318
2016-06-02 11:16:17 4299 [Warning] InnoDB: Starting to delete and rewrite log files.
2016-06-02 11:16:17 4299 [Note] InnoDB: Setting log file ./ib_logfile101 size to 150 MB
InnoDB: Progress in MB: 100
2016-06-02 11:16:18 4299 [Note] InnoDB: Setting log file ./ib_logfile1 size to 150 MB
InnoDB: Progress in MB: 100
2016-06-02 11:16:19 4299 [Note] InnoDB: Setting log file ./ib_logfile2 size to 150 MB
InnoDB: Progress in MB: 100
2016-06-02 11:16:20 4299 [Note] InnoDB: Setting log file ./ib_logfile3 size to 150 MB
InnoDB: Progress in MB: 100
2016-06-02 11:16:21 4299 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2016-06-02 11:16:21 4299 [Warning] InnoDB: New log files created, LSN=23031318
当前名称：MySQLserverlogmanage-创新互联
链接分享：https://www.cdcxhl.com/article16/dpesgg.html
成都网站建设公司_创新互联，为您提供移动网站建设、网站收录、营销型网站建设、用户体验、服务器托管、企业网站制作
声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联
- 为什么SEO网站优化必须使用静态页面 2013-04-22
- 老生常谈，动态网站和静态网站的优劣势 2014-09-04
- 网站伪静态处理为什么对网站优化那么重要 2014-08-18
- 营销型网站建设中什么是动态网站、静态网站 2013-06-07
- 实践证明，不是每个网站SEO优化时都需要静态 2016-06-20
- 创新互联：什么是动态网站？动态网站与静态网站如何区别 2022-05-21
- 分析动态网站和静态网站的区别 2016-12-04
- 动态网站和静态网站的区别 2016-11-07
- SEO优化-伪静态页面制作技巧与优点解析 2016-09-23
- 网站建设是动态的好还是静态的好 2014-05-19
- 伪静态与纯静态的区别是什么？ 2016-10-30
- 成都网站建设开发营销型网站的时候为什么给URL选择静态的？ 2016-11-01