Dale's Weblog

looking back it was easy.
Thursday 09 February

Mysql Optimizing

Posted by dale on Wed, 06 Oct 2004 21:02:51 EST

As databases have grown on this server the following configuration changes have been made to mysql.

key_buffer_size=128M
table_cache=4096

from

key_buffer_size=8M
table_cache=64

More details:
http://dev.mysql.com/doc/mysql/en/Server_parameters.html

Below are the comments for this news item
BBCode:

urls become clickable

[b]place text in bold[/b]

[i]place text in italics[/i]

[quote]place text in a quote[/quote]

Comments? Please note that all HTML tags are removed from your post.

The URI to TrackBack this entry is: http://www.dalegroup.net//early05/archive/blog/newsid/trackback/151

Comments

Message:

Name (optional):

Email (not shown):

WWW (optional):






Copyright © Michael Dale 2004. Page generated in 0.0075 seconds FreeBSD Powered
Background on style 5 is used from squidfingers How are we going? 3 queries