MySQL Performance

[provocating]

Is there anything that can be done to help MySQL performance? I am talking other than going with an array of SSD's. I know when searching in the Allaclone that the large number of joins to look up something is the main cause. I am more familiar with MS SQL and fixing those performance issues.

[vsab]

I found Mariadb gave me some performance improvements over mysql, mainly I think because I was using some correlated subqueries. However, I think Akka's repack has some optimisations which might be useful.

[Akkadius]

Originally Posted by provocating

Is there anything that can be done to help MySQL performance? I am talking other than going with an array of SSD's. I know when searching in the Allaclone that the large number of joins to look up something is the main cause. I am more familiar with MS SQL and fixing those performance issues.

That's going to be an issue with the AllaClone alone, it in itself needs to properly query things for performance.

There are an array of things you can do to tune MySQL performance, I will write a quick Wiki article since folks have been asking.