Shulou(Shulou.com)05/31 Report--

Mysql temporary table space is not enough to cause master-slave replication failure. I believe many inexperienced people are at a loss about this. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

When I went to work this morning, some users responded that today's data had not been updated, so I took a look at the slave process.

Mysql > show slave status\ G

.

Slave_IO_Running: Yes

Slave_SQL_Running: No

Last_SQL_Error: Error 'Got error 28 from storage engine' on query. Default database: 'CDM'. Query: 'insert into CDM.cdm_bill_itemized

SELECT c. Userkeeper _ equ_id,a.account_id,a.count_num,a.count_total a. Createcalendar _ date _ paper.

.

There is a problem with the library sql process. From the point of view of the error, it is because the temporary table space is full. Let's take a look at the directory to which tepdir is specified.

Mysql > show variables like 'tmpdir'

+-+ +

| | Variable_name | Value |

+-+ +

| | tmpdir | / tmp |

+-+ +

1 row in set (0.02 sec)

Root@trcloud-gtt-dw ~] # df-lh

Filesystem Size Used Avail Use% Mounted on

/ dev/vda1 20g 20g 0100% /

Tmpfs 5.9G 0 5.9G 0% / dev/shm

/ dev/vdb1 493G 107G 361G 23% / data

Sure enough, the root directory is full and there is no room for temporary tablespaces.

Modify parameter file

Tmpdir = / data/DB/mysql

Restart

Mysql > show slave status\ G

.

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

.

Last_IO_Errno: 0

Last_IO_Error:

Last_SQL_Errno: 0

Last_SQL_Error:

.

It's all normal.

After reading the above, have you mastered the method of master-slave replication failure caused by insufficient mysql temporary table space? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.