MySQL errors if page is being hit too hard
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?
Subject
Written By
Posted
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.