I have a table logs that has 700,000 records. When I go to the "Browse" section in phpmyadmin to see the records in the table, I click on the "> >" symbol. to go to the "last page", basically to go to the end of the table and see the most recent records.
Phpmyadmin does not show the last records, it always stays in records a month ago and tells me that there is nothing more after the last record that shows me, but if I manually do a SELECT * FROM logs WHERE ID > 785000; , the query if it shows me the last records.
The table was working well until a week ago. The table handles its incremental Auto ID field, therefore the newest records if they have the largest numbers.
Any idea what's happening or how can I resolve this?