http://www.perlmonks.org?node_id=1087862


in reply to Re^2: Optimize DBI connect to avoid max_user_connections
in thread Optimize DBI connect to avoid max_user_connections

Sounds like you're using MyISAM. Alter the tables to use the InnoDB engine instead of MyIASM and most if not all of those table lock warnings should go away. InnoDB uses row locks instead of table locks. It can/will use full table locks when warranted for the operation.