1

Almost once in 2 weeks,i am facing mysql data loss in a table. almost 600 rows are being deleted. I cant trace that issue.

What may cause this or how can i trace who/what makes it ?

Thanks

Utku Dalmaz
  • 1,399

2 Answers2

3
  1. Enable query log (please pay attention to the performance caveats listed on that page)
  2. Wait for said data loss to occur
  3. Examine query log to see what happened
  4. Profit?

In addition to the above steps, I'd also recommend doing a comprehensive audit of your grants to see what user accounts might have access to this database that shouldn't have access.

Community
  • 1
EEAA
  • 110,608
1

Check out aspersa's 'stalk' and 'collect' tools: http://aspersa.googlecode.com/svn/html/stalk.html. Smart use of those should eliminate the need to enable the general query log, which probably gathers way too much data in two weeks to justify.

Other then that: tell us more about your setup: do you run replication? What kind of applications? Who has what kind of access? Do you have any suspects?

Walter Heck
  • 102