4

I have a normal hardware, I just installed Ubuntu 11.04 anew. But something's completely wrong. PHPunit tests are REALLY slow.

I have no idea what's wrong. With ext3 all was normal.

Thanks.

valk
  • 507
  • 1
    You re-installed the entire operating system and you think the filesystem choice is the problem? Why do you think this? Could anything else be different? – Ladadadada Apr 16 '12 at 15:00
  • I've never used normal hardware before, is it good? – Kyle Smith Apr 16 '12 at 15:04
  • 1
    Have you looked at dmesg or done some disk/smart tests to see if the disk is OK? – Tim Apr 16 '12 at 15:07
  • @Ladadadada drama much? – Tim Apr 16 '12 at 15:07
  • 1
    By normal do you mean non-virtualized? – HTTP500 Apr 16 '12 at 15:13
  • @Ladadadada yes, it's a new system. I think so because there's no additional installations comparing to other system, except there's ext3... But I'm not 100% sure though.. – valk Apr 16 '12 at 15:44
  • @Tim the disk is a new one. I didn't run tests but everything else including MySql works fine, that is, without errors. The speed is I think slower for everything, I don't know how much slower, but MySQL is terribly slower. Maybe 5-10 times slower. – valk Apr 16 '12 at 15:46
  • @HTTP500 - it's not virtualized, it's a regular system that works on well, regular hardware without anything in the middle like VirtualBox etc. – valk Apr 16 '12 at 15:47
  • I thought that the HDD is damaged/bad but the seller told me that it's absolutely fine and should work perfectly with no speed issues. – valk Apr 16 '12 at 15:50
  • 1
    What is the load and memory usage of the system? How big is your database? Have you tried running the queries directly against MYSQL? What about using an EXPLAIN on one of the aforementioned queries? Assuming its the file system is jumping the gun in a big way. – Andrew M. Apr 16 '12 at 17:02
  • 1
    How would the hard drive seller know if the disk is OK now? – ceejayoz Apr 16 '12 at 18:27

1 Answers1

8

It looks like setting barrier=0 as a mount option will help with performance.

See MySQL bug #46959.

Test in a Staging environment first!

Hope this helps.

HTTP500
  • 4,843
  • just for a record - i've noticed that the bug #46959 is two or three years old, but still reproduces on the new Ubuntu. – valk Apr 16 '12 at 21:02
  • also, found this. "barriers are disabled by default because they have a serious impact on performance" - in my case they were ENABLED, and serious impact in my case was DISASTROUS :) – valk Apr 16 '12 at 21:14