asked on

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

Umesh

Correct me if I'm wrong here - You are talking about MyISAM rather than ISAM engine??
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?

stevejepsen

ASKER

MyIsam is the database.
Yes the server is dedicated to the SQL operations.
MyISAM is the only engine involved/used.

ASKER CERTIFIED SOLUTION

Umesh

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

stevejepsen

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

Umesh

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer