mysql 常见命令

最新推荐文章于 2024-10-24 22:32:27 发布

游九河

最新推荐文章于 2024-10-24 22:32:27 发布

阅读量104

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/qq_40337206/article/details/103652913

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1. 查看binlog 模式

show variables like ‘%binlog%’;
| binlog_format | ROW |

mysql> show variables like '%binlog%';
+-----------------------------------------+----------------------+
| Variable_name                           | Value                |
+-----------------------------------------+----------------------+
| binlog_cache_size                       | 32768                |
| binlog_checksum                         | CRC32                |
| binlog_direct_non_transactional_updates | OFF                  |
| binlog_error_action                     | ABORT_SERVER         |
| binlog_format                           | ROW                  |
| binlog_group_commit_sync_delay          | 0                    |
| binlog_group_commit_sync_no_delay_count | 0                    |
| binlog_gtid_simple_recovery             | ON                   |
| binlog_max_flush_queue_time             | 0                    |
| binlog_order_commits                    | ON                   |
| binlog_row_image                        | FULL                 |
| binlog_rows_query_log_events            | OFF                  |
| binlog_stmt_cache_size                  | 32768                |
| innodb_api_enable_binlog                | OFF                  |
| innodb_locks_unsafe_for_binlog          | ON                   |
| log_statements_unsafe_for_binlog        | ON                   |
| max_binlog_cache_size                   | 18446744073709547520 |
| max_binlog_size                         | 1073741824           |
| max_binlog_stmt_cache_size              | 18446744073709547520 |
| sync_binlog                             | 500                  |
+-----------------------------------------+----------------------+
20 rows in set (0.41 sec)

2. 查看binlog文件

[mysqladmin@localhost bin]$ mysqlbinlog  --no-defaults  --base64-output=decode-rows \
-v  -v  /usr/local/mysql/arch/mysql-bin.000002 | \
grep  -A  200  ‘294204964’ >  debug2019-12-21.log