distal-attribute
distal-attribute
distal-attribute
distal-attribute

losing records from a mysql table

User, date Message
Written by delmardata
1 year ago
Category: General
2 posts since Tue, 09 Jul 13
Mysql 5.1.61 using PHP
I records are randomly deleted from a single table (pcdtl) within a mysql database. I have created a history table(pchist) that gets written to each time the pcdtl gets written to (insert into). Records are never deleted. I have combed thru the code many times to validate this fact. The table is written to quite frequently by a variety of users. Records randomly and inconsistently are deleted from this table. As table usage increases, this issue occurs more frequent. There are approx 60 tables in the database and many have equal high usage without losing records.

Is there a known cause? Should the file be optimized/repaired on a regular basis? Any ideas would be appreciated
Dennis
Del Mar Data Systems
Written by ansgar
1 year ago
4936 posts since Fri, 07 Apr 06
Probably your table is broken somehow. Try to run

REPAIR TABLE xyz

Written by delmardata
1 year ago
2 posts since Tue, 09 Jul 13
I have run the repair utility weekly and it does not fix the problem.
Written by jfalchMoney, Euro
1 year ago
380 posts since Sat, 17 Oct 09
you could try to switch on the serverĀ“s log. this will make access times lousy, but you can at least see what happens. (a possibly slightly faster, but more arduous variant would be to replicate to a separate test slave server, and have that one log in clear).
 

Please login to leave a reply, or register at first.