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 ?
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?