If a single DBI query returns (and caches) sufficient data to cause you to have memory problems in a stand-alone process; running multiple concurrent queries via POE (or anything else isn't going to prevent that problem from occuring.

The --quick option of the mysql command is specifically designed to return query results row by row rather than accumulating them all in memory and returning them en-masse. Hence my suggestion to use that.