0 Usuarios y 1 Visitante están viendo este tema.
[mysqld]socket=/path/to/mysql.sockdatadir=/var/lib/mysqlskip-lockingskip-innodb# MySQL 4.x has query caching available.# Enable it for vast improvement and it may be all you need to tweak.query_cache_type=1query_cache_limit=1Mquery_cache_size=32M# max_connections=500# Reduced to 200 as memory will not be enough for 500 connections.# memory=key_buffer+(sort_buffer_size+read_buffer_size)*max_connections# which is now: 64 + (1 + 1) * 200 = 464 MB# max_connections = approx. MaxClients setting in httpd.conf file# Default set to 100.#max_connections=200#interactive_timeout=180interactive_timeout=100#wait_timeout=180#wait_timeout=100# Reduced wait_timeout to prevent idle clients holding connections.#wait_timeout=30wait_timeout=15connect_timeout=10# max_connect_errors is set to 10 by default#max_connect_errors=10#table_cache=256#table_cache=1024# Checked opened tables and adjusted accordingly after running for a while.table_cache=512#tmp_table_size=32M by default#thread_cache=128# Reduced it to 32 to prevent memory hogging. Also, see notes below.thread_cache=32# key_buffer=258M# Reduced it by checking current size of *.MYI files, see notes below.key_buffer=128M# Commented out the buffer sizes and keeping the default.# sort_buffer_size=2M by default.#sort_buffer_size=1M# read_buffer_size=128K by default.#read_buffer_size=1M# 1Mb of read_rnd_buffer_size for 1GB RAM -- see notes below.# read_rnd_buffer_size=256K by default.#read_rnd_buffer_size=1M# myisam_sort_buffer_size used for ALTER, OPTIMIZE, REPAIR TABLE commands.# myisam_sort_buffer_size=8M by default.#myisam_sort_buffer_size=64M# thread_concurrency = 2 * (no. of CPU)thread_concurrency=2# log slow queries is a must. Many queries that take more than 2 seconds. # If so, then your tables need enhancement.log_slow_queries=/var/log/mysqld.slow.loglong_query_time=2[mysql.server]user=mysqlbasedir=/var/lib[safe_mysqld]err-log=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidopen_files_limit=8192[mysqldump]quickmax_allowed_packet=16M[mysql]no-auto-rehash# Remove the next comment character if you are not familiar with SQL#safe-updates[isamchk]key_buffer=64Msort_buffer=64Mread_buffer=16Mwrite_buffer=16M[myisamchk]key_buffer=64Msort_buffer=64Mread_buffer=16Mwrite_buffer=16M[mysqlhotcopy]interactive-timeout [client]socket=/path/to/mysql.sock
