MySQL gives this IO error, please help
Posted by:
Lev Anni
Date: May 22, 2021 02:41PM
Hi,
Just registered her guys, and I'm not sure if I'm posting this to the right place, forgive me if so.
I'm facing this problem and can't figure out what might be causing this error in log file:
Timestamp, Thread, Type, Details
2021-03-22T15:00:20, 0, [ERROR] [MY-012611] [InnoDB], Operating system error number 995 in a file operation.
Timestamp, Thread, Type, Details
2021-03-22T15:00:20, 0, [ERROR] [MY-012617] [InnoDB], The error means that the I/O operation has been aborted because of either a thread exit or an application request. Retry attempt is made.
I got just huge amount of these errors.
MySQL version is 8.
There is about 3000 databases on a single master server with slave. But concurrent client connections aren't so much, 10-15 connections in second. 60-80% CPU usage though...
Configuration is default, except two settings:
innodb_buffer_pool_size=2G
innodb_log_file_size=128M
Server is running in VM with 8 virtual processors and 16 gigs of RAM.
What can be done?
Thanks a lot!!!