1

Advice for MySQL Performance Tunning

view story
linux-howto

http://serverfault.com – Help me for tune mysql, Here my configuration [mysqld] local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock #socket=/tmp/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 skip-name-resolve safe-show-database skip-external-locking max_connections=150 key_buffer_size=16M myisam_sort_buffer_size=64M join_buffer_size=3M read_buffer_size=4M sort_buffer_size=4M table_cache=2048 thread_cache_size=256 max_allowed_packet=16M table_definition_cache = 2048 query_cache_limit = 1M query_cache_size = 128M query_cache_type (HowTos)