DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin





DragonByte Tech Proudly Hosted By Hivelocity.net
Custom Fitted Forum Hosting from Hivelocity

View RSS Feed

eva2000

vB Optimise Pro + vB datastore caching awesome reduction in MySQL reloaded query load

Rate this Entry
I'd like to say that vB Optimise Pro is an awesome product and has helped alot of my personal vB clients I consult for in terms of reducing MySQL end query load. I wrote about this on my personal blog at http://vbtechsupport.com/1526/ and thought I'd share some of my vB client's results using vB Optimise Pro on their Litespeed web server + memcached caching servers.

The below screenshots are from 2 clients who use vB optimise pro.

  • First vB client saved 2,500+ cache hits/s for 55.3 billion cache hits over 255+ day period!
  • Second vB client saved 9.63 billion cache hits over 418+ day period!


Bloody awesome
0 Thanks, 0 Likes, 0 Dislikes
Thanks 0 Likes 0 Dislikes 0
 
Attached Thumbnails Attached Thumbnails memcached145_4servers_255days_8hrs-png  

memcached145_2servers_418days11hrs-png  

Submit "vB Optimise Pro + vB datastore caching awesome reduction in MySQL reloaded query load" to Digg Submit "vB Optimise Pro + vB datastore caching awesome reduction in MySQL reloaded query load" to del.icio.us Submit "vB Optimise Pro + vB datastore caching awesome reduction in MySQL reloaded query load" to StumbleUpon Submit "vB Optimise Pro + vB datastore caching awesome reduction in MySQL reloaded query load" to Google

Comments

  1. semprot's Avatar
    What script that you used to view memcache stats? I'm interested
    What about your experience with other cache :
    - xcache
    - apc
    - eaccelerator
    - file cache (i think file cache will increase CPU load because more I/O process??)

    Can you tell me best options for litespeed.
    - litespeed 2 / 4 cpu?
    - suphp / dso / fastcgi?
    - optimized memcache setting?

    My forum is not too fast with memcache, compared when i used apc.

    Atm i use litespeed 2 cpu, suphp, and memcache.
    But i don't change any memcache setting. So it's still default i guess, because it is my host that installed it.
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
    Updated 30th April 2012 at 17:36 by semprot
  2. eva2000's Avatar
    When you install memcache php extension from source compile there is a memcache.php file you can setup and configure which shows those stats

    If using single server then APC or Xcache would be faster than Memcached. You only need Memcached when you're using a PHP handler which doesn't support php opcode cachers like APC or Xcache i.e. suPHP and cgi PHP handlers don't support APC or Xcache for apache web servers and default Litespeed php suExec doesn't support APC or Xcache either so you need to use Memcached as I did above.

    If you want to use APC or Xcache, then you need to switch to mod_php (DSO) or fastcgi for Apache or switch to mod_php (DSO) and disable php suExec for Litespeed.

    As to number of cpus for Litespeed it's explained on my blog at here, need to leave a few cpu cores for PHP and other tasks, so cpu cores needed for Litespeed usually halve the number of total cpu cores you have.

    With Litespeed web server and mod_php (DSO) non php suExec or Nginx php-fpm best opcode PHP cacher i find is APC cache if single server setup.

    If you have multiple web servers, you have no choice but to use Memcached as it's only one that has distributed caching support across multiple servers.

    First client above had 2x load balanced Litespeed web servers with php non-suExec mod_php PHP handler but had to use 2x memcached servers per web server (2x2 = 4 memcached servers in total) for caching vB optimise/datastore to be able to share cache across 2x load balanced Litespeed web servers.

    Second client single Litespeed web server with 2x memcached server instances.

    Usually, for my paying private clients I install memcache php extension + memcached server from source compilation and configure them to support multiple memcached server instances per server.
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
    Updated 30th April 2012 at 17:53 by eva2000
  3. semprot's Avatar
    I think i have only 1 web server because i only have 1 physical server (am i correct? i don't know a lot about server things).

    So i can run 2 memcache instances on 1 server?

    Which one do you think will give best performance :
    - suphp + memcache
    - suphp + eaccelerator
    - dso + apc
    - dso + xcache

    because i don't know whats the pros & cons between suphp & dso.
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
  4. eva2000's Avatar
    Read about PHP handlers here DSO (mod_php) vs. CGI vs. suPHP vs. FastCGI | BoomShadow.net

    suPHP is the slowest and most server resource consuming PHP handler of the lot. For both Litespeed and apache based servers it would be from fastest to slowest

    mod_php > fastcgi -> suphp -> cgi

    APC vs Xcache pretty close, just APC seems to have a bit more stability/compatibility with various PHP scripts than Xcache on Litespeed. So Litespeed + APC better. On Apache I prefer Xcache.
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
  5. semprot's Avatar
    Thanks.. All of your information really helps ! I will start contacting my host now.
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
  6. semprot's Avatar
    I've just switched from suPHP to DSO.
    And i tried my 2 old APC scripts on different files : 1 for setting variable, 1 for getting variable.
    But the getting variable is still failed from my litespeed. (memcache is active too).
    Do you know why getting variable is failed?

    Update : after i set vb optimise setting to "apc", from apc.php, misses rate is about 1-5%.
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
    Updated 30th April 2012 at 19:15 by semprot
  7. eva2000's Avatar
    double check you have PHP suExec disabled first you can use my mysqlmymonlite.sh script i mentioned at LiteSpeed Support Forums - View Single Post - High APC Fragmentation

    Of course make sure you aren't using LSPHP with phpSuExec for opcode cache use. I have a mysqlmymonlite.sh script to check for that mysqlmymonlite.sh & mysqlmymon.sh server and mysql stats gathering tool

    Code:
    phpSuExec = 0
    Code:
    ------------------------------------------------
    Litespeed Server & LSAPI PHP Info:
    ------------------------------------------------
    Litespeed web server version: 4.1.12
    WHM / Cpanel version: 11.32.2.25
    
    LSPHP phpSuExec status: 
      < phpSuExec >0
      < phpSuExecMaxConn >20
    
    WHM's PHP Handler config:
    /usr/local/cpanel/bin/rebuild_phpconf --current
    
    Available handlers: dso cgi none
    DEFAULT PHP: 5
    PHP4 SAPI: none
    PHP5 SAPI: dso
    SUEXEC: enabled
    RUID2: not installed
    
    PHP 5.3.10 (litespeed) (built: Feb  7 2012 03:02:29)
    Copyright (c) 1997-2004 The PHP Group
    Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
  8. semprot's Avatar
    Code:
    root@mybox[~]# grep phpSuExec /usr/local/lsws/conf/httpd_config.xml
    <phpSuExec>0</phpSuExec>
    <phpSuExecMaxConn>10</phpSuExecMaxConn>
    
    root@mybox[~]# /usr/local/cpanel/bin/rebuild_phpconf --current
    Available handlers: suphp dso fcgi cgi none
    DEFAULT PHP: 5
    PHP4 SAPI: cgi
    PHP5 SAPI: dso
    SUEXEC: enabled
    RUID2: not installed
    I got the response above, is everything correct?
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
  9. eva2000's Avatar
    Looks okay to me.. personally i disable PHP4 (concurrent php) when i compile PHP for whm/cpanel.
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
  10. semprot's Avatar
    Thanks. Any idea why my 2 apc scripts failed often when getting variable values?
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
  11. eva2000's Avatar
    can you define what you mean by APC failed when testing the 2 scripts ? specific error messages etc ?

    could be APC installed and configured incorrectly
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
  12. semprot's Avatar
    Quote Originally Posted by eva2000
    can you define what you mean by APC failed when testing the 2 scripts ? specific error messages etc ?

    could be APC installed and configured incorrectly
    I created 2 file :
    1. First file contains apc_store()
    2. Second file contains apc_fetch()

    I opened first file, and opened second file. On most of the time (~90%), second file (apc_fetch) returns false.

    But the other strange thing is, i & my members really feel that my forum is much faster than before i use APC.
    But when it goes to admincp > vboptimise > system test, it failed on "getting data" test.
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     
    Updated 3rd May 2012 at 18:29 by semprot
  13. semprot's Avatar
    Finally server testing went well after i flushed my APC cache from admincp.
    0 Thanks, 0 Likes, 0 Dislikes
    Thanks 0 Likes 0 Dislikes 0
     

Trackbacks

Total Trackbacks 0
Trackback URL: