Ítalo Rossi skrev, on 05-11-2007 16:35:
Tonni,
Can you post your mysql configuration?
My ibdata1 is too big:
-rw-rw---- 1 mysql mysql 64G 2007-11-05 12:32 ibdata1
-rw-rw---- 1 mysql mysql 800M 2007-10-28 14:24 ibdata2
64GB it's bigger than my mysql tables...
The site that runs the following is a high school with 1150+ users
whereof around 350 active email users. It's a new install on RHEL5
x86_32 with all the databases populated from MySQL dumps on the old
RHAS4 server. The old server had an ibdata1 of 16GB that I could never
get to shrink in size. The only way of shrinking the size I can think of
is converting every database to MyISAM and optimizing every table, then
converting back to InnoDB - that's a horrible job on a running
production server, so I never tried, just waited for the upgrade - more
than 2 years..
I originally had dspam configured for each user, that resulted in the
16GB; half way through I swapped to a shared group.
1033 [root:mercurius.intern] /etc # du -sh /var/lib/mysql/*
96K /var/lib/mysql/dspamdb
21M /var/lib/mysql/ib_logfile0
21M /var/lib/mysql/ib_logfile1
101M /var/lib/mysql/ibdata1
16K /var/lib/mysql/log.0000000001
888K /var/lib/mysql/mysql
0 /var/lib/mysql/mysql.sock
28M /var/lib/mysql/policyd
64K /var/lib/mysql/squirrelmail
8.0K /var/lib/mysql/test
[mysqld]
socket=/var/lib/mysql/mysql.sock
datadir=/var/lib/mysql
old_passwords=1
default-table-type=innodb
innodb_data_file_path=ibdata1:100M:autoextend
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 32M
net_buffer_length = 8K
max_allowed_packet=4096000
max_connections=500
skip-networking
skip-external-locking
max_connections=200
read_buffer_size=1M
sort_buffer_size=1M
innodb_buffer_pool_size = 70M
innodb_additional_mem_pool_size = 10M
innodb_lock_wait_timeout = 50
innodb_log_files_in_group=2
innodb_log_file_size = 20M
innodb_log_buffer_size = 8M
innodb_lock_wait_timeout=50
innodb_flush_log_at_trx_commit = 1
[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
--Tonni
--
Tony Earnshaw
Email: tonni at hetnet dot nl
