Digital Marketing

Check bin logs for MySQL






mysql> show global variables like '%log_bin%';

+---------------------------------+--------------------------------+
| Variable_name                   | Value                          |
+---------------------------------+--------------------------------+
| log_bin                         | ON                             |
| log_bin_basename                | /var/lib/mysql/mysql-bin       |
| log_bin_index                   | /var/lib/mysql/mysql-bin.index |
| log_bin_trust_function_creators | OFF                            |
| log_bin_use_v1_row_events       | OFF                            |
+---------------------------------+--------------------------------+

mysql> show global variables like '%binlog_format%';

+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| binlog_format | STATEMENT |
+---------------+-----------+

mysql> show binary logs;

+------------------+-----------+
| Log_name         | File_size |
+------------------+-----------+
| mysql-bin.000002 |  18387813 |
| mysql-bin.000003 |       201 |
| mysql-bin.000004 |      2249 |
| mysql-bin.000005 |       201 |
| mysql-bin.000006 |    381956 |
| mysql-bin.000007 |      2249 |
| mysql-bin.000008 |       201 |
| mysql-bin.000009 |       201 |
| mysql-bin.000010 |    358561 |
+------------------+-----------+

mysql>  show variables like "datadir";

+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| datadir       | /var/lib/mysql/ |
+---------------+-----------------+

Comments

Popular posts from this blog

MySQL Sandbox with the Sakila sample database