my sql server > your sql server

[tg989]

post up your own, it is peaking at 580 queries per second right now ;\

[million]

[Paullie]

Traffic ø per hour
Received 4 GB 9 MB
Sent 2 GB 6 MB
Total 6 GB 14 MB
Connections ø per hour %
max. concurrent connections 250 --- ---
Failed attempts 292 0.69 0.00%
Aborted 86 0.20 0.00%
Total 102 M 240.71 k 100.00%

Query statistics: Since its startup, 525,919,072 queries have been sent to the server.
Total ø per hour ø per minute ø per second
526 M 1.25 M 20.78 k 346.26

This MySQL server has been running for 17 days, 13 hours, 54 minutes and 32 seconds. It started up on Nov 27, 2007 at 03:48 PM.

This is one server.

[GrouchyAdmin]

I think even BTrieve can do that.

[tg989]

Traffic ø per hour
Received 4 GB 9 MB
Sent 2 GB 6 MB
Total 6 GB 14 MB
Connections ø per hour %
max. concurrent connections 250 --- ---
Failed attempts 292 0.69 0.00%
Aborted 86 0.20 0.00%
Total 102 M 240.71 k 100.00%

Query statistics: Since its startup, 525,919,072 queries have been sent to the server.
Total ø per hour ø per minute ø per second
526 M 1.25 M 20.78 k 346.26

This MySQL server has been running for 17 days, 13 hours, 54 minutes and 32 seconds. It started up on Nov 27, 2007 at 03:48 PM.

This is one server.

is it a dedicated mysql server though? This one also serves up ~600,000 dynamic pages a day.

[Paullie]

dedicated, of course.

[Adultnet]

wow thats much

[Calvinguy]

17 and 23 days..... get a new host

[Babaganoosh]

17 and 23 days..... get a new host

You realize that number resets if you restart mysql, right? That has nothing to do with the quality of the host.

[maddox]

This is one of my mysql servers in a load balancing setup, keep in mind this is saturday and in the peak hours during the week the queries per second goes over 3500, load aberage is about 1-2 max

[Calvinguy]

You realize that number resets if you restart mysql, right? That has nothing to do with the quality of the host.

There is no reason to restart mysql once it's setup really

[Babaganoosh]

There is no reason to restart mysql once it's setup really

You're kidding, right? As the demands on my mysql server change, I change my my.cnf file to suit my needs. For those changes to take effect, mysql must be restarted. The restart just takes a few seconds and doesn't affect the traffic at all.

I'd be much more concerned with any host who is willing to just set up mysql and never tweak it again regardless of the servers workload.

[tg989]

You're kidding, right? As the demands on my mysql server change, I change my my.cnf file to suit my needs. For those changes to take effect, mysql must be restarted. The restart just takes a few seconds and doesn't affect the traffic at all.

I'd be much more concerned with any host who is willing to just set up mysql and never tweak it again regardless of the servers workload.

not true, you can change almost all the variables from the mysql command line on-the-fly.

SET GLOBAL [varname]=[value]

then edit your my.cnf so it will remain next time the server is restarted.