79318295

Date: 2024-12-30 18:19:40
Score: 2
Natty:
Report link

We had a similar issue with 'synch/mutex/aria/PAGECACHE::cache_lock' on MariaDB RDS.

We were fetching and sorting 200k+ rows, and changing the following parameters helped us: tmp_table_size max_heap_table_size

Also there were queries in 'Converting HEAP to Aria' status in the processlist table

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: user11003426