56,677
社区成员
发帖
与我相关
我的任务
分享
MariaDB [(none)]> show variables like '%bin%';
+-----------------------------------------+----------------------+
| Variable_name | Value |
+-----------------------------------------+----------------------+
| 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 |
| innodb_locks_unsafe_for_binlog | OFF |
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_size | 1073741824 |
| max_binlog_stmt_cache_size | 18446744073709547520 |
| sql_log_bin | ON |
| sync_binlog | 0 |
+-----------------------------------------+----------------------+
15 rows in set (0.00 sec)
[root@flxx dada002]# ll
total 512332
drwxr-xr-x 2 dada002 root 4096 Dec 22 23:10 bak
-rw-r----- 1 root root 13880 Mar 13 11:52 gk_info_info.frm.bak
-rw-r----- 1 root root 485853324 Mar 13 11:51 gk_info_info.MYD.bak
-rw-r----- 1 root root 9374720 Mar 13 11:51 gk_info_info.MYI.bak
-rw-r----- 1 root root 18874368 Mar 13 12:02 ibdata1
-rw-r----- 1 root root 5242880 Mar 13 12:02 ib_logfile0
-rw-r----- 1 root root 5242880 Mar 13 12:02 ib_logfile1
drwxrwxrwx 2 dada002 root 12288 Mar 9 14:25 logs
drwxr-xr-x 16 dada002 root 4096 Mar 8 15:10 www