Home / server / Questions / 198855
Accepted
Utku Dalmaz
Asked: 2010-11-06 20:09:12 +0800 CST

Periodic Mysql Data loss

  • 772

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

mysql data-loss

2 Answers

    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.

    • 3
  2. Best Answer

    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?

    • 1