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.
Thanks in advance! Chris Bergeron
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]