Hi You might also check the 'max_user_connections' settings too if you have that set:
# Maximum number of connections, and per user max_connections = 2048 max_user_connections = 2048 http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html Cheers François On May 31, 2011, at 7:39 AM, Stefan Matheis wrote: > Tiffany, > > On Tue, May 31, 2011 at 12:45 PM, tiffany <tiffany.c...@future.co.jp> wrote: >> I executed the SHOW PROCESSLIST; command. (Is it what you mean? I've never >> tried it before...) > > Exactly this, yes :) > > On Tue, May 31, 2011 at 12:45 PM, tiffany <tiffany.c...@future.co.jp> wrote: >> So, if the number of threads in the process list is larger than >> max_connections, I would get the "too many connections" error. Am I >> thinking the right way? > > Yepp, right > > On Tue, May 31, 2011 at 12:45 PM, tiffany <tiffany.c...@future.co.jp> wrote: >> If it is right, maybe I should think of the commit timing, changing the >> number of max_connections, and/or some other ways... > > You may lift the allowed Number of Connections for the MySQL-Server? > Or, of course - if possible - tweak your SOLR-Settings, correct > > Regards > Stefan
