Chambon writes: > Hello, > > No there's no thread in my application, > the program use fork but of course a new connection is create after each fork() > > Today before running another test I do the following > - drop then create the tables > - increase the limit for opened file from 1024 to 4096 > > I run a test for 2 hours and I got : > -> Lost connection to MySQL (708) > -> Can't connect to MySQL server (49) //error while trying new > connection > 49 errors in 6 seconds in from 14:07:16 to 14:07:22 (due to a > burst of fork() ) > -> 'ip_adress' is not allowed to connect to this MySQL Server (4) > //error while trying new connection > -> Commands out of sync (6) > > But apart of these errors I have made many successful insert (4457) , update > (11594), select (25017) > that why I am confused and I don't know what to change ! > > Best regards > > -- > Bernard CHAMBON > IN2P3 / CNRS (Centre de Calcul de LYON) > email: mailto:[EMAIL PROTECTED] > Tel : 04 72 69 42 18
Hi! This seems like a typical programming error in multi-tasking ... You must enclose mysql_query/mysql_use/fetch_row commands so that no two processes can go through it in the same time with the same MYSQL and MYSQL_RES handles. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ 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