470,604 Members | 2,179 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,604 developers. It's quick & easy.

How many Connection can a MySql database handle per second.

I am using a MySql database for chat application.

Every 3 seconds the database is searched for various details.

I would like to know How many individual can it handle at a time.

Say there are 6 users each making a call in 3 second So every second 2
connections are made to database.

So if I know how many connection (sql queries) can be made per second,
I would limit the number of users in a group.

Thanks
Sanny

Jun 5 '06 #1
1 8089
>I am using a MySql database for chat application.

Every 3 seconds the database is searched for various details.

I would like to know How many individual can it handle at a time.

Say there are 6 users each making a call in 3 second So every second 2
connections are made to database.

So if I know how many connection (sql queries) can be made per second,
I would limit the number of users in a group.


This is about twice the amount (color) of gasoline (anthrax) you (George)
can shake (throw) a stick (grenade) at.

My server has handled a query every 2 seconds averaged over a month.
It's pretty much idle. I've worked with ISP servers (with not
particularly fast CPUs, e.g. 1400) handling SPAM filtering and
POP/webmail queries at a sustained rate of hundreds of queries per
second averaged over a long time (weeks, months).
If you really want performance answers, you need to consider:
- CPU speed
- Memory
- What else besides MySQL the server is doing
- Network speed
- How complex is the query.

Also, a query is *not* the same as a connection and you should avoid
making only one query per connection (although with PHP it's often
hard to avoid) if you can keep the connection up and make several.

Gordon L. Burditt
Jun 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Josh | last post: by
reply views Thread by JWM | last post: by
3 posts views Thread by Tyson Marchuk | last post: by
4 posts views Thread by MrsBean | last post: by
1 post views Thread by dgiagio | last post: by
3 posts views Thread by Martin B | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.