MySQL creates rows out of nothing
After issuing a REPAIR TABLE:
mysql> repair table search_archive_count_checked; +----------------------------------+--------+----------+----------------------------------------------+ | Table | Op | Msg_type | Msg_text | +----------------------------------+--------+----------+----------------------------------------------+ | xxx.search_archive_count_checked | repair | warning | Number of rows changed from 335540 to 365874 | | xxx.search_archive_count_checked | repair | status | OK | +----------------------------------+--------+----------+----------------------------------------------+ 2 rows in set (36.75 sec)
I'm surprised: this is the first database which is able to create rows out of nothing. Violation of the conversation of energy data, eh? ;-)
Comments
Display comments as Linear | Threaded