Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Big Board Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Battle of best OS for MYSQL # Queries per second vs load? Details »»
Battle of best OS for MYSQL # Queries per second vs load?
Version: , by hydn hydn is offline
Developer Last Online: Sep 2013 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 08-07-2007 Last Update: Never Installs: 0
 
No support by the author.

Whats you avg mysql queries per second?

You can post screen shots etc if you like. Will post mine during peak traffic.

Also what OS are you on?

My specs:
x2 Intel xeon Dual core 5140 2.33ghz
Windows Server 2003 SP2
Mysql 5.0.45
3GB RAM
Queries per second average between 100 and 500
CPU usage between 3% and 10% MAX
RAM usage: between 15% and 20 %

Forum stats:
3,000+ members visit per day
1.500+ post per day
100+ New thread per day
600+ new members daily
175,000+ members
Almost 400,000 total posts (pruned)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 08-08-2007, 04:33 PM
Ati2 Ati2 is offline
 
Join Date: Jan 2006
Location: Budapest, Hungary
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My mysql is not used by a forum, so it might be a little offtopic here, but you wanted the OS+mysql combination, so I'm going to post it anyway:

Queries per second avg: 983.444

The OS is a 64-bit Linux, mysql 5.0.20 (I know I should upgrade, but it hasn't been stopped for over a year, I don't have the heart to shut it down ). The machine is a dual-Xeon Intel.

I'm very satisfied with the mysql performance.
Reply With Quote
  #3  
Old 08-22-2007, 01:33 PM
Keyser Soze Keyser Soze is offline
 
Join Date: Apr 2005
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

- MySQL queries/sec (avg): 325
- page impressions / day: ~150000 (according to Google Analytics - bot-traffic is much higher, of course...)

SuSE Linux, 2 GB RAM, P4 2,4 GHz, MySQL 4.1
Reply With Quote
  #4  
Old 08-22-2007, 03:26 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Queries per second avg: 830.363

64-bit Linux, mysql 5.0.37, Dual Core 2.4 GHz with 2 GB RAM
Reply With Quote
  #5  
Old 08-27-2007, 10:52 AM
Yellow Slider Yellow Slider is offline
 
Join Date: Aug 2006
Posts: 249
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

2200~ uniq users logging in each day
10k~ unique visits
110K~ Page views
4k~ posts
450~ threds
150-200 new users each day

Threads: 2 Questions: 78104006 Slow queries: 489 Opens: 53922 Flush tables: 1 Open tables: 1024 Queries per second avg: 55.247

linux
Reply With Quote
  #6  
Old 08-30-2007, 12:39 PM
speciosa speciosa is offline
 
Join Date: Oct 2006
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

this is akin to starting a thread called "how fast does your modded civic do zero to 60?".

the words loadbalancing, postgresql and clustering come to mind...
Reply With Quote
Reply


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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:29 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04709 seconds
  • Memory Usage 2,242KB
  • Queries Executed 21 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (5)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete