[Mediawiki-l] Wiki-specific MySQL settings

Fri Dec 3 15:00:43 UTC 2004

"Brion Vibber":
<You might want to see about memory and I/O usage here. If MySQL's
memory usage settings are too low, it may be using the disk
inefficiently; if it's too high, it may be thrashing swap.>

I'd like to, especially in the face of the fact that after 15 hours of
intensive indexing, the disk with all server databases collapsed (there was
nothing else on it, only the mysql db files - about 15 GB used out of 120
GB).

Here are my.cnf settings
I would appreciate any corrections and suggestions.

[mysqld]
datadir=/disk2/mydbs/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=64M
query_cache_type=1
max_connections=300
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=64
key_buffer=128
join_buffer=1M
max_allowed_packet=32M
table_cache=256
record_buffer=1M
sort_buffer_size=2M
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size=768k
max_connect_errors=10
thread_concurrency=4
myisam_sort_buffer_size=64M
log-bin
server-id=1

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64
sort_buffer=64M
key_buffer=64
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout