MySQL Forums
Forum List  »  Performance

Serieus performance degradation since MySQL 8.0.12 on Ubuntu
Posted by: Martijn Verhoef
Date: August 01, 2018 05:25AM

Since my upgrade from 5.7.22/5.7.23 to 8.0.12, I have some serious performance issues when using mysqldump.

- VPS with 2 cores & 4GB memory

- Ubuntu 16.04.5
- MySQL 8.0.12 (both server & mysqldump) from official MySQL-repository

- MySQL is configured as slave, but when I 'stop slave', there's no significant improvement (and serverload is nearly 0)


time mysqldump <somedb> > /dev/null

real 0m38.420s
user 0m4.724s
sys 0m0.692s

time mysqldump <somedb> > /dev/null

real 1m21.048s
user 0m6.340s
sys 0m0.612s


Additional information:
- cpu-usage is 100% for 1 core (1-3% iowait, not all databases can be is in memory)
- when checking 'show full processlist', I see 'checking permissions' every few refreshes.
- I've got only 50 users and no difficult permissions (this user only has some basic permissions on granted, no database/table-specific permissions)

Options: ReplyQuote

Written By
Serieus performance degradation since MySQL 8.0.12 on Ubuntu
August 01, 2018 05:25AM

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.