I have a table that currently has "438,442" rows. The next AutoIncrement is "854,040"
My clients sometimes report that their record does not save. Though system says it does but when they get back later, the record was not there.
So I wanted to ask if the problem is due to high number of records in the table or something similar ?
I am using standard PHP function to insert MySQL:
$Qry = "INSERT INTO lesson_result (user, marks, grade, date) VALUES ( 23127, 88, 'B', '2012-11-25')";
$isInserted = @mysql_query($Qry) or die(mysql_error());
Another thing I found while I was checking MySQL Runtime Information using PhpMyAdmin is:
Table_locks_waited : 2,298
Can we consider this as the cause of problem?