Math Is Fun Forum

  Discussion about math, puzzles, games and fun.   Useful symbols: ÷ × ½ √ ∞ ≠ ≤ ≥ ≈ ⇒ ± ∈ Δ θ ∴ ∑ ∫ • π ƒ -¹ ² ³ °

You are not logged in.

#1 2009-05-13 05:42:45

simron
Real Member
Registered: 2006-10-07
Posts: 237

Forum error

Sometimes, when I click on a topic, it comes up with this error:

An error was encountered
Error: Unable to connect to MySQL server. MySQL reported: User mathsis already has more than 'max_user_connections' active connections.
What is this?


Linux FTW

Offline

#2 2009-05-13 06:00:07

random_fruit
Member
Registered: 2008-12-25
Posts: 39

Re: Forum error

MySQL is the system (a database management system) which stores and organises the message texts of Maths is fun.  When designing an application of a database, it is desirable to have an allowed maximum number of uses at any one time.  The error message above says the system has already reached this limit, and so you can't connect.

Offline

#3 2009-05-13 06:17:33

simron
Real Member
Registered: 2006-10-07
Posts: 237

Re: Forum error

Yes, but when I refresh, it goes away.


Linux FTW

Offline

#4 2009-05-13 07:06:16

random_fruit
Member
Registered: 2008-12-25
Posts: 39

Re: Forum error

Perhaps in the time it takes you to refresh, the number of users goes down?  It's probable that the database system (MySQL) only has a user connected during the period the messages are being selected from the database.  This is only happening between a user clicking on a message title and the message text appearing on his/her screen.

Offline

#5 2009-05-13 07:08:39

random_fruit
Member
Registered: 2008-12-25
Posts: 39

Re: Forum error

Perhaps in the time it takes you to refresh, the number of users goes down?  It's probable that the database system (MySQL) only has a user connected during the period the messages are being selected from the database.  This is only happening between a user clicking on a message title and the message text appearing on his/her screen. 

Amusing... when I pressed the 'submit' button for this post, I got the same message myself!

Offline

#6 2009-05-13 09:09:27

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

Re: Forum error

Hi random_fruit

  I am getting that error also. Thanks for the MySQL info.


In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

#7 2009-05-13 09:43:49

MathsIsFun
Administrator
Registered: 2005-01-21
Posts: 7,711

Re: Forum error

The server is having a busy day.

I set limits so it does not run out of memory ... if memory runs low it starts shutting down entire services that would disable the site.

So rather than have the building burn down it is better to limit how many people can be inside at one time.


"The physicists defer only to mathematicians, and the mathematicians defer only to God ..."  - Leon M. Lederman

Offline

#8 2009-05-13 10:40:11

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

Re: Forum error

Hi MathsisFun;

  Thanks for explaining it.


In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

Board footer

Powered by FluxBB