Oct
24

Scaring people with mysql…

[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…”

Posted by Aled Treharne geek, random Subscribe to RSS feed

3 Responses to “Scaring people with mysql…”

  1. Jon says:
    October 24, 2006 at 10:51 am

    … 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 says:
    October 24, 2006 at 11:51 am

    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 says:
    October 24, 2006 at 11:52 am

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