Christopher M Bergeron <[EMAIL PROTECTED]> wrote: > Does anyone know of any guidelines or references that I can refer to > with regard to how long it takes to Optimize tables? I'm running on a > 3GHz x86 [single] processor box with SCSI RAID and lots of ram. The > Mysql db files are approx. 35G (uncompressed). The table in question is > described like this: > > +---------------+---------------+------+-----+---------+-------+ > | siteEvent_oid | bigint(255) | | PRI | 0 | | > | vendorHandle | varchar(255) | YES | | NULL | | > | eventCode | int(11) | | | 0 | | > | visitorId | varchar(255) | | MUL | | | > | sessionId | varchar(255) | YES | | | | > | timestamp | timestamp(14) | YES | MUL | NULL | | > +---------------+---------------+------+-----+---------+-------+ > > Can anyone give me an estimate on how long it would take to optimize > this? I don't want to start the process and not know how long it will > take to complete.
A very rough estimate - it will take as much time as needed to physically copy the whole table files (MYD, MYI, frm) twice. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]