Re: MySQL server crash after running SELECT queries with a connection pool of 60
For starters, are the queries run through an app? If so, do they also crash the server when tun from the mysql client program or mysql shell?
Then, let's see the results of ...
- running Explain Analyze on the queries, esp. on the query that's running when the crash occurs
- running Show Engine InnoDB Status while the query is running over that connection pool
- the result of this calculation: innodb_buffer_pool_size + innodb_ft_total_cache_size + innodb_additional_mem_pool_size + innodb_log_buffer_size + query_cache_size + tmp_table_size + key_buffer_size + max_connections * ( thread_stack + max( max_allowed_packet, net_buffer_length ) + net_buffer_length + read_buffer_size + read_rnd_buffer_size + sort_buffer_size + join_buffer_size )
- how much RAM is available to MySQL
= whether the query induces swapping
Subject
Written By
Posted
Re: MySQL server crash after running SELECT queries with a connection pool of 60
June 10, 2022 10:21AM
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.