MYSQL 的LOG SIZE怎么在不停变大 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

MYSQL 的LOG SIZE怎么在不停变大

MYSQL 的LOG SIZE怎么在不停变大# Database - 数据库

j*n2006-10-11 07:10

1 楼

我们要保留大概30天的数据，然后不要的就用DELETE去掉，现在发现数据库的SIZE还
是在不停变大。什么原因有大虾知道吗？
多谢多谢。

j*n2006-10-11 07:10

2 楼

是不是DELETE掉的ROW只是LOGICALLY MARK，而没有真正DELETE掉。有知道解决办法的
吗？鞠躬了。

I*e2006-10-11 07:10

3 楼

Almost that. Are you using InnoDB or MyISAM? A simple way is to use
mysqldump to dump everything a file and re-load the database. MySQL does
not have online re-organization ability.
BTW, do you have a lot of indexes?

j*n2006-10-11 07:10

4 楼

thanks. I am using InnoDB right now, because of this, seems I need to change
to MyiSam.
The index file is the same as data file, for MyiSam, rebuild the index or
optimize the table both shrink the files a lot, but no effect on InnoDB
files.

【在 I******e 的大作中提到】

: Almost that. Are you using InnoDB or MyISAM? A simple way is to use
: mysqldump to dump everything a file and re-load the database. MySQL does
: not have online re-organization ability.
: BTW, do you have a lot of indexes?

I*e2006-10-11 07:10

5 楼

In general, InnoDB is much better than MyISAM. If you can tolerate the
downtime, you can do the process periodically.
How large is your data now?