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