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.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^4: Optimize DBI connect to avoid max_user_connections
by Alex-WisdomSeeker (Initiate) on May 29, 2014 at 21:29 UTC | |
by fishmonger (Chaplain) on May 29, 2014 at 21:53 UTC |
In Section
Seekers of Perl Wisdom