In a huge database, even a SELECT with no WHERE clause can tie up considerable r... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

jtbigwoo on March 8, 2011 | parent | context | favorite | on: Anatomy of a Crushing

In a huge database, even a SELECT with no WHERE clause can tie up considerable resources.

neilk on March 9, 2011 | [–]

--i-am-a-dummy also limits the number of rows you can SELECT or JOIN.

dasil003 on March 8, 2011 | [–]

You can kill it though, use SHOW PROCESSLIST

Consider applying for YC's Winter 2027 batch! Applications are open till November 2.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact