The Ultimate Guide to High Availability with MariaDB

Comments - Possible dead lock (OLS) - Possible mariaDB issue

2 weeks, 3 days ago Daniel Black
Re: Possible dead lock (OLS) - Possible mariaDB issue

Significant CPU usage and application not receiving a response sounds like a slow query.

Look at enabling the slow query log with a low log_slow_query_time - 2 seconds? How long is the application waiting. Look at this slow query log around the stalled time.

EXPLAIN FORMAT=JSON included details on execution of the query.

When you have details, include them in a question on stackoverflow https://stackoverflow.com/ along with the table structures.

 
1 week, 3 days ago Slewrate K.
Re: Possible dead lock (OLS) - Possible mariaDB issue

Hi,

We have analyzed the slow query log, and it does not look that any slow queries are related to this problem.

Is there any other log we could look at?

Thanks Alex

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.