Re: Answer from MySql very slow

[James Day]

Yes. Look at the my-small.cnf, my-large.cnf and my-huge.cnf examples supplied with MySQL (assuming you have a distribution from mysql.com, not one which has removed those standard examples). It's vital that you select a suitable version and adjust the settings to be suitable for your application, the amount of RAM in the computer and the other tasks it is performing (whether it's a dedicated server or not). key_buffer_size is the one which makes most difference if you're using the MyISAM engine type.