How to gain performance through MySQL

[Colin Guthrie]

Andreas Baier wrote:
>> If there was a file system upgrade of Mysql 4 to 5 then it can have some
>> odd effects with varbinary fields. They will be padded to the full
>> lenght of the field.
> As far as I know, I made a fresh amarok db after the upgrade to release 5.*. 
> 
> Apart from that, I made a fresh install of the amarok-db a few hours ago.
> -> same issues. So I installed the old database again.

Ahh well. That would have been too easy I suppose :p

> But apropos file system. I made a filesystem migration a few weeks ago. I 
> changed the fs where the database is installed from Ext3 to XFS.
> Does anybody know if this could cause the problem?
> 
> I had migrated all patitions (except a few exceptions) to XFS, and the system 
> feels in any other situation (except mysql) as fast as it should be.

AFAIK there should be no problem with XFS, but who knows? Perhaps you
could move the mysql storage dir (either symlink or config tweak) back
to an ext3 partition and see if it helps?


Sorry I can't be more helpful.

Col