Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?



Login with username, password and session length
May 24, 2012, 01:14:16 PM

Pages: [1]   Go Down
  Print  
Author Topic: Is there such thing as MySQL queries/connections limits?  (Read 581 times)
aguest
Space Explorer
***
Offline Offline

Posts: 6


« on: April 16, 2003, 06:12:19 PM »

Is there such thing as MySQL queries/connections limits?
Another question...  Rolling Eyes
Logged
Max
Über Jedi
*****
Offline Offline

Posts: 2534



WWW
« Reply #1 on: April 16, 2003, 07:08:57 PM »

Yes, There is a limit of 50 concurrent connections per user. Wich is ALOT of connections Smile
Logged
JamesYap
Intergalactic Superstar
*****
Offline Offline

Posts: 167



WWW
« Reply #2 on: April 16, 2003, 10:33:18 PM »

Concurrent in what basis? 50 users every 1 second?

How do we know if we have reach that limit? Does this forum reach this limit?
Logged

Why LunarPages is the best web hosting? Read our LunarPages Review to find out now.
Boris
Master Jedi
*****
Offline Offline

Posts: 1082



WWW
« Reply #3 on: April 17, 2003, 12:15:50 AM »

the forum doesnt it would need a whole lot of users at the same time browsing the forums (maybe five hundred or more) since mysql connections are really done quickly.

If you plan to have that many users on your site using mysql...you might wanna email support and see that with them before starting up..But you should be allright at any rate with 50 concurrent connections.
Logged

Questions on graphics? Visit the lunarpages Graphics forum!

Bugging Danielle daily since 2003.

Have a Lunar Day!
Max
Über Jedi
*****
Offline Offline

Posts: 2534



WWW
« Reply #4 on: April 17, 2003, 04:24:58 AM »

When you hit the limit you will know. As it won't allow any more connections. It is 50 connections per user. There is no time limit on it.

We never had a site reaching that limit.
Logged
TWebMan
Quantum Encyclopedia Writer
*****
Offline Offline

Posts: 3112



WWW
« Reply #5 on: April 17, 2003, 11:18:31 PM »

A good thing to do is make sure to close your connections with the mysql_close(db connection variable name) or the mysql_free_result(connection variable name) at the bottom of all your pages.

This will make sure the server doesn't try to maintain a connection that is no longer needed.
Logged

"Computers cause people to make more mistakes than any other invention in history, with the possible exception of handguns and tequila."  - Unknown
"Liberty of any kind is seldom lost all at once." - D. Hume
Every day is an Ode to Joy
The planet will be fine... and so will your site
JamesYap
Intergalactic Superstar
*****
Offline Offline

Posts: 167



WWW
« Reply #6 on: April 19, 2003, 09:18:06 PM »

We usually use mysql_pconnect which create a pesistent connection because each stariting connection to mysql take more time. A pesistant connection elimate this time.

From what I know, isn't it forever will be 1 user who connect to MySQL since I am the only user of my account and all connection to the DB will be me!

So do we come up an idea of 50 users?
Logged

Why LunarPages is the best web hosting? Read our LunarPages Review to find out now.
Max
Über Jedi
*****
Offline Offline

Posts: 2534



WWW
« Reply #7 on: April 20, 2003, 04:07:46 AM »

James,

To really make it clear. Every user is allowed to have 50 concurrent mysql connections.

max_user_connections = 50
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: