Hi, MySQL 3.22.32 has worked well on my bsd system until recently when there are frequent crashes. I think this is related to an increase in table size.
It happens episodically but can be consistently reproduced with a command such as this - mysql> alter Table KeywordIndex add Index(MessageID); ERROR 2013: Lost connection to MySQL server during query mysql> (KeywordIndex has 50000 entries). I have increased the following System variables - --set-variable max_allowed_packet=67108864 --set-variable connect_timeout=60 --set-variable tmp_table_size=8388608 --set-variable table_cache=128 I have struggled with this for some time and any suggestions would be very much appreciated. Thanks, Tony Lembke --------------------------------------------------------------------- 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
