Hi friends,

I'm trying to follow the instructions here http://library.linode.com/troubleshooti ... networking
to fine tune my linode.
I have been able to do the HTTP part, but I am having issues with the MySQL part.

Firstly, My my.cnf is in /etc/ folder and not /etc/mysql/my.cnf like the linode library article says.

Then my my.cnf contains only the following:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

and nothing like



as the tutorials say.

How then can I fine tune my MySQL with to these settings?

Thanks.

I'm guessing you're running centos and the docs assume ubuntu
anyway, if a setting is missing from the config, it uses the default.

What I would do is to let the db run for a few days, then download and run http://mysqltuner.pl

I installed mysql tuner and I got this


Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
query_cache_size (> 60M)
table_cache (> 64)
innodb_buffer_pool_size (>= 69M)

So I entered /etc/mysql/my.cnf file but not sure what to adjust, what is this > saying to me? and where is mysql max memory usage defined, not one variables but all of these?

these is what i see in my.cnf


key_buffer = 300M
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 20M
query_cache_size = 60M


this inno_db part I done even have? some guidance please.