Configuring a MySQL 4,0 server for performance

[thomasHOL]

Hi

I have installed MySQL 4,0 and I would like some tips for optimizing the performance. The total database contains 800 MB of data and I would like to have as fast a database as possible. I have enabled the Query Cache but i don't really know what kind of settings to use.

I hope that you can give me some tips for optimizing the database.

Thomas

 

[hvass]

http://www.mysql.com/doc/en/MySQL_Optimisation.html

gives a lot of information on Optimisation - obvious question is what kind of use, queries, numbers of users etc..

In my limited experience (few users - large database tables) the example configurations (my-huge.cnf my-large.cnf etc..) that come as examples with mysql work fairly well.

We manage to transform performance by looking at how each query is written and run with EXPLAIN

http://www.mysql.com/doc/en/EXPLAIN.html

my 2 favourites at the moment are
SQL_BIG_RESULT & order of the conditions in where statements (for when the query optimiser gets it wrong)

If you have many users and small databases then I suggest I am not the person to help.