try looking for SELECT * and missing or inefficient WHERE or LIMIT clauses on the SELECT.
As for automation of this, I would resort to Google or your favourite PHP or MySQL sites, whether there's any GPL tools or not I don't know, generally load testing tools are quite expensive. |