hi, Dilipkumar Thank you very much!
I think I know the fact: The Innodb can't reuse the deleted rows' disk space. And a solution is: dump the data; shutdown mysql; delete the files; restart mysql; import the data. Regards, Leo Huang 2006/7/24, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Hi, Try using the optimize table tablename ,but this will keep the data accordingly,but really if it is a disk space constraint you can go with re-org process in which you will have to get a down time for mysql db.Process is something like . Dump all the Innodb tables drop the existing innodb tables and shutdown mysql, clear the Innodb log-space as ibdata1 & indata2 & iblogfile0 & iblogfile1 and also the redo logs of the innodb. Then start the mysql this will create innodb logs 1 & innodb2 as what u have mentioned in ur cnf file and import the dump . In this case u can able to reduce the space usage of innodb. Try this it might help u out. With Regards Dilipkumar [EMAIL PROTECTED]: > Hi, all > > I know the Innodb use MVCC to achieve very high concurrency. Can > Innodb reuse the deleted rows disk space? I have an database which > have many update operation. If Innodb can\'t reuse the space of deleted > rows, I worry about that MySQL will exhaust our disk space very > quickly. > > Any recommend will be welcome! > > > Regards, > Leo Huang > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
