Talk Arcades: Forum for Arcade Webmasters    

  Talk Arcades > Arcades > Webmastering

Welcome to Talk Arcades, the premier forum for arcade webmasters.

You are currently viewing our boards as a guest. By joining our community you will be able to make posts, communicate privately with other arcade webmasters and participate in our Live Marketplace. Registration is easy, so please join us today!

Reply
 
LinkBack Thread Tools Display Modes
Old 09-18-2008, 09:43 AM   #1 (permalink)
Fahd
Senior Member
 
Fahd's Avatar
 
Join Date: Jul 2007
Posts: 1,170
Fahd is on a distinguished road


Question 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.
Fahd is online now  
Digg this Post!
Reply With Quote
Old 09-18-2008, 02:33 PM   #2 (permalink)
ArcadeJunky
Administrator
Senior Member
 
ArcadeJunky's Avatar
 
Join Date: Aug 2006
Posts: 636
ArcadeJunky is on a distinguished road


Default

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 }

ArcadeJunky is offline  
Digg this Post!
Reply With Quote
Old 09-18-2008, 02:40 PM   #3 (permalink)
Fahd
Senior Member
 
Fahd's Avatar
 
Join Date: Jul 2007
Posts: 1,170
Fahd is on a distinguished road


Default

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?
Fahd is online now  
Digg this Post!
Reply With Quote
Old 09-18-2008, 02:53 PM   #4 (permalink)
EarthWind
Full Member
 
EarthWind's Avatar
 
Join Date: Mar 2007
Posts: 88
EarthWind is on a distinguished road


Default

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.
EarthWind is online now  
Digg this Post!
Reply With Quote
Old 09-18-2008, 03:03 PM   #5 (permalink)
ArcadeJunky
Administrator
Senior Member
 
ArcadeJunky's Avatar
 
Join Date: Aug 2006
Posts: 636
ArcadeJunky is on a distinguished road


Default

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 }

ArcadeJunky is offline  
Digg this Post!
Reply With Quote
Old 09-18-2008, 03:39 PM   #6 (permalink)
ILL-EAGLE
First Time Poster
 
Join Date: Jun 2008
Posts: 1
ILL-EAGLE is on a distinguished road


Default

Off Topic: Mark (ArcadeJunky), I've sent you 3 emails and 2 PM's here, please get back to me dude.
ILL-EAGLE is offline  
Digg this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT -6. The time now is 10:30 PM.


Powered by vBulletin® Version 3.6.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.0.0 RC6
© TalkArcades.com
Forum - Register - Calendar - Memberlist - FAQ - Search