[Mediawiki-l] Re: Exceeding max_questions resource from a wiki

Michelle michelle.sg1 at gmail.com
Wed Jun 29 16:38:03 UTC 2005


Regarding this question... In one day our wiki has crashed again due to 
hitting the 80K connections/hour limit.  If anyone has any suggestions 
on how to debug this I would really appreciate it.

Michelle

> Our ISP-served wiki (running MediaWiki 1.3.11) went down due to this 
> error:
>
> SQL error: User 'our_wiki' has exceeded the 'max_questions' resource 
> (current value: 50000)
>
> The ISP support assured me we did indeed exceed 50K 
> questions/connections in one hour, and that this went on for over 12 
> hours until they increased our limit to 80K questions/hour.
>
> Is this an expected level of database connections for a wiki with 1500 
> articles and about 400 visitors/day?
>
> Would the number of connection requests be any lower using release 
> 1.4.x?
>
> The ISP suggested we create a second db user and change the code to 
> switch between them for accesses so that we avoid hitting the limit.  
> I guess this would mean changing Database.php but it seems very 
> kludgy.  Any thoughts on that would be appreciated.
>
> Michelle




More information about the MediaWiki-l mailing list