What about getting a bigger drive?
Asif Iqbal wrote:
Hi All
My mysql data dir is filled up to 95% and only 345M left.
Here is the dir looks like
1.9G ibdata1 3.1G ibdata2 3.0K ib_arch_log_0000000002 3.0K ib_arch_log_0000000004 25K ib_arch_log_0000000000 65M rt3 67K webrt.err 70K mysql 101M ib_logfile0 101M ib_logfile1
Here is my my.cnf file looks like
[..related portion..]
innodb_data_home_dir = /usr/local/mysql/data/ innodb_data_file_path = ibdata1:1882M;ibdata2: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 = 384M innodb_additional_mem_pool_size = 20M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 100M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50
Any help to clean the dir would be greatly appreciated
Thanks
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
