24 October 2006
Scaring people with mysql…
Posted by Aled under: geek; random .
[13:48:16] Jon Pearse says:
mysql> delete from table WHERE foo=’a’ AND tableId=8169;
Query OK, 1 row affected (4.39 sec)
[13:48:21] Jon Pearse says: Holy shit
[13:48:27] Jon Pearse says: That scared the crap out of me
Yup, that’s a crap and very busy server.
(For the non-techies, a simple query like that should take a fraction of a second. The fact that it took several seconds makes you think “Just what am I deleting…ohshitohshistohshit…”
… especially as the table in question I was working on is somewhat important to the general operation of {$product} - I was about to start scrambling for the backup.
I once issued a MySQL command that took 26 hours to complete. That was a little worrying but it was a very crap server. =)
I like your blog, Aled. I get a chance to find out what our son has been up to! *Waves to Jon*
Even if my reaction is “Dur?”