MySql Tuning for G3
|
griffinmt
Joined: 2009-09-06
Posts: 128 |
Posted: Wed, 2009-09-16 22:56
|
|
A little while ago there was some concerns expressed about the length of time it took for some of the possible operations. One of the suggestions was that the MySql database needs to be setup with appropriate values etc. In that light, can anyone make some recommendations of those parameters and values. Assume this is a dedicated MySql instance and running on the same system as G3 and Apache. One of the things I noticed in the stats reported via phpMyAdmin was that it thought that a number of indexes were needed. Not knowing the types of sql requests being made, I can't determine what fields should be indexed to test this out. Martyn T. Griffin |
|
Posts: 7934
At some point during the polishing process we'll go back and do a final tuning pass on the database and add any indices that are useful. I did a pass like this a couple of months back and I'm not seeing significant performance problems with the database indices as they are now. Stay tuned-- if you add your own indices you may break future upgrades.
---
Problems? Check gallery3/var/logs
bugs/feature req's | upgrade to the latest code | use git