MySQL Forums
Forum List  »  PHP

MySQL errors if page is being hit too hard
Posted by: Josh Finlay
Date: June 29, 2005 07:03PM

We have quite a busy website and lately I have noticed an error appearing:

Error querying the MySQL database: Duplicate entry '1120096657' for key 1

(1120096657 seems to be a timestamp, so it obviously changes)

I have had no luck trying to resolve this
but what I have noticed is that if the site gets hit hard (ie. 5-10 views/sec) then it returns an error for maybe 1/10 hits in that second.

what I want to know is:

why is it doing it?
Is this a MySQL problem, or a PHP problem?
What steps do you advise I should take to rectify this?

Options: ReplyQuote

Written By
MySQL errors if page is being hit too hard
June 29, 2005 07:03PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.