[TriLUG] MySQL Runaway

Alan Sterger asterger at earthlink.net
Wed May 8 13:55:04 EDT 2013


Brian,

A simple SELECT query containing a "Cartesian join" can bring any 
database to it's knees.  A Cartesian join is the product of all Table A 
rows and all Table B rows, within a join.  This condition can occur in 
untested code or due to a novice developer.

Usually adding a WHERE clause to the SELECT will fix.

Cheers,

-- Alan Sterger





More information about the TriLUG mailing list