[client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english bind-address = 127.0.0.1 skip-external-locking key_buffer = 128M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 max_connections = 250 query_cache_limit = 1M query_cache_size = 16M # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover = BACKUP log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 2 #log-queries-not-using-indexes skip-bdb skip-innodb [mysqldump] quick quote-names max_allowed_packet = 16M [isamchk] key_buffer = 16M