Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

MySQL Tables braking!

Quote Reply
MySQL Tables braking!
Hi guys,
My website is really growing fast and now has 30,000 daily visitors and A LOT of searching is going on. We are hosting on a Dual P-III 700Mhz with 1Gb RAM. Apache is set up with a limit of 200 connections and MySQL with a limit of 700 queries. We are running under mod_perl.
Over the last few days, many tables from different databases at our servers have broken (the table says to have -1 records).
When the server´s load average exceeds 12, we turn of mysql.server and then turn it on again, solving the problem.

This is the latest error we´ve had:

Code:
DBSQL (8124): Fatal Error: Unable to execute query: INSERT INTO
Hits_Track (LinkID, IP) VALUES (3991, '200.52.208.17').
Reason: Got error -1 from table handler at
/usr/local/etc/httpd/sites/monografias.com/cgi-bin/jump.cgi line 82
Can anyone help?
Thanks.


Subject Author Views Date
Thread MySQL Tables braking! CyberLuke 2201 Sep 27, 2000, 9:49 AM
Post Re: MySQL Tables braking!
pugdog 2151 Sep 27, 2000, 12:15 PM
Thread Re: MySQL Tables braking!
Alex 2152 Sep 27, 2000, 12:23 PM
Post Re: MySQL Tables braking!
CyberLuke 2128 Sep 28, 2000, 12:51 PM