MySQL Forums
Forum List  »  Performance

Inserts in MySQL 8 are slower than Inserts in MySQL 5.6
Posted by: anand aundhekar
Date: September 18, 2019 11:26PM

I have installed mysql 8.0.13. I started restoration of 20GB table in mysql and it took around 36 hours to restore.
When i tried to restore same table on mysql 5.6 it took around 5 hours only.
Mysql 8.0.13 is my master server and having 5 slaves attached to it.
When is do create table it took 4 seconds and while renaming same table it took 5 seconds.

mysql> select count(*) from tablename;

+----------+
| count(*) |
+----------+
| 82492459 |
+----------+
1 row in set (4 min 7.53 sec)

For count of table also its taking more time.

Options: ReplyQuote




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.