The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

buf_pool_mutex, SERVICE_THREAD_CONTROL::COND_control & other wait events seen during perf test

Did a performance test; & collected events_waits_current on regular intervals. the top events based on wait time is as follows :

  • wait/synch/mutex/innodb/buf_pool_mutex (less frequent)
  • wait/io/file/innodb/innodb_data_file (less requent)
  • wait/synch/cond/aria/SERVICE_THREAD_CONTROL::COND_control ( many times, wait time averaging 1500 ms)
  • wait/io/table/sql/handler (many times, wait time averaging from 90 ms to 1000 ms)
  • wait/synch/sxlock/innodb/index_tree_rw_lock (less frequent, wait time averaging at 200 ms)
  • wait/synch/cond/mysys/COND_timer (many times, wait time averaging 300 ms)

I could not find any documentation which explains these wait events. Appreciate it if you could shed some light on these and how these may affect performance.

Regards,

PS : performance test consists on 100 inserts per batch, with updates and selects

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.