MySQL DBA system Learning (7) binary log Three: related system variables

1,binlog_cache_size and Max_binlog_cache_size

Represents the cache allocated for each session

In general, when inserting or modifying the data, the disk will not be written immediately, and the cache size is binlog_cache_size to control.

Mysql> Show variables like "%binlog_cache%";

+-----------------------+----------------------+

| variable_name| value|

+-----------------------+----------------------+

| binlog_cache_size| 32768|

| Max_binlog_cache_size |18446744073709547520 |

+-----------------------+----------------------+

2,binlog_cache_use

Represents the number of things that are present

There is no thing at present

Mysql> showstatus like "%binlog_cache_use%";

+------------------+-------+

| variable_name| Value |

+------------------+-------+

| Binlog_cache_use | 0|

+------------------+-------+

Create Things

Mysql>show table status like ' TT ' \g;

1. row***************************

Name:tt

Engine:myisam (this engine does not support things)

Version:10

Row_format:fixed

Rows:1

Avg_row_length:8

Data_length:8

max_data_length:2251799813685247

index_length:1024

data_free:0

Auto_increment:null

create_time:2013-09-03 11:42:18

update_time:2013-09-03 15:24:13

Check_time:null

Collation:utf8_general_ci

Checksum:null

Create_options:

Comment:

1 row in Set (0.00 sec)

Mysql>drop table TT;

Query OK, 0 rows affected (0.01 sec)

Mysql> CREATE TABLE TT (ID int) Engine=innodb; Engine set to InnoDB

Query OK, 0 rows affected, 2 warnings (0.02SEC)

Mysql> INSERT INTO TT values (1);

Query OK, 1 row Affected (0.00 sec)