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