Solved

Mysql max. concurrent connection

Posted on 2008-10-31
3
986 Views
Last Modified: 2013-12-13
Wondering more about:

max. concurrent connections.

The information on my server (Shared Godaddy Hosting)
=====================================
Traffic       ø per hour

Received      130 GiB      146 MiB

Sent      798 GiB      893 MiB

Total      928 GiB      1,039 MiB

Connections      ø per hour      %

max. concurrent connections      178      ---      ---

Failed attempts      20 k      21.86      0.09%

Aborted      29 k      32.26      0.14%

Total      22 M      23.61 k      100.00%

=====================================

So  if it's  178 Connections:

Then only 178 people can send a sql query at a time?

Or 178 open connections.

Just wondering more about SQL stuff and deciding on getting a managed/virtual server to speed up performance.

Plan on running a social web app.
(More knowledge about front end than backend databases)

Again, so if I had 300 people using my app...
That would be 300 unique ip's hitting the sql query from php framework inside the social app.

That would mean too many people using it??

Thanks for the help
0
Comment
Question by:cntmedia
3 Comments
 
LVL 9

Expert Comment

by:michofreiha
ID: 22854862
178 connections means 178 people can run queries in the same time...In your script and at the end of each query you should free the connection to the database ...like that a new user can benefit from the connection...so if first use takes 2 sec to get result and free the connection then no one can takes his place during 2 sec only...as soon as he free the connection, another user  can use it...

Hope this will help
0
 
LVL 39

Accepted Solution

by:
Roger Baklund earned 125 total points
ID: 22854966
I think "max. concurrent connections" means there has been a maximum of 178 connections to the server, it is not the limit. To see the limit, issue this sql statement:

show variables like "max_connections"

To get the "max. concurrent connections" value, issue this sql statement:

show status like "Max_used_connections"
0
 

Author Closing Comment

by:cntmedia
ID: 31512225
cxr:

Thanks for answering my questions.

I usually read though the posts, but I thought that I should ask more questions.

Thank you for the reply and the knowledge.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What's wrong with this PDO query? 5 28
How to check if a session is disconnected in php 9 32
PHP Mail error 3 28
How to delete values from an array using php 4 24
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question