Re: Disappearing rows
Hi.
Disabling the binlog requires SUPER privilege.
The general query log can also be disabled. SQL_LOG_OFF=1. The same privilege is required.
If you have a rough idea, how many inserts you do and how many rows disappeared, you can use SHOW TABLE STATUS to see how Data_length and Data_free may relate to it. Or use myisamchk -d. (Data records, Deleted blocks).
Another question is how do you check that data is missing. Can you exclude that your query misses some rows?
Regards
Ingo
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
2385
September 01, 2006 03:22AM
1574
September 02, 2006 02:53AM
1653
September 02, 2006 09:42PM
1682
September 03, 2006 01:14AM
Re: Disappearing rows
2063
October 04, 2006 12:12PM
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.