Jump to content


Photo

Mysqli problem when user continously hits F5 button


  • Please log in to reply
1 reply to this topic

#1 Tatanka

Tatanka
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 12 December 2005 - 10:52 AM

Hello,

I have created a new database-driven website. I've installed php 5.1.1 and mysql 5.0
I'm working with the Mysqli connector.

Everything works fine. Except when a user starts tampering the website by continuously hitting the F5 button.

On the intro-page of the website, a lot of queries are being fired against the database. When the user hits F5 quickly for, let's say, 50 times the database times out and I get the ugly error:

"Warning: mysqli::mysqli() [function.mysqli]: (HY000/2003): Can't connect to MySQL server on 'localhost' (10048) in..."

After the database 'hangs' and I am unable to connect to it for at least 30 seconds...

Any idea why the tampering makes my database go down for a few secs ?

best regards!
marten


#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 24 December 2005 - 02:33 AM

I think this has to do with a TCP issue related to running MySQL on a Windows box. Sorry I can't help with any other info.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users