On Friday, 28. June 2002 19:29, Anil Garg wrote: Hi Anil,
> Now, when i run the following query: > mysql> select * from xoops_groups_modules_link where type='R' and mid=2 and > groupid=3 ; > ERROR 2006: MySQL server has gone away > No connection. Trying to reconnect... > Connection id: 1 > Current database: xoops > Looks like your query is too slow and you will get a timeout. Add an index to type and mid (or if possible a multi-column index) and try it again. Regards Georg --------------------------------------------------------------------- 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
