My.cnf plesk
From Help system
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). skip-locking skip-bdb skip-networking set-variable = innodb_buffer_pool_size=512K set-variable = innodb_additional_mem_pool_size=128K set-variable = innodb_log_buffer_size=128K set-variable = innodb_thread_concurrency=2 safe-show-database query_cache_limit=64K query_cache_size=128K query_cache_type=1 max_user_connections=100 max_connections=200 thread_cache_size=64 key_buffer = 16K join_buffer=16K max_connect_errors=20 max_allowed_packet=1M table_cache=64 record_buffer=64K sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K thread_concurrency=2 myisam_sort_buffer_size=8M server-id=1 collation-server=utf8_unicode_ci default-character-set=utf8 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid skip-locking skip-bdb skip-networking safe-show-database query_cache_limit=64K query_cache_size=128K query_cache_type=1 max_user_connections=100 max_connections=200 thread_cache_size=64 key_buffer = 16K join_buffer=16K max_connect_errors=20 max_allowed_packet=1M table_cache=64 record_buffer=64K sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K thread_concurrency=2 myisam_sort_buffer_size=8M server-id=1 collation-server=utf8_unicode_ci default-character-set=utf8 set-variable = innodb_buffer_pool_size=512K set-variable = innodb_additional_mem_pool_size=128K set-variable = innodb_log_buffer_size=128K set-variable = innodb_thread_concurrency=2 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer = 8M sort_buffer_size = 8M [myisamchk] key_buffer = 8M sort_buffer_size = 8M [mysqlhotcopy] interactive-timeout [client] default-character-set=utf8
