News for hackers. Stuff that matters.

A comment on How I Fired Myself. Parent comment

Re:How I Fired Myself by MBCook on Wednesday February 27, 2013 @11:43AM (#5293242)
Plus read-only isn't a guarantee. You can't write data, but you can run a bad select or join that ends up effectively locking the database.

SELECT * FROM my_200_GB_table will always be there.

[ Parent | on HN ]
Re:How I Fired Myself by michaelt on Thursday February 28, 2013 @12:59PM (#5299912)
Why should a select or join lock a database? Surely no database lets one query starve another of IO or CPU?
[ Parent | on HN ]