boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - MYSQL 的LOG SIZE怎么在不停 变大
相关主题
mysql rebuild index very slow
MySQL的InnoDB表不支持full text index 怎么办?
大虾帮忙看看MySQL的设置
MySQL concat 使用一问
why this full-text search doenst work properly?
MySQL Server is Open Source, even Backup extensions(ZZ)
help: questions about MySql
大批量文本的存储与查询,用什么数据库比较合适?
MySQL row selection question
问个基础的理论问题----数据库的基本差异
相关话题的讨论汇总
话题: myisam话题: innodb话题: mysql话题: size话题: log
进入Database版参与讨论
1 (共1页)
j**n
发帖数: 54
1
我们要保留大概30天的数据, 然后不要的就用DELETE去掉, 现在发现数据库的SIZE还
是在不停变大。 什么原因有大虾知道吗?
多谢多谢。
j**n
发帖数: 54
2
是不是DELETE掉的ROW只是LOGICALLY MARK,而没有真正DELETE掉。 有知道解决办法的
吗?鞠躬了。
I******e
发帖数: 101
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**n
发帖数: 54
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******e
发帖数: 101
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?
1 (共1页)
进入Database版参与讨论
相关主题
问个基础的理论问题----数据库的基本差异
Oracle to buy SUN? (转载)
Meet some of the MySQL geeks at SANTA CLARA
MySQL DBA 的前途
mysql innodb 文件转换
急问一个数据库的问题
job openning-Test and Quality Engineer,MySQL Database Admin (转载)
【签名】支持yunmeng办mysql讲座的
MySQL table either insert or drop/truncate table running forever
熟MySQL的同学请帮忙
相关话题的讨论汇总
话题: myisam话题: innodb话题: mysql话题: size话题: log