Roundup Tracker - Issues

Issue 2551316

mysql 8 testing takes 4 hours. Create table seems to be the culprit
Type: resource usage Severity: normal
Components: Database, Test Versions:
Status: new
: : rouilj
Priority: :

Created on 2024-02-12 22:55 by rouilj, last changed 2024-02-13 00:33 by rouilj.

msg7940 Author: [hidden] (rouilj) Date: 2024-02-12 22:55
I upgraded by dev box from ubuntu 18 to ubuntu 20. Now running the full test_mysql
takes 4 hours.

helped to get an idea of where the time was spent, but there doesn't seem to be a solution.

This is unlikely to be a production issue as table creation/mutation is infrequent but...
There may be some tuning of mysqld.conf that helps but... I am using the mysqld
change defined in the workflows that sped thing up significantly under 5.x.
msg7941 Author: [hidden] (rouilj) Date: 2024-02-13 00:33

reports using libeatmydata. Starting mysqld as:

  sudo -u mysql eatmydata mysqld &

(after creating /var/run/mysqld with user:group mysql.mysql)
and running and it completes in not ~14000 seconds but ~411.


   224 passed in 411.67 second

with load average in the mid 2's not mid 4's. Still have I/O waits in the 80/90 on some cpus
(2 core 2 thread).

For comparison postgresql:

   456 passed in 507.34 seconds

Will see if mysqltuner can help.
Date User Action Args
2024-02-13 00:33:34rouiljsetmessages: + msg7941
2024-02-12 22:55:38rouiljcreate