Serieus performance degradation since MySQL 8.0.12 on Ubuntu
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)
Subject
Views
Written By
Posted
Serieus performance degradation since MySQL 8.0.12 on Ubuntu
1103
August 01, 2018 05:25AM
473
August 02, 2018 02:12AM
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.