Hello

Using mysqltuner i got the above recomendations:

1) Total fragmented tables: 13
2) Query cache is disabled
3) Sorts requiring temporary tables: 95% (1M temp sorts / 1M sorts)
4) Thread cache is disabled
5) Table cache hit rate: 0% (64 open / 47K opened)
6) Table locks acquired immediately: 93%


And as recomendations i got:


General recommendations:



Where are those variables to adjust?

Thank you

    Run OPTIMIZE TABLE to defragment tables for better performance

    Enable the slow query log to troubleshoot bad queries

    Set thread_cache_size to 4 as a starting value

    Increase table_cache gradually to avoid file descriptor limits

    Optimize queries and/or use MyISAM to reduce lock wait

Variables to adjust:

    query_cache_size (>= 8M)

    sort_buffer_size (> 1M)

    read_rnd_buffer_size (> 256K)

    thread_cache_size (start at 4)

    table_cache (> 64)

my.cnf

Many of those are missing can you help me to adjust them?

[mysqld]

port            = 3306

socket          = /var/lib/mysql/mysql.sock

skip-locking

skip-innodb

skip-bdb

key_buffer = 10M

max_allowed_packet = 1M

table_cache = 1024

sort_buffer_size = 2M

read_buffer_size = 1M

read_rnd_buffer_size = 1M

net_buffer_length = 2K

thread_stack = 64K

log-slow-queries       = /var/log/mysql/mysql-slow.log

server-id = 1

skip-networking


[mysqldump]

quick

max_allowed_packet = 1M


[mysql]

no-auto-rehash

safe-updates


[isamchk]

key_buffer = 10M

sort_buffer_size = 2M


[myisamchk]

key_buffer = 10M

sort_buffer_size = 2M

[quote name='rct2·com' date='18 November 2009 - 11:05 PM' timestamp='1258585517' post='1880486']You might also like to google for different recommended my.cnf settings based on typical server spaces and usage profiles.

I thought it was specific file and not able to use any file that i get from net as i want to be very stable ....

If anyone can adjust my.cnf please post it here.

Thank you