MySQL ISAM database format tuning --- for 4gb server
I am looking for recommendations for setting up a MySQL server on a server with 4gb memory. Below are the ISAM setting from a server a few years old, and I suspect they are default settings and not tuned at all to the server it's running on.
Question: My current mysqld process is using 1.8 percent memory. Should that be configured to use 50% or more on a dedicated MySQL server ?
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
Question: My current mysqld process is using 1.8 percent memory. Should that be configured to use 50% or more on a dedicated MySQL server ?
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
ASKER
MyIsam is the database.
Yes the server is dedicated to the SQL operations.
MyISAM is the only engine involved/used.
Yes the server is dedicated to the SQL operations.
MyISAM is the only engine involved/used.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The max connections can be set at 50 I am looking at my tcp connections from the apache server, at peak I am at 20-30. The processor is a single processor with two cores so I am not sure what value to use for thread_concurrency 2 or 4.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please let me know so that I can suggest... I see these settings are for MyISAM engine and they seems to be default settings...
Also - Is this machine dedicated to MySQL?
- Is MyISAM is the only engine you are planning to use?