MySQL Forums
Forum List  »  Replication

Replication's sql threads are too low performance on high spec machine.
Posted by: masa hu
Date: September 14, 2013 08:20PM

Our new server is too low performance with doing mysql threads compared with the old our low spec server.

the following are server specs:

New one using CentOS6.4_64,MySQL5.6.13,Xeon Core4 processor, 16GB Memory, 4TB HDD with H/W raid1. mysql data directory is on the ext4 file system.

Old one using Centos5.9_64,MySQL5.1.xx,Core2Duo processor, 4GB Memory, 500GB HDD with H/W raid1. mysql data directory is on the ext3 file system.

First I suspected the ext4 file system and I found ext4's barrier=1 option cause the low performance problem.

So I changed the ext4's barrier parameter from "1" to "0" and done the online remount.
But the performance improvement was not.

Of course Basically tuning is already done.

Replication's sql threads are almost replace statment.
and new server do about 20 replace statment per sec.
Old server did about 60-70 same statment per sec.

Do you know a similar problem?
Anyone have a solution?

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication's sql threads are too low performance on high spec machine.
2006
September 14, 2013 08:20PM


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.