Scaring people with mysql...

From the archive. First published on thinknuts.net in 2006 and kept as it was, so some links and details may be out of date.

[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..."

geekrandom

Sylwadau · Comments (3)

Comments from the old blog. New comments are closed.

  1. Jon ·

    ... 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.

  2. James Davis ·

    I once issued a MySQL command that took 26 hours to complete. That was a little worrying but it was a very crap server. =)

  3. Bronchitikat ·

    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?"