Hi!
>>>>> "rafe" == rafe <[EMAIL PROTECTED]> writes: >> Description: rafe> I am not subscribe to this list so please cc me in your reply. rafe> I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a fresh build and there has been no activity except for the following: rafe> 1) Record inserts from flat file parsing. rafe> 2) OPTIMIZE TABLE wich died in batch & caused me to try and run the REPAIR. rafe> I've also tried complete rebuilds with the same data and I get the same crashi but builds with less data (~4GB) have worked. rafe> The REPAIR TABLE dies repeatedly with: mysql> repair table dna; rafe> ERROR 2013: Lost connection to MySQL server during query rafe> I've tried '-O max_allowed_packet=33554432' as per section A.2.2. But with the same results. REPAIR should be independent of max_allowed_packet. We have many users of MySQL with tables bigger than 4G, so this is not a general problem. Please take a backup of your table and try a repair with the 'myisamchk' utility. As Sinisa said, please try REPAIR with our latest binary. If you get the same problem with MySQL 3.23.49, can you give us access to a copy of that table so that we can fix this problem ASAP ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
