What is the table type that you're running? because optimize table works on BDB & MyISAM, and MyISAM don't support transactions. Anyway, optimize table shouldn't be done more than once a week or even a month, what you can do is to create a script that analyzes the table and checks for overhead every week say, and if there was some overhead, optimize the table
Ammar --- Ala'a Ibrahim <[EMAIL PROTECTED]> wrote: > Does anyone know a way of not getting too much > overhead in Mysql tables > I have a big database with so many transactions, I > just don't want to > optmize my tables every day > "OPTIMIZE TABLE `table_name`;" > > -- > Ala'a A. Ibrahim > > _______________________________________________ > General mailing list > [email protected] > http://mail.jolug.org/mailman/listinfo/general_jolug.org > __________________________________ Discover Yahoo! Have fun online with music videos, cool games, IM and more. Check it out! http://discover.yahoo.com/online.html _______________________________________________ General mailing list [email protected] http://mail.jolug.org/mailman/listinfo/general_jolug.org
