my sql server > your sql server - GoFuckYourself.com

tg989 · 12-15-2007, 03:41 AM

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

million · 12-15-2007, 03:45 AM

Paullie · 12-15-2007, 03:51 AM

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 · 12-15-2007, 03:55 AM

I think even BTrieve can do that.

tg989 · 12-15-2007, 04:11 AM

Quote:

Originally Posted by 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.

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

Paullie · 12-15-2007, 06:02 AM

dedicated, of course.

Adultnet · 12-15-2007, 06:06 AM

wow thats much

Calvinguy · 12-15-2007, 09:36 AM

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

Babaganoosh · 12-15-2007, 10:40 AM

Quote:

Originally Posted by Calvinguy

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 · 12-15-2007, 11:33 AM

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 · 12-15-2007, 11:42 AM

Quote:

Originally Posted by Babaganoosh

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 · 12-15-2007, 12:24 PM

Quote:

Originally Posted by Calvinguy

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 · 12-15-2007, 01:01 PM

Quote:

Originally Posted by Babaganoosh

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.

12-15-2007, 03:41 AM	#1
tg989 Registered User Join Date: Jun 2007 Posts: 89	my sql server > your sql server post up your own, it is peaking at 580 queries per second right now ;\ __________________ there are 10 types of people in the world, those who understand binary, and those who don't.

12-15-2007, 03:45 AM	#2
million Confirmed User Join Date: Apr 2006 Location: Pornyland Posts: 789	__________________ <sig spot goes here>

12-15-2007, 03:51 AM	#3
Paullie Confirmed User Join Date: Nov 2007 Location: AdToll.com Posts: 174	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. __________________ AdToll - Your Tollgate to Web traffic Buy a Run of Network Ad Credit Card, Paypal and ePassporte

12-15-2007, 03:55 AM	#4
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	I think even BTrieve can do that. __________________ AIM: GrouchyGfy

12-15-2007, 06:02 AM	#6
Paullie Confirmed User Join Date: Nov 2007 Location: AdToll.com Posts: 174	dedicated, of course. __________________ AdToll - Your Tollgate to Web traffic Buy a Run of Network Ad Credit Card, Paypal and ePassporte

12-15-2007, 06:06 AM	#7
Adultnet Confirmed User Join Date: Sep 2003 Posts: 8,713	wow thats much __________________ TrafficCashGold Paying Webmasters Since 1996! Awesome Conversions! Fast Weekly Payments! Over 125 Tours!

12-15-2007, 09:36 AM	#8
Calvinguy Confirmed User Join Date: Oct 2002 Location: European Union Posts: 1,752	17 and 23 days..... get a new host

12-15-2007, 11:33 AM	#10
maddox Confirmed User Join Date: Jan 2004 Location: Vienna, Austria Posts: 648	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