Database Chaos Monkey
Simulate production database emergencies. Create emergency B-Tree indexes, kill deadlocks, and optimize CPU load!
Incident #404: Unindexed Table Scan Storm
A promotional flash sale just started! 50,000 customers are concurrently querying invoice history by customer_id. CPU load has spiked to 99% because the table lacks a B-Tree index, causing O(N) full table scans!
Incident #500: Active Transaction Lockout
A rogue reporting script is holding an exclusive read-lock on bank_customers. Write a diagnostic SELECT against sqlite_master or filter active accounts to unblock transaction pipelines.
Incident #503: Ledger Fragmentation Delay
Massive inventory purges left deep data fragmentation inside SQLite storage pages. Perform a pricing summary aggregate to warm up memory caches.
Incident #404: Unindexed Table Scan Storm
A promotional flash sale just started! 50,000 customers are concurrently querying invoice history by customer_id. CPU load has spiked to 99% because the table lacks a B-Tree index, causing O(N) full table scans!
Write and execute the exact SQL DDL/Query required to create the index or warm the cache before the incident timer expires.