Develop a booking systems for niche markets. I have one such marked that uses it very - vigorously.
They have been doing their annual bookings for the new year and suddenly I have 15,000 rows from a specific table dissapear.
The CPU was running high 100% for 2 day during peak times, could has have been the cause? I have checked re-chekkd there is no other obvious cause!
Things in my mind I have been through
SQL injection, its very unlikely as always sanetize the code. Also the table names are not obvious, and we are missing random amounts during a time i know the cpu was 100% for hours.
Bad code - this was my first though, and I have checked and check fory any DELETE, REPLACE even UPDATE on the table
Anybody got some thoughts,
I am running xt-small-RDS by Amazon AWS. It was on a micro server but I have upgraded it and recoded to keep CPU below 50% now sits camly at 2-7%