Jump to content

my.cnf suggestions


Kovo
 Share

Recommended Posts

Im running a site on a VPS with 1 cpu allocated to me and 1Gb of ramThis is my my.cnf file for mysql.Does anyone have any suggestions for performance? Thanks![mysqld]##non catagorizedskip-name-resolve#skip_name_resolvebind_address=127.0.0.1skip-bdblocal-infile=0skip-lockingsafe-show-databaseopen_files_limit=32768thread_stack = 128Kthread_concurrency=4#datadir=/var/lib/mysql##slow query loggerlog_slow_queries = ONlog-slow-queries = /var/log/mysql-slow-queries.txtlong_query_time = 1#log-queries-not-using-indexes = 1##Query cachequery_cache_limit=1Mquery_cache_size=32Mquery_cache_type=2query_cache_min_res_unit=1024##Connection relatedmax_user_connections=500max_connections=500thread_cache_size=128max_connect_errors=10000#max_allowed_packet=64Mwait_timeout=200connect_timeout=30max_allowed_packet=32M##Bufferskey_buffer=256Mjoin_buffer=2Mrecord_buffer=2Msort_buffer_size=2Mread_buffer_size=512Kread_rnd_buffer_size=512K##All Enginestmp_table_size=512Moptimizer_search_depth=4max_seeks_for_key=100table_cache=800#table_definition_cache=512max_delayed_threads=60##MyISAM Engine#myisam_sort_buffer_size=16Mconcurrent_insert=2ft_min_word_len=2##Memory Enginemax_heap_table_size=12M##InnoDB Engineinnodb_additional_mem_pool_size=32Minnodb_buffer_pool_size=512Minnodb_max_purge_lag=1000000innodb_support_xa=0innodb_log_buffer_size=16Minnodb_thread_sleep_delay=2500innodb_commit_concurrency=0innodb_flush_log_at_trx_commit=2innodb_thread_concurrency=8innodb_flush_method=O_DIRECTbinlog_cache_size=4M#innodb_log_file_size=256M#innodb_file_per_table=1#innodb_use_purge_thread=1#innodb_commit_concurrency=10

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...