Chinaunix

标题: ibdata1空间用完怎么办? [打印本页]

作者: cxm.cm 时间: 2007-11-28 15:46
标题: ibdata1空间用完怎么办?
我的数据库的表是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 时间: 2007-11-28 17:55

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

复制代码

作者: cxm.cm 时间: 2007-11-29 13:18

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

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

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

作者: wdx-snail 时间: 2007-11-29 13:59
原帖由 vyouzhi 于 2007-11-28 17:55 发表

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

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

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)