On 10/1/05, David Sparks <[EMAIL PROTECTED]> wrote: > Here is a config diff that made mysql usable again. As the database > grew in size, buffer sizes in the config were increased to try to boost > mysql performance. > > Unfortunately it didn't work as expected. As the config was tweaked, > mysql slowed down even more. Removing all settings from the my.cnf > restored performance. > > So what was the setting below that was tanking mysql performance? I > suspect that "innodb_log_buffer_size=32M" was the culprit.
David, I did not look at your config closely, I only have some general advice because I had similar experiences in the past: watch out for config settings which allocate the given memory setting per connected client rather than one time for the server as a whole. The former can easily kill the performance if the number of connections gets too high. I found that it is often not immediately obvious which settings are which, without checking the manual. JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
