By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,077 Members | 1,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,077 IT Pros & Developers. It's quick & easy.

mysql shuts down during rapid execution of querys

P: n/a
Hello

I am using version 4.0.12-nt of MySQL and when I hit the enter key
rapidly I can't connect to the database. The result is a message is
returned to me from mysql that says I can't connect because the
database is down. If I only hit the 'enter' key once (to execute the
page that my queries are on(their are four queries on this particular
web page)) my queries execute just fine.

We have noticed that this only happens when we:

execute two or more queries, an example of two of those queries would
be:

select seminar_id, title, date_format(date, "%M,%d,%Y") from seminar
where match(text1) against ("kent district library") or match(text2)
against ("kent district library") or match(text3) against ("kent
district library")

select webpage_id, webpage_category, webpage_url from webpages where
match(webpage_content) against ("kent district library")
We have commented out all but one query on our web page and repeated
the same events of rapidly hitting the enter key and much to our
supprise "the database does not shut down, and the single query
executes". Uncomment any of the other querys and WHAM, mysql shuts
down!

The page of which I speak is a php page that - opens the database -
calls mysql_query() with each query and then closes the database after
formating the query results to display on a web page.

We cannot re-create the situation in a previous version of MYSQL.

WE DON'T BELIEVE THAT ITS NECCESSARILY THE QUERYS BECAUSE WE HAVE
NOTICED THAT WE GET THE SAME ERROR MESSAGE "CANNOT CONNECT TO
DATABASE" BOTH AT THE CONNECTION FUNCTION AND AT THE FUNCTION THAT
EXECUTES A QUERY AFTER THE CONNECT HAS EXECUTED SUCCESSFULLY.

We would be every so GREATFULL and FOREVER in DEBT to anyone that
could tell us how we can keep MYSQL from going down. Would it help to
call a timer() event in the beginning of our php page just before the
connect statment to slow things down? We think that perhaps MYSQL is
being OVERWHELMED!!! with request and is shutting itself down! Is
that possible and how could we prevent it?

MANY MANY THANKS to ANYONE that can HELP US!
thx Brian
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
br**********@hotmail.com (Brian) wrote in message news:<f0**************************@posting.google. com>...
"BACKGROUND on 09/11/03"...
I am using version 4.0.12-nt of MySQL and when I execute a web page
that has multiple queries on it I can't connect to the database and
that is because the database has gone down. What's returned to me is
a error that says that I've lost my connection to MYSQL. We have no
idea of why, it was up before we executed the queries.
"WHAT WE FOUND 09/18/03"...
We tried using 2-3 different versions of MYSQL on our windows 2000
server from version 3.23.49-nt and up and continued to have the same
problem.

Our IP loaded the same web application and ran the same web page under
the same conditions as us (but on a LINUX server)with MYSQL version
3.23.49-nt and had no problem at all (that is MYSQL did not go down
while we executed our queries!). WE CONCOLUDED that the problem is
platform specific.

IN SHORT, Win 2000-server sucks for open source products like MYSQL.

Would love to hear anyones opinion.

Much appreciation for any insight.

thx Brian J Stoffer
Jul 19 '05 #2

P: n/a
br**********@hotmail.com (Brian) wrote in message news:<f0**************************@posting.google. com>...
"BACKGROUND on 09/11/03"...
I am using version 4.0.12-nt of MySQL and when I execute a web page
that has multiple queries on it I can't connect to the database and
that is because the database has gone down. What's returned to me is
a error that says that I've lost my connection to MYSQL. We have no
idea of why, it was up before we executed the queries.
"WHAT WE FOUND 09/18/03"...
We tried using 2-3 different versions of MYSQL on our windows 2000
server from version 3.23.49-nt and up and continued to have the same
problem.

Our IP loaded the same web application and ran the same web page under
the same conditions as us (but on a LINUX server)with MYSQL version
3.23.49-nt and had no problem at all (that is MYSQL did not go down
while we executed our queries!). WE CONCOLUDED that the problem is
platform specific.

IN SHORT, Win 2000-server sucks for open source products like MYSQL.

Would love to hear anyones opinion.

Much appreciation for any insight.

thx Brian J Stoffer
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.