Installed 9.10 Karmic 64 bit and updated to latest packages. I used ext4 for / partition, and kept ext3 for /home partition. Installed MySQL 5.1.37 through apt.
Struggled couple hours finding that MySQL performance was horrible when datadir is poiting to default /var/lib/mysql (ext4). Simple script which INSERT 20K rows took more than an hour (io wait was around 20%, CPU 15%). Don't see any error logs or issues, the thing is just slow.
Finally moved the datadir to /home ext3 partition, everything flies (script finished in just couple second).
Does anybody else has similar experience? The ext4 root partition otherwise works pretty well, I did "dd" testing and the io throughput is quite normal.
Bookmarks