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!!!

Options: ReplyQuote


Subject
Written By
Posted
MySQL gives this IO error, please help
May 22, 2021 02:41PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.