Ignore this query folks, my damn signal timer was causing the problem, why I was accessing mysql from a signal interrupt, i'll never know.
sorry for wasting anyones time. thanks, paul > I should also mention that this error is only happening using the mysql C > API ( mysql_query() ). If i use mysql client and paste the exact same query, > i get the proper result everything. > > thanks, > > paul > > > > hello, > > > > When I perform a large union query with 11 tables I often get this error: > > > > Lost connection to MySQL server during query > > > > If I shorten the query to say, 3 or 4 tables, I never get that error. The > > thing is, the large 11 table union query works sometimes, probably 3 out > of > > 5. > > > > Any ideas? > > > > Regards, > > > > paul > > > > > > > --------------------------------------------------------------------- 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