MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: MySQL server crash after running SELECT queries with a connection pool of 60
Posted by: Peter Brawley
Date: June 14, 2022 10:47AM

28GB buffer pool is too much for a system that has 30GB RAM. Buff should be no more than 75% of available RAM.

Your MySQL instance is configured to use > 43GB RAM in a machine that has only 30GB RAM. Need reconfiguration and/or more RAM.

I don't see anything problematic in the InnoDB monitor.

What does the MySQL error log say about the crashes?

This looks to be a pre-8.0 MySQL version. Which exactly?

I'm not well-informed on .NET app management, but if these queries crash the server running from .NET apps and not from MySQL, then I'd want to look at the app(s). Perhaps start with the simplest possible app that just connects and runs one of the problem queries.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL server crash after running SELECT queries with a connection pool of 60
Chinmay Ram
June 10, 2022 06:37AM
Re: MySQL server crash after running SELECT queries with a connection pool of 60
Peter Brawley
June 10, 2022 10:21AM
Re: MySQL server crash after running SELECT queries with a connection pool of 60
Chinmay Ram
June 14, 2022 09:04AM
Re: MySQL server crash after running SELECT queries with a connection pool of 60
Peter Brawley
June 14, 2022 10:47AM


Sorry, you can't reply to this topic. It has been closed.

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.