ibdata1空间用完怎么办?

cxm.cm

我的数据库的表是INNODB类型,我在MY.CNF中开起了INNODB如下:

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /usr/local/mysql/var/
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/var/
innodb_log_arch_dir = /usr/local/mysql/var/
# 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
innodb_force_recovery   = 4
现在我的MYSQL的数据库的目录下该值为:
-rw-rw----  1 mysql mysql 2097152000 Nov 28 14:59 ibdata1
-rw-rw----  1 mysql mysql   10485760 Nov 16 09:28 ibdata2
-rw-rw----  1 mysql mysql  262144000 Nov 28 14:59 ib_logfile0
-rw-rw----  1 mysql mysql  262144000 Nov 24 06:54 ib_logfile1
可以看出我的ibdata1:2000M;ibdata2:10M这l两个值都已经满了,那么我是否需要清空他们?

vyouzhi

1. 
   
2. innodb_data_file_path=/sda1/ibdata1:50M;/sda2/ibdata2:50M:autoextend
   

复制代码

cxm.cm

原帖由 vyouzhi 于 2007-11-28 17:55 发表

innodb_data_file_path=/sda1/ibdata1:50M;/sda2/ibdata2:50M:autoextend

你的意思是多建几个ibdata吗？

wdx-snail

原帖由 vyouzhi 于 2007-11-28 17:55 发表

innodb_data_file_path=/sda1/ibdata1:50M;/sda2/ibdata2:50M:autoextend



INNODB 做成自增长就可以了。   autoextend