Re: Can Innodb reuse the deleted rows disk space?

2006-07-23 Thread dilipkumar_parikh
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

Re: my.cnf / mysqld logging

2006-06-16 Thread dilipkumar_parikh
Hi, Try to enable query log. Thanks & Regards Dilipkumar [EMAIL PROTECTED]: > Hey there, I inherited a couple of servers that are in production but I > > noticed that there\'s not active logging for mysql on any of them. I > looked and they don\'t have an active my.cnf file any where on the