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.

Hardware:
- VPS with 2 cores & 4GB memory

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

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

---

Before:
time mysqldump <somedb> > /dev/null

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

After:
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


Subject
Views
Written By
Posted
Serieus performance degradation since MySQL 8.0.12 on Ubuntu
350
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.