MySQL Queries Per Second?

Fahd · 09-18-2008, 09:43 AM

Please post your mysqladmin status queries per second stats. I'm averaging around 300-400 QPS. It would be interesting to learn the stats of some of the arcade banner exchanges.

ArcadeJunky · 09-18-2008, 02:33 PM

The FunKlicks database server is running only around 200-250 QPS thanks to some serious optimization and caching.

Fahd · 09-18-2008, 02:40 PM

Thanks for sharing that Mark, do you have a dedicated db server or is it on the same physical server as your web and file server?

EarthWind · 09-18-2008, 02:53 PM

Wow, you must have some insane traffic.... I'm getting about 9 QPS... Based on my traffic if I were averaging about 350QPS I would probably have about 320,000 uniques/day and almost a 1,000,000 page views a day...

My hats off to you... You must have loads of traffic, or poorly designed DB queries... I would hope not the latter.

ArcadeJunky · 09-18-2008, 03:03 PM

The current FK setup:

1 server that handles general web requests and clicks
1 server that handles database requests
1 server that handles impression requests
4 servers that are dedicated to serving banners

ILL-EAGLE · 09-18-2008, 03:39 PM

Off Topic: Mark (ArcadeJunky), I've sent you 3 emails and 2 PM's here, please get back to me dude.

09-18-2008, 09:43 AM	#1 (permalink)
Fahd Senior Member Join Date: Jul 2007 Posts: 1,170	MySQL Queries Per Second? Please post your mysqladmin status queries per second stats. I'm averaging around 300-400 QPS. It would be interesting to learn the stats of some of the arcade banner exchanges. __________________ Arcade Partner Program \| Arcade Affiliate Program \| Free Website Monitoring Free Games \| Exchange Links \| Download Games New Games \| Top Games \| Arcade Games \| Card Games \| Mahjong Games \| Puzzle Games \| Word Games

09-18-2008, 02:33 PM	#2 (permalink)
ArcadeJunky Administrator Senior Member Join Date: Aug 2006 Posts: 636	The FunKlicks database server is running only around 200-250 QPS thanks to some serious optimization and caching. __________________ >> FunKlicks.com Banner Exchange { 100x100 and 125x125 arcade banners }

09-18-2008, 02:40 PM	#3 (permalink)
Fahd Senior Member Join Date: Jul 2007 Posts: 1,170	Thanks for sharing that Mark, do you have a dedicated db server or is it on the same physical server as your web and file server? __________________ Arcade Partner Program \| Arcade Affiliate Program \| Free Website Monitoring Free Games \| Exchange Links \| Download Games New Games \| Top Games \| Arcade Games \| Card Games \| Mahjong Games \| Puzzle Games \| Word Games

09-18-2008, 02:53 PM	#4 (permalink)
EarthWind Full Member Join Date: Mar 2007 Posts: 88	Wow, you must have some insane traffic.... I'm getting about 9 QPS... Based on my traffic if I were averaging about 350QPS I would probably have about 320,000 uniques/day and almost a 1,000,000 page views a day... My hats off to you... You must have loads of traffic, or poorly designed DB queries... I would hope not the latter. __________________ Downloadable Games Partner Program Free Online Games Quality flash games for your site

09-18-2008, 03:03 PM	#5 (permalink)
ArcadeJunky Administrator Senior Member Join Date: Aug 2006 Posts: 636	The current FK setup: 1 server that handles general web requests and clicks 1 server that handles database requests 1 server that handles impression requests 4 servers that are dedicated to serving banners __________________ >> FunKlicks.com Banner Exchange { 100x100 and 125x125 arcade banners }

09-18-2008, 03:39 PM	#6 (permalink)
ILL-EAGLE First Time Poster Join Date: Jun 2008 Posts: 1	Off Topic: Mark (ArcadeJunky), I've sent you 3 emails and 2 PM's here, please get back to me dude.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Free web hosting, PHP with MySQL, No ads or banners	000webhost.com	Marketing	2	03-31-2008 07:20 AM
mysql database?	vizplay	Webmastering	8	10-18-2007 12:16 PM
[Wanted] The following ArcadeScripts mySql Databases.	allstar	Arcades for Sale	4	10-11-2006 07:57 PM