mysql logging
Got a minor Mysql issue.
I have some innoDB tables and some MyISAM tables. I am finding that with some programs I run that the binary logs just keep growing and getting out of hand, until they consume 100% of my /usr partition.
I have read through the docs and I am not entirely sure how I should configure my mysql installation so this doesnt happen. I have simply shut down mysql and deleted the logs before, but I swear I lost some data at the time.
Here is the current binary logs:
-rw-rw---- 1 mysql mysql 1073742000 Jun 3 12:59 host-bin.001
-rw-rw---- 1 mysql mysql 1073741968 Jun 21 14:14 host-bin.002
-rw-rw---- 1 mysql mysql 1073741891 Jul 9 07:58 host-bin.003
-rw-rw---- 1 mysql mysql 868605952 Jul 24 14:00 host-bin.004
-rw-rw---- 1 mysql mysql 0 Jul 24 14:00 host-bin.005
-rw-rw---- 1 mysql mysql 0 Jul 31 20:43 host-bin.006
-rw-rw---- 1 mysql mysql 9269248 Feb 12 2004 host-bin.010
-rw-rw---- 1 mysql mysql 234 Jul 9 07:58 host-bin.index
As you can see, its sucking all my disk space:
/dev/hda8 4.9G 4.6G 8.9M 100% /usr
This was a binary install of mysql 4.x, following the readme/install files (NOT FROM RPM).
Here is a relevant excerpt from my.cnf. I just basically copied my-medium.cnf to /etc.. mostly unchanged:
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data/
innodb_log_arch_dir = /usr/local/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
Hope someone can help. All is well except for this little issue.
