Bluehost.com Web Hosting $6.95

HELP: Lost connection to MySQL server during query

This is a discussion on HELP: Lost connection to MySQL server during query within the MySQL Database forums, part of the Database Forums category; Hello. I'm testing MySQL with a simple script (written in php language) that executes 50 "insert" and ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-16-2007
Alessandro Topo Galileo
 
Posts: n/a
Default HELP: Lost connection to MySQL server during query

Hello. I'm testing MySQL with a simple script (written in php language)
that executes 50 "insert" and 1 "delete".
When I run this script, it works.
When I run 20 simultaneous copies of the same script, on 20 different
databases, they work.
When I run 25 simultaneous copies of it, on 25 different databases, they
don't work and I obtain this error:
Error 2013: Lost connection to MySQL server during query
on the delete query of each script.
Even if I try to access a database while the scripts are running, mysql
client wait for some time and then it writes the error 2013.

My goal is to make things work with 100 databases.

I suppose something is wrong in configuration files.
Thank you very much for any suggestion,
Alessandro.
Reply With Quote
  #2 (permalink)  
Old 04-16-2007
Alessandro Topo Galileo
 
Posts: n/a
Default Re: HELP: Lost connection to MySQL server during query

Alessandro Topo Galileo ha scritto:

> When I run 25 simultaneous copies of it, on 25 different databases, they
> don't work and I obtain this error:
> Error 2013: Lost connection to MySQL server during query


I have increased innodb_buffer_pool_size to 512M and now this problem
seems to be solved, but when I launch 75 scripts (on 75 different
databases) at the same time, some of them (4 or 5) fail to connect.
Any suggestion?
Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 09:37 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0