Re: MySQL server crash after running SELECT queries with a connection pool of 60

[Peter Brawley]

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.