MySQL Forums
Forum List  »  Newbie

Why after clearing millions of records, I can't query the table data?
Posted by: Cesar Murilo Cesar
Date: November 24, 2019 11:30AM

In the freeradius database, remove records older than one month from the radacct table. There were 91,676,193 records. After the removal, which lasted 4 hours, there were 1,346,268 records. The problem is that after this cleanup a simple command 'SELECT * FROM radacct LIMIT 10;' does not finish the search; while SELECT COUNT (*) FROM sends me information directly 1,346,268. What can happen to a table? OPTIMIZE? A table engine has innodb.

I said MySQL in the title, when it really comes to MariaDB. OS is Slackware 14.1. And one table in question has the innodb engine.

Options: ReplyQuote


Subject
Written By
Posted
Why after clearing millions of records, I can't query the table data?
November 24, 2019 11:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.