Re: MySQL is running 8,000% slower on CentOS 6x than CentOS 5x. Maybe ext4 related?

[Michael Reed]

Hello? Anyone there?

I cannot be the only one experiencing this. At least I hope I am not!

All previous CentOS tests used ext4 filesystem. I created a new partition under LVM so I can test other filesystems, and mounted it to /var/lib/mysql. Below are the results with the same test SQL.

Centos 6.4 with yum installed MySQL 5.1.69, ext3, barrier=1

[root@desktop ~]# time mysql -uroot -pmyPassword < test.sql
real 0m5.810s
user 0m0.007s
sys 0m0.018s


Centos 6.4 with yum installed MySQL 5.1.69, ext3, barrier=0

[root@desktop ~]# time mysql -uroot -pmyPassword < test.sql
real 0m0.165s
user 0m0.008s
sys 0m0.007s


So, I have found that MySQL running under CentOS 6.4 with ext3 filesystem and barrier=0 is almost as fast as when running under CentOS 5X. Maybe creating a new primary partition instead of using LVM might improve?

Please MySQL gurus, pipe up. Does MySQL really run so poorly under CentOS 6.4? Why isn't changing filesystems documented?. I am a newbie just trying to learn.

Note. I have posted a very similar message at https://www.centos.org/modules/newbb/viewtopic.php?topic_id=43656&start=0#forumpost186338