lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fran├žois Schiettecatte <fschietteca...@gmail.com>
Subject Re: DIH: Exception with "Too many connections"
Date Tue, 31 May 2011 11:44:03 GMT
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.chan@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.chan@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.chan@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


Mime
View raw message