The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need help optimizing Mysql on my VPS - Full Server Details included

Discussion in 'Workarounds and Optimization' started by mamdeen78, Feb 13, 2013.

  1. mamdeen78

    mamdeen78 Registered

    Joined:
    Feb 13, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hi,

    My VPS is having massive high load averages and sometimes it's slow like hell!. I badly need to optimize mysql and any other needed settings & tweaks on the server to fix this problem.

    Server Information

    knownhost VPS-3 Plan ,CENTOS 6.3 i686 virtuozzo, RAM 1536 MB , RAID-10 65g Disk Space , PHP 5.4.11 , CGI/FastCGI , Nginx as proxy , MySQL version 5.1.66-cll -- MySQL Community Server (GPL) , Xcache 3.0.1


    Processor Information from WHM


    Code:
    Processor Information
    Total processors: 24
    
    Processor #1
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #2
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #3
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #4
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #5
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #6
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #7
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #8
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #9
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #10
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #11
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #12
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #13
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #14
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #15
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #16
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #17
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #18
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #19
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #20
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #21
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #22
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #23
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB
    
    Processor #24
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5645 @ 2.40GHz
    
        Speed
            2400.063 MHz
    
        Cache
            12288 KB

    My.cnf current settings

    Code:
    [mysqld]
    max_connections=500
    query_cache_size=32M
    query_cache_limit=4M
    thread_cache_size=8M
    table_definition_cache=512
    table_open_cache=512
    key_buffer_size=32M
    tmp_table_size=32M
    max_heap_table_size=32M
    interactive_timeout=120
    wait_timeout=120
    long_query_time = 1
    #general_log    
    slow_query_log

    /usr/local/lib/php.ini content ( And you can find the Xcache settings at the end of it )

    Code:
    [PHP]
    
    ;;;;;;;;;;;
    ; WARNING ;
    ;;;;;;;;;;;
    ; This is the default settings file for new PHP installations.
    ; By default, PHP installs itself with a configuration suitable for
    ; development purposes, and *NOT* for production purposes.
    ; For several security-oriented considerations that should be taken
    ; before going online with your site, please consult php.ini-recommended
    ; and http://php.net/manual/en/security.php.
    
    
    ;;;;;;;;;;;;;;;;;;;
    ; About this file ;
    ;;;;;;;;;;;;;;;;;;;
    ; This file controls many aspects of PHP's behavior.  In order for PHP to
    ; read it, it must be named 'php.ini'.  PHP looks for it in the current
    ; working directory, in the path designated by the environment variable
    ; PHPRC, and in the path that was defined in compile time (in that order).
    ; Under Windows, the compile-time path is the Windows directory.  The
    ; path in which the php.ini file is looked for can be overridden using
    ; the -c argument in command line mode.
    ;
    ; The syntax of the file is extremely simple.  Whitespace and Lines
    ; beginning with a semicolon are silently ignored (as you probably guessed).
    ; Section headers (e.g. [Foo]) are also silently ignored, even though
    ; they might mean something in the future.
    ;
    ; Directives are specified using the following syntax:
    ; directive = value
    ; Directive names are *case sensitive* - foo=bar is different from FOO=bar.
    ;
    ; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one
    ; of the INI constants (On, Off, True, False, Yes, No and None) or an expression
    ; (e.g. E_ALL & ~E_NOTICE), or a quoted string ("foo").
    ;
    ; Expressions in the INI file are limited to bitwise operators and parentheses:
    ; |        bitwise OR
    ; &        bitwise AND
    ; ~        bitwise NOT
    ; !        boolean NOT
    ;
    ; Boolean flags can be turned on using the values 1, On, True or Yes.
    ; They can be turned off using the values 0, Off, False or No.
    ;
    ; An empty string can be denoted by simply not writing anything after the equal
    ; sign, or by using the None keyword:
    ;
    ;  foo =         ; sets foo to an empty string
    ;  foo = none    ; sets foo to an empty string
    ;  foo = "none"  ; sets foo to the string 'none'
    ;
    ; If you use constants in your value, and these constants belong to a
    ; dynamically loaded extension (either a PHP extension or a Zend extension),
    ; you may only use these constants *after* the line that loads the extension.
    ;
    ; All the values in the php.ini-dist file correspond to the builtin
    ; defaults (that is, if no php.ini is used, or if you delete these lines,
    ; the builtin defaults will be identical).
    
    
    ;;;;;;;;;;;;;;;;;;;;
    ; Language Options ;
    ;;;;;;;;;;;;;;;;;;;;
    
    ; Enable the PHP scripting language engine under Apache.
    engine = On
    
    ; Allow the <? tag.  Otherwise, only <?php and <script> tags are recognized.  
    ; NOTE: Using short tags should be avoided when developing applications or
    ; libraries that are meant for redistribution, or deployment on PHP
    ; servers which are not under your control, because short tags may not
    ; be supported on the target server. For portable, redistributable code,
    ; be sure not to use short tags.
    short_open_tag = On
    
    ; Allow ASP-style <% %> tags.
    asp_tags = Off
    
    ; The number of significant digits displayed in floating point numbers.
    precision    =  12
    
    ; Enforce year 2000 compliance (will cause problems with non-compliant browsers)
    y2k_compliance = On
    
    ; Output buffering allows you to send header lines (including cookies) even
    ; after you send body content, at the price of slowing PHP's output layer a
    ; bit.  You can enable output buffering during runtime by calling the output
    ; buffering functions.  You can also enable output buffering for all files by
    ; setting this directive to On.  If you wish to limit the size of the buffer
    ; to a certain size - you can use a maximum number of bytes instead of 'On', as
    ; a value for this directive (e.g., output_buffering=4096).
    output_buffering = Off
    
    ; You can redirect all of the output of your scripts to a function.  For
    ; example, if you set output_handler to "mb_output_handler", character
    ; encoding will be transparently converted to the specified encoding.
    ; Setting any output handler automatically turns on output buffering.
    ; Note: People who wrote portable scripts should not depend on this ini
    ;       directive. Instead, explicitly set the output handler using ob_start().
    ;       Using this ini directive may cause problems unless you know what script 
    ;       is doing.
    ; Note: You cannot use both "mb_output_handler" with "ob_iconv_handler"
    ;       and you cannot use both "ob_gzhandler" and "zlib.output_compression". 
    ;output_handler =
    
    ; Transparent output compression using the zlib library
    ; Valid values for this option are 'off', 'on', or a specific buffer size
    ; to be used for compression (default is 4KB)
    ; Note: Resulting chunk size may vary due to nature of compression. PHP 
    ;       outputs chunks that are few hundreds bytes each as a result of 
    ;       compression. If you prefer a larger chunk size for better 
    ;       performance, enable output_buffering in addition.
    ; Note: You need to use zlib.output_handler instead of the standard
    ;       output_handler, or otherwise the output will be corrupted.
    zlib.output_compression = Off
    
    ; You cannot specify additional output handlers if zlib.output_compression
    ; is activated here. This setting does the same as output_handler but in
    ; a different order.
    ;zlib.output_handler =
    
    ; Implicit flush tells PHP to tell the output layer to flush itself
    ; automatically after every output block.  This is equivalent to calling the
    ; PHP function flush() after each and every call to print() or echo() and each
    ; and every HTML block.  Turning this option on has serious performance
    ; implications and is generally recommended for debugging purposes only.
    implicit_flush = Off
    
    ; The unserialize callback function will be called (with the undefined class'
    ; name as parameter), if the unserializer finds an undefined class
    ; which should be instanciated.
    ; A warning appears if the specified function is not defined, or if the
    ; function doesn't include/implement the missing class.
    ; So only set this entry, if you really want to implement such a 
    ; callback-function.
    unserialize_callback_func=
    
    ; When floats & doubles are serialized store serialize_precision significant
    ; digits after the floating point. The default value ensures that when floats
    ; are decoded with unserialize, the data will remain the same.
    serialize_precision = 100
    
    ; Whether to enable the ability to force arguments to be passed by reference
    ; at function call time.  This method is deprecated and is likely to be
    ; unsupported in future versions of PHP/Zend.  The encouraged method of
    ; specifying which arguments should be passed by reference is in the function
    ; declaration.  You're encouraged to try and turn this option Off and make
    ; sure your scripts work properly with it in order to ensure they will work
    ; with future versions of the language (you will receive a warning each time
    ; you use this feature, and the argument will be passed by value instead of by
    ; reference).
    ; allow_call_time_pass_reference = On
    
    ; Safe Mode
    ;
    safe_mode = Off
    
    ; By default, Safe Mode does a UID compare check when
    ; opening files. If you want to relax this to a GID compare,
    ; then turn on safe_mode_gid.
    safe_mode_gid = Off
    
    ; When safe_mode is on, UID/GID checks are bypassed when
    ; including files from this directory and its subdirectories.
    ; (directory must also be in include_path or full path must
    ; be used when including)
    safe_mode_include_dir =								
    
    ; When safe_mode is on, only executables located in the safe_mode_exec_dir
    ; will be allowed to be executed via the exec family of functions.
    safe_mode_exec_dir =
    
    ; Setting certain environment variables may be a potential security breach.
    ; This directive contains a comma-delimited list of prefixes.  In Safe Mode,
    ; the user may only alter environment variables whose names begin with the
    ; prefixes supplied here.  By default, users will only be able to set
    ; environment variables that begin with PHP_ (e.g. PHP_FOO=BAR).
    ;
    ; Note:  If this directive is empty, PHP will let the user modify ANY
    ; environment variable!
    safe_mode_allowed_env_vars = PHP_
    
    ; This directive contains a comma-delimited list of environment variables that
    ; the end user won't be able to change using putenv().  These variables will be
    ; protected even if safe_mode_allowed_env_vars is set to allow to change them.
    safe_mode_protected_env_vars = LD_LIBRARY_PATH
    
    ; open_basedir, if set, limits all file operations to the defined directory
    ; and below.  This directive makes most sense if used in a per-directory
    ; or per-virtualhost web server configuration file. This directive is
    ; *NOT* affected by whether Safe Mode is turned On or Off.
    ;open_basedir =
    
    ; This directive allows you to disable certain functions for security reasons.
    ; It receives a comma-delimited list of function names. This directive is
    ; *NOT* affected by whether Safe Mode is turned On or Off.
    disable_functions = show_source, system, passthru, exec, popen, proc_open, allow_url_fopen
    
    ; This directive allows you to disable certain classes for security reasons.
    ; It receives a comma-delimited list of class names. This directive is
    ; *NOT* affected by whether Safe Mode is turned On or Off.
    disable_classes =
    
    ; Colors for Syntax Highlighting mode.  Anything that's acceptable in
    ; <font color="??????"> would work.
    ;highlight.string  = #DD0000
    ;highlight.comment = #FF9900
    ;highlight.keyword = #007700
    ;highlight.bg      = #FFFFFF
    ;highlight.default = #0000BB
    ;highlight.html    = #000000
    
    
    ;
    ; Misc
    ;
    ; Decides whether PHP may expose the fact that it is installed on the server
    ; (e.g. by adding its signature to the Web server header).  It is no security
    ; threat in any way, but it makes it possible to determine whether you use PHP
    ; on your server or not.
    expose_php = On
    
    
    ;;;;;;;;;;;;;;;;;;;
    ; Resource Limits ;
    ;;;;;;;;;;;;;;;;;;;
    
    max_execution_time = 30     ; Maximum execution time of each script, in seconds
    max_input_time = 60	; Maximum amount of time each script may spend parsing request data
    memory_limit = 512M      ; Maximum amount of memory a script may consume (32MB)
    
    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    ; Error handling and logging ;
    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    
    ; error_reporting is a bit-field.  Or each number up to get desired error
    ; reporting level
    ; E_ALL             - All errors and warnings
    ; E_ERROR           - fatal run-time errors
    ; E_WARNING         - run-time warnings (non-fatal errors)
    ; E_PARSE           - compile-time parse errors
    ; E_NOTICE          - run-time notices (these are warnings which often result
    ;                     from a bug in your code, but it's possible that it was
    ;                     intentional (e.g., using an uninitialized variable and
    ;                     relying on the fact it's automatically initialized to an
    ;                     empty string)
    ; E_CORE_ERROR      - fatal errors that occur during PHP's initial startup
    ; E_CORE_WARNING    - warnings (non-fatal errors) that occur during PHP's
    ;                     initial startup
    ; E_COMPILE_ERROR   - fatal compile-time errors
    ; E_COMPILE_WARNING - compile-time warnings (non-fatal errors)
    ; E_USER_ERROR      - user-generated error message
    ; E_USER_WARNING    - user-generated warning message
    ; E_USER_NOTICE     - user-generated notice message
    ;
    ; Examples:
    ;
    ;   - Show all errors, except for notices
    ;
    ;error_reporting = E_ALL & ~E_NOTICE
    ;
    ;   - Show only errors
    ;
    error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR
    ;
    ;   - Show all errors except for notices
    ;
    ;error_reporting  =  E_ALL & ~E_NOTICE
    
    ; Print out errors (as a part of the output).  For production web sites,
    ; you're strongly encouraged to turn this feature off, and use error logging
    ; instead (see below).  Keeping display_errors enabled on a production web site
    ; may reveal security information to end users, such as file paths on your Web
    ; server, your database schema or other information.
    display_errors = On
    
    ; Even when display_errors is on, errors that occur during PHP's startup
    ; sequence are not displayed.  It's strongly recommended to keep
    ; display_startup_errors off, except for when debugging.
    display_startup_errors = Off
    
    ; Log errors into a log file (server-specific log, stderr, or error_log (below))
    ; As stated above, you're strongly advised to use error logging in place of
    ; error displaying on production web sites.
    log_errors = On
    
    ; Set maximum length of log_errors. In error_log information about the source is
    ; added. The default is 1024 and 0 allows to not apply any maximum length at all.
    log_errors_max_len = 1024
    
    ; Do not log repeated messages. Repeated errors must occur in same file on same
    ; line until ignore_repeated_source is set true.
    ignore_repeated_errors = Off
    
    ; Ignore source of message when ignoring repeated messages. When this setting 
    ; is On you will not log errors with repeated messages from different files or
    ; sourcelines.
    ignore_repeated_source = Off
    
    ; If this parameter is set to Off, then memory leaks will not be shown (on
    ; stdout or in the log). This has only effect in a debug compile, and if 
    ; error reporting includes E_WARNING in the allowed list
    report_memleaks = On
    
    ; Store the last error/warning message in $php_errormsg (boolean).
    track_errors = Off
    
    ; Disable the inclusion of HTML tags in error messages.
    ;html_errors = Off
      
    ; If html_errors is set On PHP produces clickable error messages that direct 
    ; to a page describing the error or function causing the error in detail.
    ; You can download a copy of the PHP manual from http://www.php.net/docs.php 
    ; and change docref_root to the base URL of your local copy including the
    ; leading '/'. You must also specify the file extension being used including 
    ; the dot.
    ;docref_root = "/phpmanual/"
    ;docref_ext = .html
      
    ; String to output before an error message.
    ;error_prepend_string = "<font color=ff0000>"
    
    ; String to output after an error message.
    ;error_append_string = "</font>"
    
    ; Log errors to specified file.
    error_log = error_log
    
    ; Log errors to syslog (Event Log on NT, not valid in Windows 95).
    ;error_log = syslog
    
    
    ;;;;;;;;;;;;;;;;;
    ; Data Handling ;
    ;;;;;;;;;;;;;;;;;
    ;
    ; Note - track_vars is ALWAYS enabled as of PHP 4.0.3
    
    ; The separator used in PHP generated URLs to separate arguments.
    ; Default is "&". 
    ;arg_separator.output = "&"
    
    ; List of separator(s) used by PHP to parse input URLs into variables.
    ; Default is "&". 
    ; NOTE: Every character in this directive is considered as separator!
    ;arg_separator.input = ";&"
    
    ; This directive describes the order in which PHP registers GET, POST, Cookie,
    ; Environment and Built-in variables (G, P, C, E & S respectively, often
    ; referred to as EGPCS or GPC).  Registration is done from left to right, newer
    ; values override older values.
    variables_order = "EGPCS"
    
    ; Whether or not to register the EGPCS variables as global variables.  You may
    ; want to turn this off if you don't want to clutter your scripts' global scope
    ; with user data.  This makes most sense when coupled with track_vars - in which
    ; case you can access all of the GPC variables through the $HTTP_*_VARS[],
    ; variables.
    ;
    ; You should do your best to write your scripts so that they do not require
    ; register_globals to be on;  Using form variables as globals can easily lead
    ; to possible security problems, if the code is not very well thought of.
    register_globals = Off
    
    ; This directive tells PHP whether to declare the argv&argc variables (that
    ; would contain the GET information).  If you don't use these variables, you
    ; should turn it off for increased performance.
    register_argc_argv = On
    
    ; Maximum size of POST data that PHP will accept.
    post_max_size = 8M
    
    ; This directive is deprecated.  Use variables_order instead.
    gpc_order = "GPC"
    
    ; Magic quotes
    ;
    
    ; Magic quotes for incoming GET/POST/Cookie data.
    ; magic_quotes_gpc = On
    
    ; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.
    ; magic_quotes_runtime = Off    
    
    ; Use Sybase-style magic quotes (escape ' with '' instead of \').
    ; magic_quotes_sybase = Off
    
    ; Automatically add files before or after any PHP document.
    auto_prepend_file =
    auto_append_file =
    
    ; As of 4.0b4, PHP always outputs a character encoding by default in
    ; the Content-type: header.  To disable sending of the charset, simply
    ; set it to be empty.
    ;
    ; PHP's built-in default is text/html
    default_mimetype = "text/html"
    ;default_charset = "iso-8859-1"
    
    ; Always populate the $HTTP_RAW_POST_DATA variable.
    ;always_populate_raw_post_data = On
    
    
    ;;;;;;;;;;;;;;;;;;;;;;;;;
    ; Paths and Directories ;
    ;;;;;;;;;;;;;;;;;;;;;;;;;
    
    ; UNIX: "/path1:/path2"  
    include_path = ".:/usr/lib/php:/usr/local/lib/php"
    ;
    ; Windows: "\path1;\path2"
    ;include_path = ".;c:\php\includes"
    
    ; The root of the PHP pages, used only if nonempty.
    ; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
    ; if you are running php as a CGI under any web server (other than IIS)
    ; see documentation for security issues.  The alternate is to use the
    ; cgi.force_redirect configuration below
    doc_root =
    
    ; The directory under which PHP opens the script using /~username used only
    ; if nonempty.
    user_dir =
    
    ; Directory in which the loadable extensions (modules) reside.
    extension_dir = "/usr/local/lib/php/extensions/no-debug-non-zts-20100525"
    zend_extension="/usr/local/IonCube/ioncube_loader_lin_5.4.so"
    extension=timezonedb.so
    
    ; Whether or not to enable the dl() function.  The dl() function does NOT work
    ; properly in multithreaded servers, such as IIS or Zeus, and is automatically
    ; disabled on them.
    enable_dl = Off
    
    ; cgi.force_redirect is necessary to provide security running PHP as a CGI under
    ; most web servers.  Left undefined, PHP turns this on by default.  You can
    ; turn it off here AT YOUR OWN RISK
    ; **You CAN safely turn this off for IIS, in fact, you MUST.**
    ; cgi.force_redirect = 1
    
    ; if cgi.nph is enabled it will force cgi to always sent Status: 200 with
    ; every request.
    ; cgi.nph = 1
    
    ; if cgi.force_redirect is turned on, and you are not running under Apache or Netscape 
    ; (iPlanet) web servers, you MAY need to set an environment variable name that PHP
    ; will look for to know it is OK to continue execution.  Setting this variable MAY
    ; cause security issues, KNOW WHAT YOU ARE DOING FIRST.
    ; cgi.redirect_status_env = ;
    
    ; cgi.fix_pathinfo provides *real* PATH_INFO/PATH_TRANSLATED support for CGI.  PHP's
    ; previous behaviour was to set PATH_TRANSLATED to SCRIPT_FILENAME, and to not grok
    ; what PATH_INFO is.  For more information on PATH_INFO, see the cgi specs.  Setting
    ; this to 1 will cause PHP CGI to fix it's paths to conform to the spec.  A setting
    ; of zero causes PHP to behave as before.  Default is zero.  You should fix your scripts
    ; to use SCRIPT_FILENAME rather than PATH_TRANSLATED.
    ; cgi.fix_pathinfo=0
    
    ; FastCGI under IIS (on WINNT based OS) supports the ability to impersonate
    ; security tokens of the calling client.  This allows IIS to define the
    ; security context that the request runs under.  mod_fastcgi under Apache
    ; does not currently support this feature (03/17/2002)
    ; Set to 1 if running under IIS.  Default is zero.
    ; fastcgi.impersonate = 1;
    
    ; cgi.rfc2616_headers configuration option tells PHP what type of headers to
    ; use when sending HTTP response code. If it's set 0 PHP sends Status: header that
    ; is supported by Apache. When this option is set to 1 PHP will send
    ; RFC2616 compliant header.
    ; Default is zero.
    ;cgi.rfc2616_headers = 0 
     
    
    ;;;;;;;;;;;;;;;;
    ; File Uploads ;
    ;;;;;;;;;;;;;;;;
    
    ; Whether to allow HTTP file uploads.
    file_uploads = On
    
    ; Temporary directory for HTTP uploaded files (will use system default if not
    ; specified).
    ;upload_tmp_dir =
    
    ; Maximum allowed size for uploaded files.
    upload_max_filesize = 64M
    
    
    ;;;;;;;;;;;;;;;;;;
    ; Fopen wrappers ;
    ;;;;;;;;;;;;;;;;;;
    
    ; Whether to allow the treatment of URLs (like http:// or ftp://) as files.
    allow_url_fopen = On
    
    ; Define the anonymous ftp password (your email address)
    ;from="john@doe.com"
    
    ; Define the User-Agent string
    ; user_agent="PHP"
    
    ; Default timeout for socket based streams (seconds)
    default_socket_timeout = 60
    
    ; If your scripts have to deal with files from Macintosh systems,
    ; or you are running on a Mac and need to deal with files from
    ; unix or win32 systems, setting this flag will cause PHP to
    ; automatically detect the EOL character in those files so that
    ; fgets() and file() will work regardless of the source of the file.
    ; auto_detect_line_endings = Off
    
    
    ;;;;;;;;;;;;;;;;;;;;;;
    ; Dynamic Extensions ;
    ;;;;;;;;;;;;;;;;;;;;;;
    ;
    ; If you wish to have an extension loaded automatically, use the following
    ; syntax:
    ;
    ;   extension=modulename.extension
    ;
    ; For example, on Windows:
    ;
    ;   extension=msql.dll
    ;
    ; ... or under UNIX:
    ;
    ;   extension=msql.so
    ;
    ; Note that it should be the name of the module only; no directory information 
    ; needs to go here.  Specify the location of the extension with the
    ; extension_dir directive above.
    
    
    ;Windows Extensions
    ;Note that MySQL and ODBC support is now built in, so no dll is needed for it.
    ;
    ;extension=php_bz2.dll
    ;extension=php_cpdf.dll
    ;extension=php_crack.dll
    ;extension=php_curl.dll
    ;extension=php_db.dll
    ;extension=php_dba.dll
    ;extension=php_dbase.dll
    ;extension=php_dbx.dll
    ;extension=php_domxml.dll
    ;extension=php_exif.dll
    ;extension=php_fdf.dll
    ;extension=php_filepro.dll
    ;extension=php_gd2.dll
    ;extension=php_gettext.dll
    ;extension=php_hyperwave.dll
    ;extension=php_iconv.dll
    ;extension=php_ifx.dll
    ;extension=php_iisfunc.dll
    ;extension=php_imap.dll
    ;extension=php_interbase.dll
    ;extension=php_java.dll
    ;extension=php_ldap.dll
    ;extension=php_mbstring.dll
    ;extension=php_mcrypt.dll
    ;extension=php_mhash.dll
    ;extension=php_mime_magic.dll
    ;extension=php_ming.dll
    ;extension=php_mssql.dll
    ;extension=php_msql.dll
    ;extension=php_oci8.dll
    ;extension=php_openssl.dll
    ;extension=php_oracle.dll
    ;extension=php_pdf.dll
    ;extension=php_pgsql.dll
    ;extension=php_printer.dll
    ;extension=php_shmop.dll
    ;extension=php_snmp.dll
    ;extension=php_sockets.dll
    ;extension=php_sybase_ct.dll
    ;extension=php_w32api.dll
    ;extension=php_xmlrpc.dll
    ;extension=php_xslt.dll
    ;extension=php_yaz.dll
    ;extension=php_zip.dll
    
    
    ;;;;;;;;;;;;;;;;;;;
    ; Module Settings ;
    ;;;;;;;;;;;;;;;;;;;
    
    [Syslog]
    ; Whether or not to define the various syslog variables (e.g. $LOG_PID,
    ; $LOG_CRON, etc.).  Turning it off is a good idea performance-wise.  In
    ; runtime, you can define these variables by calling define_syslog_variables().
    define_syslog_variables  = Off
    
    [mail function]
    ; For Win32 only.
    ;SMTP = localhost
    smtp_port = 25
    
    ; For Win32 only.
    ;sendmail_from = me@localhost.com
    
    ; For Unix only.  You may supply arguments as well (default: "sendmail -t -i").
    sendmail_path = "/usr/sbin/sendmail -t -i"
    
    [Java]
    ;java.class.path = .\php_java.jar
    ;java.home = c:\jdk
    ;java.library = c:\jdk\jre\bin\hotspot\jvm.dll 
    ;java.library.path = .\
    
    [SQL]
    sql.safe_mode = Off
    
    [ODBC]
    ;odbc.default_db    =  Not yet implemented
    ;odbc.default_user  =  Not yet implemented
    ;odbc.default_pw    =  Not yet implemented
    
    ; Allow or prevent persistent links.
    odbc.allow_persistent = On
    
    ; Check that a connection is still valid before reuse.
    odbc.check_persistent = On
    
    ; Maximum number of persistent links.  -1 means no limit.
    odbc.max_persistent = -1
    
    ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
    odbc.max_links = -1  
    
    ; Handling of LONG fields.  Returns number of bytes to variables.  0 means
    ; passthru.
    odbc.defaultlrl = 4096  
    
    ; Handling of binary data.  0 means passthru, 1 return as is, 2 convert to char.
    ; See the documentation on odbc_binmode and odbc_longreadlen for an explanation
    ; of uodbc.defaultlrl and uodbc.defaultbinmode
    odbc.defaultbinmode = 1  
    
    [MySQL]
    ; Allow or prevent persistent links.
    mysql.allow_persistent = On
    
    ; Maximum number of persistent links.  -1 means no limit.
    mysql.max_persistent = -1
    
    ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
    mysql.max_links = -1
    
    ; Default port number for mysql_connect().  If unset, mysql_connect() will use
    ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
    ; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
    ; at MYSQL_PORT.
    mysql.default_port =
    
    ; Default socket name for local MySQL connects.  If empty, uses the built-in
    ; MySQL defaults.
    mysql.default_socket =
    
    ; Default host for mysql_connect() (doesn't apply in safe mode).
    mysql.default_host =
    
    ; Default user for mysql_connect() (doesn't apply in safe mode).
    mysql.default_user =
    
    ; Default password for mysql_connect() (doesn't apply in safe mode).
    ; Note that this is generally a *bad* idea to store passwords in this file.
    ; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
    ; and reveal this password!  And of course, any users with read access to this
    ; file will be able to reveal the password as well.
    mysql.default_password =
    
    ; Maximum time (in seconds) for connect timeout. -1 means no limit
    mysql.connect_timeout = 60
    
    ; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
    ; SQL-Errors will be displayed.
    mysql.trace_mode = Off
    
    [mSQL]
    ; Allow or prevent persistent links.
    msql.allow_persistent = On
    
    ; Maximum number of persistent links.  -1 means no limit.
    msql.max_persistent = -1
    
    ; Maximum number of links (persistent+non persistent).  -1 means no limit.
    msql.max_links = -1
    
    [PostgresSQL]
    ; Allow or prevent persistent links.
    pgsql.allow_persistent = On
    
    ; Detect broken persistent links always with pg_pconnect(). Need a little overhead.
    pgsql.auto_reset_persistent = Off 
    
    ; Maximum number of persistent links.  -1 means no limit.
    pgsql.max_persistent = -1
    
    ; Maximum number of links (persistent+non persistent).  -1 means no limit.
    pgsql.max_links = -1
    
    ; Ignore PostgreSQL backends Notice message or not.
    pgsql.ignore_notice = 0
    
    ; Log PostgreSQL backends Noitce message or not.
    ; Unless pgsql.ignore_notice=0, module cannot log notice message.
    pgsql.log_notice = 0
    
    [Sybase]
    ; Allow or prevent persistent links.
    sybase.allow_persistent = On
    
    ; Maximum number of persistent links.  -1 means no limit.
    sybase.max_persistent = -1
    
    ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
    sybase.max_links = -1
    
    ;sybase.interface_file = "/usr/sybase/interfaces"
    
    ; Minimum error severity to display.
    sybase.min_error_severity = 10
    
    ; Minimum message severity to display.
    sybase.min_message_severity = 10
    
    ; Compatability mode with old versions of PHP 3.0.
    ; If on, this will cause PHP to automatically assign types to results according
    ; to their Sybase type, instead of treating them all as strings.  This
    ; compatibility mode will probably not stay around forever, so try applying
    ; whatever necessary changes to your code, and turn it off.
    sybase.compatability_mode = Off
    
    [Sybase-CT]
    ; Allow or prevent persistent links.
    sybct.allow_persistent = On
    
    ; Maximum number of persistent links.  -1 means no limit.
    sybct.max_persistent = -1
    
    ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
    sybct.max_links = -1
    
    ; Minimum server message severity to display.
    sybct.min_server_severity = 10
    
    ; Minimum client message severity to display.
    sybct.min_client_severity = 10
    
    [dbx]
    ; returned column names can be converted for compatibility reasons
    ; possible values for dbx.colnames_case are
    ; "unchanged" (default, if not set)
    ; "lowercase"
    ; "uppercase"
    ; the recommended default is either upper- or lowercase, but
    ; unchanged is currently set for backwards compatibility
    dbx.colnames_case = "unchanged"
    
    [bcmath]
    ; Number of decimal digits for all bcmath functions.
    bcmath.scale = 0
    
    [browscap]
    ;browscap = extra/browscap.ini
    
    [Informix]
    ; Default host for ifx_connect() (doesn't apply in safe mode).
    ifx.default_host =
    
    ; Default user for ifx_connect() (doesn't apply in safe mode).
    ifx.default_user =
    
    ; Default password for ifx_connect() (doesn't apply in safe mode).
    ifx.default_password =
    
    ; Allow or prevent persistent links.
    ifx.allow_persistent = On
    
    ; Maximum number of persistent links.  -1 means no limit.
    ifx.max_persistent = -1
    
    ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
    ifx.max_links = -1
    
    ; If on, select statements return the contents of a text blob instead of its id.
    ifx.textasvarchar = 0
    
    ; If on, select statements return the contents of a byte blob instead of its id.
    ifx.byteasvarchar = 0
    
    ; Trailing blanks are stripped from fixed-length char columns.  May help the
    ; life of Informix SE users.
    ifx.charasvarchar = 0
    
    ; If on, the contents of text and byte blobs are dumped to a file instead of
    ; keeping them in memory.
    ifx.blobinfile = 0
    
    ; NULL's are returned as empty strings, unless this is set to 1.  In that case,
    ; NULL's are returned as string 'NULL'.
    ifx.nullformat = 0
    
    [Session]
    ; Handler used to store/retrieve data.
    session.save_handler = files
    
    ; Argument passed to save_handler.  In the case of files, this is the path
    ; where data files are stored. Note: Windows users have to change this 
    ; variable in order to use PHP's session functions.
    ; As of PHP 4.0.1, you can define the path as: session.save_path = "N;/path"
    ; where N is an integer.  Instead of storing all the session files in 
    ; /path, what this will do is use subdirectories N-levels deep, and 
    ; store the session data in those directories.  This is useful if you 
    ; or your OS have problems with lots of files in one directory, and is 
    ; a more efficient layout for servers that handle lots of sessions.
    ; NOTE 1: PHP will not create this directory structure automatically.
    ;         You can use the script in the ext/session dir for that purpose.
    ; NOTE 2: See the section on garbage collection below if you choose to
    ;         use subdirectories for session storage
    
    session.save_path = "/tmp"
    
    ; Whether to use cookies.
    session.use_cookies = 1
    
    ; This option enables administrators to make their users invulnerable to
    ; attacks which involve passing session ids in URLs; defaults to 0.
    ; session.use_only_cookies = 1
    
    ; Name of the session (used as cookie name).
    session.name = PHPSESSID
    
    ; Initialize session on request startup.
    session.auto_start = 0
    
    ; Lifetime in seconds of cookie or, if 0, until browser is restarted.
    session.cookie_lifetime = 0
    
    ; The path for which the cookie is valid.
    session.cookie_path = /
    
    ; The domain for which the cookie is valid.
    session.cookie_domain =
    
    ; Handler used to serialize data.  php is the standard serializer of PHP.
    session.serialize_handler = php
    
    ; Define the probability that the 'garbage collection' process is started
    ; on every session initialization.
    ; The probability is calculated by using gc_probability/gc_divisor,
    ; e.g. 1/100 means there is a 1% chance that the GC process starts
    ; on each request.
    
    session.gc_probability = 1
    session.gc_divisor     = 100
    
    ; After this number of seconds, stored data will be seen as 'garbage' and
    ; cleaned up by the garbage collection process.
    session.gc_maxlifetime = 1440
    
    ; NOTE: If you are using the subdirectory option for storing session files
    ;       (see session.save_path above), then garbage collection does *not*
    ;       happen automatically.  You will need to do your own garbage 
    ;       collection through a shell script, cron entry, or some other method. 
    ;       For example, the following script would is the equivalent of
    ;       setting session.gc_maxlifetime to 1440 (1440 seconds = 24 minutes):
    ;          cd /path/to/sessions; find -cmin +24 | xargs rm
    
    ; PHP 4.2 and less have an undocumented feature/bug that allows you to
    ; to initialize a session variable in the global scope, albeit register_globals
    ; is disabled.  PHP 4.3 and later will warn you, if this feature is used.
    ; You can disable the feature and the warning separately. At this time,
    ; the warning is only displayed, if bug_compat_42 is enabled.
    
    session.bug_compat_42 = 1
    session.bug_compat_warn = 1
    
    ; Check HTTP Referer to invalidate externally stored URLs containing ids.
    ; HTTP_REFERER has to contain this substring for the session to be
    ; considered as valid.
    session.referer_check =
    
    ; How many bytes to read from the file.
    session.entropy_length = 0
    
    ; Specified here to create the session id.
    session.entropy_file =
    
    ;session.entropy_length = 16
    
    ;session.entropy_file = /dev/urandom
    
    ; Set to {nocache,private,public,} to determine HTTP caching aspects
    ; or leave this empty to avoid sending anti-caching headers.
    session.cache_limiter = nocache
    
    ; Document expires after n minutes.
    session.cache_expire = 180
    
    ; trans sid support is disabled by default.
    ; Use of trans sid may risk your users security. 
    ; Use this option with caution.
    ; - User may send URL contains active session ID
    ;   to other person via. email/irc/etc.
    ; - URL that contains active session ID may be stored
    ;   in publically accessible computer.
    ; - User may access your site with the same session ID
    ;   always using URL stored in browser's history or bookmarks.
    session.use_trans_sid = 0
    
    ; The URL rewriter will look for URLs in a defined set of HTML tags.
    ; form/fieldset are special; if you include them here, the rewriter will
    ; add a hidden <input> field with the info which is otherwise appended
    ; to URLs.  If you want XHTML conformity, remove the form entry.
    ; Note that all valid entries require a "=", even if no value follows.
    url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="
    
    [MSSQL]
    ; Allow or prevent persistent links.
    mssql.allow_persistent = On
    
    ; Maximum number of persistent links.  -1 means no limit.
    mssql.max_persistent = -1
    
    ; Maximum number of links (persistent+non persistent).  -1 means no limit.
    mssql.max_links = -1
    
    ; Minimum error severity to display.
    mssql.min_error_severity = 10
    
    ; Minimum message severity to display.
    mssql.min_message_severity = 10
    
    ; Compatability mode with old versions of PHP 3.0.
    mssql.compatability_mode = Off
    
    ; Connect timeout
    ;mssql.connect_timeout = 5
    
    ; Query timeout
    ;mssql.timeout = 60
    
    ; Valid range 0 - 2147483647.  Default = 4096.
    ;mssql.textlimit = 4096
    
    ; Valid range 0 - 2147483647.  Default = 4096.
    ;mssql.textsize = 4096
    
    ; Limits the number of records in each batch.  0 = all records in one batch.
    ;mssql.batchsize = 0
    
    ; Specify how datetime and datetim4 columns are returned
    ; On => Returns data converted to SQL server settings
    ; Off => Returns values as YYYY-MM-DD hh:mm:ss
    ;mssql.datetimeconvert = On
    
    ; Use NT authentication when connecting to the server
    mssql.secure_connection = Off
    
    ; Specify max number of processes. Default = 25
    ;mssql.max_procs = 25
    
    [Assertion]
    ; Assert(expr); active by default.
    ;assert.active = On
    
    ; Issue a PHP warning for each failed assertion.
    ;assert.warning = On
    
    ; Don't bail out by default.
    ;assert.bail = Off
    
    ; User-function to be called if an assertion fails.
    ;assert.callback = 0
    
    ; Eval the expression with current error_reporting().  Set to true if you want
    ; error_reporting(0) around the eval().
    ;assert.quiet_eval = 0
    
    [Ingres II]
    ; Allow or prevent persistent links.
    ingres.allow_persistent = On
    
    ; Maximum number of persistent links.  -1 means no limit.
    ingres.max_persistent = -1
    
    ; Maximum number of links, including persistents.  -1 means no limit.
    ingres.max_links = -1
    
    ; Default database (format: [node_id::]dbname[/srv_class]).
    ingres.default_database =
    
    ; Default user.
    ingres.default_user =
    
    ; Default password.
    ingres.default_password =
    
    [Verisign Payflow Pro]
    ; Default Payflow Pro server.
    pfpro.defaulthost = "test-payflow.verisign.com"
    
    ; Default port to connect to.
    pfpro.defaultport = 443
    
    ; Default timeout in seconds.
    pfpro.defaulttimeout = 30
    
    ; Default proxy IP address (if required).
    ;pfpro.proxyaddress =
    
    ; Default proxy port.
    ;pfpro.proxyport =
    
    ; Default proxy logon.
    ;pfpro.proxylogon =
    
    ; Default proxy password.
    ;pfpro.proxypassword =
    
    [com]
    ; path to a file containing GUIDs, IIDs or filenames of files with TypeLibs
    ;com.typelib_file = 
    ; allow Distributed-COM calls
    ;com.allow_dcom = true
    ; autoregister constants of a components typlib on com_load()
    ;com.autoregister_typelib = true
    ; register constants casesensitive
    ;com.autoregister_casesensitive = false
    ; show warnings on duplicate constat registrations
    ;com.autoregister_verbose = true
    
    [Printer]
    ;printer.default_printer = ""
    
    [mbstring]
    ; language for internal character representation.
    ;mbstring.language = Japanese
    
    ; internal/script encoding.
    ; Some encoding cannot work as internal encoding.
    ; (e.g. SJIS, BIG5, ISO-2022-*)
    ;mbstring.internal_encoding = EUC-JP
    
    ; http input encoding.
    ;mbstring.http_input = auto
    
    ; http output encoding. mb_output_handler must be
    ; registered as output buffer to function
    ;mbstring.http_output = SJIS
    
    ; enable automatic encoding translation accoding to 
    ; mbstring.internal_encoding setting. Input chars are
    ; converted to internal encoding by setting this to On.
    ; Note: Do _not_ use automatic encoding translation for
    ;       portable libs/applications.
    ;mbstring.encoding_translation = Off
    
    ; automatic encoding detection order.
    ; auto means 
    ;mbstring.detect_order = auto
    
    ; substitute_character used when character cannot be converted
    ; one from another
    ;mbstring.substitute_character = none;
    
    ; overload(replace) single byte functions by mbstring functions.
    ; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
    ; etc. Possible values are 0,1,2,4 or combination of them.
    ; For example, 7 for overload everything.
    ; 0: No overload
    ; 1: Overload mail() function
    ; 2: Overload str*() functions
    ; 4: Overload ereg*() functions
    ;mbstring.func_overload = 0
    
    [FrontBase]
    ;fbsql.allow_persistent = On
    ;fbsql.autocommit = On
    ;fbsql.default_database = 
    ;fbsql.default_database_password =
    ;fbsql.default_host =
    ;fbsql.default_password =
    ;fbsql.default_user = "_SYSTEM"
    ;fbsql.generate_warnings = Off
    ;fbsql.max_connections = 128
    ;fbsql.max_links = 128
    ;fbsql.max_persistent = -1
    ;fbsql.max_results = 128
    ;fbsql.batchSize = 1000
    
    [Crack]
    ; Modify the setting below to match the directory location of the cracklib
    ; dictionary files.  Include the base filename, but not the file extension.
    ; crack.default_dictionary = "c:\php\lib\cracklib_dict"
    
    [exif]
    ; Exif UNICODE user comments are handled as UCS-2BE/UCS-2LE and JIS as JIS. 
    ; With mbstring support this will automatically be converted into the encoding
    ; given by corresponding encode setting. When empty mbstring.internal_encoding 
    ; is used. For the decode settings you can distinguish between motorola and 
    ; intel byte order. A decode setting cannot be empty.
    ;exif.encode_unicode = ISO-8859-15
    ;exif.decode_unicode_motorola = UCS-2BE
    ;exif.decode_unicode_intel    = UCS-2LE
    ;exif.encode_jis = 
    ;exif.decode_jis_motorola = JIS
    ;exif.decode_jis_intel    = JIS
    
    ; Local Variables:
    ; tab-width: 4
    ; End:
    
    date.timezone="Europe/Helsinki"
    
    ;; this is an example, it won't work unless properly configured into php.ini
    [xcache-common]
    ;; non-Windows example:
    extension = xcache.so
    ;; Windows example:
    ; extension = php_xcache.dll
    
    [xcache.admin]
    xcache.admin.enable_auth = Off
    xcache.admin.user = "admin"
    ; set xcache.admin.pass = md5($your_password)
    ; login use $your_password
    xcache.admin.pass = "584c67af7f1284774b5fc6b91d598aa9"
    
    [xcache]
    ; ini only settings, all the values here is default unless explained
    
    ; select low level shm implemenation
    xcache.shm_scheme =        "mmap"
    ; to disable: xcache.size=0
    ; to enable : xcache.size=64M etc (any size > 0) and your system mmap allows
    xcache.size  =               128M
    ; set to cpu count (cat /proc/cpuinfo |grep -c processor)
    xcache.count =                 24
    ; just a hash hints, you can always store count(items) > slots
    xcache.slots =                8K
    ; ttl of the cache item, 0=forever
    xcache.ttl   =                 0
    ; interval of gc scanning expired items, 0=no scan, other values is in seconds
    xcache.gc_interval =           0
    
    ; same as aboves but for variable cache
    xcache.var_size  =            4M
    xcache.var_count =             1
    xcache.var_slots =            8K
    ; default value for $ttl parameter of xcache_*() functions
    xcache.var_ttl   =             0
    ; hard limit ttl that cannot be exceed by xcache_*() functions. 0=unlimited
    xcache.var_maxttl   =          0
    xcache.var_gc_interval =     300
    
    ; mode:0, const string specified by xcache.var_namespace
    ; mode:1, $_SERVER[xcache.var_namespace]
    ; mode:2, uid or gid (specified by xcache.var_namespace)
    xcache.var_namespace_mode =    0
    xcache.var_namespace =        ""
    
    ; N/A for /dev/zero
    xcache.readonly_protection = Off
    ; for *nix, xcache.mmap_path is a file path, not directory. (auto create/overwrite)
    ; Use something like "/tmp/xcache" instead of "/dev/*" if you want to turn on ReadonlyProtection
    ; different process group of php won't share the same /tmp/xcache
    ; for win32, xcache.mmap_path=anonymous map name, not file path
    xcache.mmap_path =    "/dev/zero"
    
    
    ; Useful when XCache crash. leave it blank(disabled) or "/tmp/phpcore/" (writable by php)
    xcache.coredump_directory =   ""
    ; Windows only. leave it as 0 (default) until you're told by XCache dev
    xcache.coredump_type =         0
    
    ; disable cache after crash
    xcache.disable_on_crash =    Off
    
    ; enable experimental documented features for each release if available
    xcache.experimental =        Off
    
    ; per request settings. can ini_set, .htaccess etc
    xcache.cacher =               On
    xcache.stat   =               On
    xcache.optimizer =           Off
    
    [xcache.coverager]
    ; enabling this feature will impact performance
    ; enabled only if xcache.coverager == On && xcache.coveragedump_directory == "non-empty-value"
    
    ; per request settings. can ini_set, .htaccess etc
    ; enable coverage data collecting and xcache_coverager_start/stop/get/clean() functions
    xcache.coverager =           Off
    xcache.coverager_autostart =  On
    
    ; set in php ini file only
    ; make sure it's readable (open_basedir is checked) by coverage viewer script
    xcache.coveragedump_directory = ""

    Top output while No high load

    Code:
    root@host [~]# top -c
    top - 03:27:35 up 2 days,  7:48,  1 user,  load average: 0.87, 0.96, 0.99
    Tasks:  52 total,   2 running,  50 sleeping,   0 stopped,   0 zombie
    Cpu(s):  1.6%us,  0.1%sy,  0.0%ni, 98.3%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
    Mem:   1572864k total,   381316k used,  1191548k free,        0k buffers
    Swap:        0k total,        0k used,        0k free,        0k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                                                           
    21882 Omlan     16   0  170m  30m  15m R 35.3  2.0   1:26.51 /usr/bin/php                                                                                                                      
    18051 mysql     18   3  255m  92m 5220 S  5.7  6.0   1211:41 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/host.mydomain.com.err --pid-file=/var/
    13892 root      15   0  2692 1228  888 R  0.3  0.1   0:03.50 top -c                                                                                                                            
    21869 nobody    17   0  8984 3140  836 S  0.3  0.2   0:04.11 nginx: worker process                                                                                                             
        1 root      15   0  2892 1352 1176 S  0.0  0.1   0:02.41 init                                                                                                                              
     1165 root      14  -4  2480  540  316 S  0.0  0.0   0:00.00 /sbin/udevd -d                                                                                                                    
     1546 root      18   0 36988 1720  952 S  0.0  0.1   0:01.00 /sbin/rsyslogd -i /var/run/syslogd.pid -c 5                                                                                       
     1559 named     21   0  342m  61m 2756 S  0.0  4.0   0:26.52 /usr/sbin/named -u named                                                                                                          
     1601 rpc       18   0  2568  644  460 S  0.0  0.0   0:00.47 rpcbind                                                                                                                           
     1636 root      18   0  8520 1000  520 S  0.0  0.1   0:00.01 /usr/sbin/sshd                                                                                                                    
     1643 root      18   0  3188  864  680 S  0.0  0.1   0:00.00 xinetd -stayalive -pidfile /var/run/xinetd.pid                                                                                    
     3223 mailnull  15   0 11168 1204  692 S  0.0  0.1   0:00.89 /usr/sbin/exim -bd -q60m                                                                                                          
     3251 root      18   0  2388  720  568 S  0.0  0.0   0:06.18 /usr/sbin/dovecot                                                                                                                 
     3252 root      15   0  3204 1116  896 S  0.0  0.1   0:03.21 dovecot-auth                                                                                                                      
     3276 root      18   0 13748 6092 4144 S  0.0  0.4   0:08.85 /usr/local/apache/bin/httpd -k start -DSSL                                                                                        
     3280 dovecot   18   0  6048 2168 1740 S  0.0  0.1   0:00.08 pop3-login                                                                                                                        
     3281 dovecot   18   0  6048 2164 1740 S  0.0  0.1   0:00.03 pop3-login                                                                                                                        
     3282 dovecot   18   0  6072 2172 1756 S  0.0  0.1   0:00.04 imap-login                                                                                                                        
     3283 dovecot   18   0  6072 2172 1756 S  0.0  0.1   0:00.13 imap-login                                                                                                                        
     3305 root      15   0  8636 1728 1296 S  0.0  0.1   0:00.17 pure-ftpd (SERVER)                                                                                                                
     3307 root      18   0  9460 1316 1008 S  0.0  0.1   0:00.04 /usr/sbin/pure-authd -s /var/run/ftpd.sock -r /usr/sbin/pureauth                                                                  
     3314 root      18   0  7104 1212  600 S  0.0  0.1   0:06.05 crond                                                                                                                             
     3323 root      15   0 10668 5272 1532 S  0.0  0.3   0:06.14 /usr/sbin/munin-node                                                                                                              
     3596 root      18   0 44972  38m 1424 S  0.0  2.5   0:09.61 lfd - sleeping                                                                                                                    
     3656 root      18   0  2912  532  388 S  0.0  0.0   0:00.00 /usr/sbin/atd                                                                                                                     
     3738 root      15   0  5616 3228 1248 S  0.0  0.2   0:00.67 queueprocd - wait to process a task                                                                                               
     3756 root      15   0  9564 5416 1696 S  0.0  0.3   0:10.45 tailwatchd                                                                                                                        
     3766 root      33  18  4812 1960  712 S  0.0  0.1   0:00.50 cpanellogd - sleeping for logs                                                                                                    
     3769 root      18   0 15740 7968 1504 S  0.0  0.5   0:05.20 cpsrvd (SSL) - waiting for connections                                                                                            
    11487 root      15   0 11580 3360 2632 S  0.0  0.2   0:00.74 sshd: root@pts/0                                                                                                                  
    11494 root      18   0  6392 1688 1396 S  0.0  0.1   0:00.01 -bash                                                                                                                             
    17692 root      15   0  7724 1880  920 S  0.0  0.1   0:00.05 nginx: master process /usr/local/sbin/nginx -c /etc/nginx/nginx.conf 


    Top output when the server go crazy! without any real high traffic at all !!!


    Code:
    root@host [~]# top -c
    top - 02:39:20 up 2 days,  6:59,  1 user,  load average: 3.12, 3.07, 2.64
    Tasks: 219 total,   2 running, 216 sleeping,   0 stopped,   1 zombie
    Cpu(s):  7.0%us,  3.6%sy,  0.0%ni, 89.4%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
    Mem:   1572864k total,   880804k used,   692060k free,        0k buffers
    Swap:        0k total,        0k used,        0k free,        0k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                                                           
    18051 mysql     21   3  255m  94m 5220 S 120.4  6.1   1190:42 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/host.mydomain.com.err --pid-file=/var
    12224 Omlan     15   0  161m  19m  13m S 33.5  1.3   0:08.42 /usr/bin/php                                                                                                                      
    13332 Omlan     15   0  165m  23m  12m S 17.2  1.5   0:06.42 /usr/bin/php                                                                                                                      
    13351 Omlan     17   0  164m  21m  12m S 17.2  1.4   0:04.53 /usr/bin/php                                                                                                                      
    13331 Omlan     17   0  161m  19m  12m S 12.9  1.3   0:07.78 /usr/bin/php                                                                                                                      
    13321 Omlan     15   0  164m  21m  12m S 10.9  1.4   0:01.14 /usr/bin/php                                                                                                                      
    12286 Omlan     17   0  164m  21m  12m S  9.3  1.4   0:05.51 /usr/bin/php                                                                                                                      
    12283 Omlan     15   0     0    0    0 Z  8.3  0.0   0:02.34 [php] <defunct>                                                                                                                   
    12251 Omlan     15   0  164m  21m  11m S  2.7  1.4   0:01.93 /usr/bin/php                                                                                                                      
    12273 Omlan     15   0  164m  21m  12m S  2.7  1.4   0:03.03 /usr/bin/php                                                                                                                      
    13360 Omlan     18   0 17036 7112 3092 R  1.0  0.5   0:00.03 /usr/local/cpanel/3rdparty/bin/php-cgi /usr/local/cpanel/base/3rdparty/phpMyAdmin/navigation.php                                  
    22159 nobody    15   0 48976  41m  836 S  1.0  2.7   1:22.09 nginx: worker process                                                                                                             
    22162 nobody    15   0 14020 2896  792 S  1.0  0.2   0:09.90 /usr/local/apache/bin/httpd -k start -DSSL                                                                                        
    13330 root      15   0  2692 1228  888 R  0.7  0.1   0:00.13 top -c                                                                                                                            
    13357 Omlan     17   0  159m  11m 7500 S  0.7  0.7   0:00.02 /usr/bin/php                                                                                                                      
    13358 Omlan     17   0  159m  11m 7500 S  0.7  0.7   0:00.02 /usr/bin/php                                                                                                                      
     5162 nobody    17   0 14156 4280 1960 S  0.3  0.3   0:00.39 /usr/local/apache/bin/httpd -k start -DSSL                                                                                        
     5213 nobody    16   0 14164 4288 1956 S  0.3  0.3   0:00.37 /usr/local/apache/bin/httpd -k start -DSSL                                                                                        
     5256 nobody    16   0 14160 4268 1944 S  0.3  0.3   0:00.29 /usr/local/apache/bin/httpd -k start -DSSL                                                                                        
     5285 nobody    16   0 14140 4352 1968 S  0.3  0.3   0:00.31 /usr/local/apache/bin/httpd -k start -DSSL                                                                                        
     5298 nobody    15   0 14148 4288 1956 S  0.3  0.3   0:00.26 /usr/local/apache/bin/httpd -k start -DSSL                                                                                        
     5303 nobody    16   0 14152 4296 1964 S  0.3  0.3   0:00.38 /usr/local/apache/bin/httpd -k start -DSSL                                                                                        
     5313 nobody    16   0 14156 4348 1956 S  0.3  0.3   0:00.35 /usr/local/apache/bin/httpd -k start -DSSL                                                                                        
    22158 nobody    15   0 50960  41m  836 S  0.3  2.7   1:18.08 nginx: worker process                                                                                                             
        1 root      18   0  2892 1352 1176 S  0.0  0.1   0:02.41 init                                                                                                                              
     1165 root      14  -4  2480  540  316 S  0.0  0.0   0:00.00 /sbin/udevd -d                                                                                                                    
     1546 root      18   0 36988 1716  952 S  0.0  0.1   0:01.00 /sbin/rsyslogd -i /var/run/syslogd.pid -c 5                                                                                       
     1559 named     21   0  342m  61m 2756 S  0.0  4.0   0:26.39 /usr/sbin/named -u named                                                                                                          
     1601 rpc       18   0  2568  644  460 S  0.0  0.0   0:00.47 rpcbind                                                                                                                           
     1636 root      18   0  8520 1000  520 S  0.0  0.1   0:00.01 /usr/sbin/sshd                                                                                                                    
     1643 root      18   0  3188  864  680 S  0.0  0.1   0:00.00 xinetd -stayalive -pidfile /var/run/xinetd.pid                                                                                    
     3223 mailnull  15   0 11168 1204  692 S  0.0  0.1   0:00.89 /usr/sbin/exim -bd -q60m 


    ./mysqltuner.pl output ( I didn't restart the mysql for more than 2 days )


    Code:
    root@host [~]# ./mysqltuner.pl
    
     >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Run with '--help' for additional options and output filtering
    
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.1.66-cll
    [OK] Operating on 32-bit architecture with less than 2GB RAM
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
    [--] Data in MyISAM tables: 305M (Tables: 152)
    [--] Data in InnoDB tables: 32K (Tables: 2)
    [!!] Total fragmented tables: 19
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 2d 6h 2m 17s (54M q [280.824 qps], 258K conn, TX: 156B, RX: 10B)
    [--] Reads / Writes: 95% / 5%
    [--] Total buffers: 106.0M global + 2.7M per thread (500 max threads)
    [!!] Maximum possible memory usage: 1.4G (94% of installed RAM)
    [OK] Slow queries: 0% (15K/54M)
    [OK] Highest usage of available connections: 15% (78/500)
    [OK] Key buffer size / total MyISAM indexes: 32.0M/223.9M
    [OK] Key buffer hit rate: 100.0% (2B cached / 95K reads)
    [OK] Query cache efficiency: 93.7% (50M cached / 53M selects)
    [!!] Query cache prunes per day: 30906
    [OK] Sorts requiring temporary tables: 0% (5 temp sorts / 1M sorts)
    [!!] Joins performed without indexes: 1494254
    [!!] Temporary tables created on disk: 35% (1M on disk / 2M total)
    [OK] Thread cache hit rate: 99% (78 created / 258K connections)
    [!!] Table cache hit rate: 7% (200 open / 2K opened)
    [OK] Open file limit used: 14% (355/2K)
    [OK] Table locks acquired immediately: 99% (8M immediate / 8M locks)
    [OK] InnoDB data size / buffer pool: 32.0K/8.0M
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        Reduce your overall MySQL memory footprint for system stability
        Adjust your join queries to always utilize indexes
        When making adjustments, make tmp_table_size/max_heap_table_size equal
        Reduce your SELECT DISTINCT queries without LIMIT clauses
        Increase table_cache gradually to avoid file descriptor limits
    Variables to adjust:
      *** MySQL's maximum memory usage is dangerously high ***
      *** Add RAM before increasing MySQL buffer variables ***
        query_cache_size (> 32M)
        join_buffer_size (> 128.0K, or always use indexes with joins)
        tmp_table_size (> 32M)
        max_heap_table_size (> 32M)
        table_cache (> 512)
    

    Tuning-primer.sh output

    Code:
    root@host [~]# ./tuning-primer.sh
     
            -- MYSQL PERFORMANCE TUNING PRIMER --
                 - By: Matthew Montgomery -
    
    MySQL Version 5.1.66-cll i686
    
    Uptime = 2 days 6 hrs 17 min 39 sec
    Avg. qps = 280
    Total Questions = 54904741
    Threads Connected = 2
    
    Server has been running for over 48hrs.
    It should be safe to follow these recommendations
    
    To find out more information on how each of these
    runtime variables effects performance visit:
    http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html
    Visit http://www.mysql.com/products/enterprise/advisors.html
    for info about MySQL's Enterprise Monitoring and Advisory Service
    
    SLOW QUERIES
    The slow query log is enabled.
    Current long_query_time = 1.000000 sec.
    You have 15338 out of 54904805 that take longer than 1.000000 sec. to complete
    Your long_query_time seems to be fine
    
    BINARY UPDATE LOG
    The binary update log is NOT enabled.
    You will not be able to do point in time recovery
    See http://dev.mysql.com/doc/refman/5.1/en/point-in-time-recovery.html
    
    WORKER THREADS
    Current thread_cache_size = 16384
    Current threads_cached = 77
    Current threads_per_sec = 0
    Historic threads_per_sec = 0
    Your thread_cache_size is fine
    
    MAX CONNECTIONS
    Current max_connections = 500
    Current threads_connected = 1
    Historic max_used_connections = 78
    The number of used connections is 15% of the configured maximum.
    Your max_connections variable seems to be fine.
    
    INNODB STATUS
    Current InnoDB index space = 16 K
    Current InnoDB data space = 32 K
    Current InnoDB buffer pool free = 95 %
    Current innodb_buffer_pool_size = 8 M
    Depending on how much space your innodb indexes take up it may be safe
    to increase this value to up to 2 / 3 of total system memory
    
    MEMORY USAGE
    Max Memory Ever Allocated : 283 M
    Configured Max Per-thread Buffers : 1.31 G
    Configured Max Global Buffers : 74 M
    Configured Max Memory Limit : 1.38 G
    Physical Memory : 1.50 G
    
    Max memory limit exceeds 90% of physical memory
    
    KEY BUFFER
    Current MyISAM index space = 223 M
    Current key_buffer_size = 32 M
    Key cache miss rate is 1 : 26653
    Key buffer free ratio = 77 %
    Your key_buffer_size seems to be too high.
    Perhaps you can use these resources elsewhere
    
    QUERY CACHE
    Query cache is enabled
    Current query_cache_size = 32 M
    Current query_cache_used = 16 M
    Current query_cache_limit = 4 M
    Current Query cache Memory fill ratio = 50.40 %
    Current query_cache_min_res_unit = 4 K
    MySQL won't cache query results that are larger than query_cache_limit in size
    
    SORT OPERATIONS
    Current sort_buffer_size = 2 M
    Current read_rnd_buffer_size = 256 K
    Sort buffer seems to be fine
    
    JOINS
    Current join_buffer_size = 132.00 K
    You have had 1501885 queries where a join could not use an index properly
    You should enable "log-queries-not-using-indexes"
    Then look for non indexed joins in the slow query log.
    If you are unable to optimize your queries you may want to increase your
    join_buffer_size to accommodate larger joins in one pass.
    
    Note! This script will still suggest raising the join_buffer_size when
    ANY joins not using indexes are found.
    
    OPEN FILES LIMIT
    Current open_files_limit = 2500 files
    The open_files_limit should typically be set to at least 2x-3x
    that of table_cache if you have heavy MyISAM usage.
    Your open_files_limit value seems to be fine
    
    TABLE CACHE
    Current table_open_cache = 512 tables
    Current table_definition_cache = 512 tables
    You have a total of 185 tables
    You have 220 open tables.
    The table_cache value seems to be fine
    
    TEMP TABLES
    Current max_heap_table_size = 32 M
    Current tmp_table_size = 32 M
    Of 1899028 temp tables, 35% were created on disk
    Perhaps you should increase your tmp_table_size and/or max_heap_table_size
    to reduce the number of disk-based temporary tables
    Note! BLOB and TEXT columns are not allow in memory tables.
    If you are using these columns raising these values might not impact your 
    ratio of on disk temp tables.
    
    TABLE SCANS
    Current read_buffer_size = 128 K
    Current table scan ratio = 487 : 1
    read_buffer_size seems to be fine
    
    TABLE LOCKING
    Current Lock Wait ratio = 1 : 172
    You may benefit from selective use of InnoDB.
    If you have long running SELECT's against MyISAM tables and perform
    frequent updates consider setting 'low_priority_updates=1'
    If you have a high concurrency of inserts on Dynamic row-length tables
    consider setting 'concurrent_insert=2'.
    

    mpstat -P ALL 5 5 output

    Code:
    root@host [~]# mpstat -P ALL 5 5
    Linux 2.6.18-028stab099.3 (host.mydomain.com)     02/14/2013      _i686_  (24 CPU)
    
    03:49:28 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    03:49:33 AM  all    3.49    0.00    0.30    0.00    0.00    0.00    0.00    0.00   96.21
    03:49:33 AM    0    2.21    0.00    1.20    0.00    0.00    0.00    0.00    0.00   96.59
    03:49:33 AM    1    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM    2    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM    3    0.20    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.80
    03:49:33 AM    4    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM    5    1.60    0.00    0.80    0.00    0.00    0.00    0.00    0.00   97.60
    03:49:33 AM    6    1.80    0.00    0.60    0.00    0.00    0.00    0.00    0.00   97.60
    03:49:33 AM    7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM    8    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM    9    8.60    0.00    0.40    0.00    0.00    0.00    0.00    0.00   91.00
    03:49:33 AM   10   16.60    0.00    0.60    0.00    0.00    0.00    0.00    0.00   82.80
    03:49:33 AM   11    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM   12   31.79    0.00    1.01    0.00    0.00    0.00    0.00    0.00   67.20
    03:49:33 AM   13    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM   14    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM   15    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM   16    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM   17    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM   18    3.40    0.00    0.80    0.00    0.00    0.00    0.00    0.00   95.80
    03:49:33 AM   19    2.00    0.00    1.00    0.00    0.00    0.00    0.00    0.00   97.00
    03:49:33 AM   20    0.80    0.00    0.60    0.00    0.00    0.00    0.00    0.00   98.60
    03:49:33 AM   21    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:33 AM   22   14.20    0.00    0.40    0.00    0.00    0.00    0.00    0.00   85.40
    03:49:33 AM   23    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    03:49:33 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    03:49:38 AM  all    4.06    0.00    1.26    0.01    0.00    0.00    0.00    0.00   94.68
    03:49:38 AM    0    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:38 AM    1    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:38 AM    2    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:38 AM    3    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:38 AM    4    2.20    0.00    0.60    0.00    0.00    0.00    0.00    0.00   97.20
    03:49:38 AM    5    0.20    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.80
    03:49:38 AM    6    2.80    0.00    1.00    0.00    0.00    0.00    0.00    0.00   96.20
    03:49:38 AM    7   10.00    0.00   18.60    0.00    0.00    0.00    0.00    0.00   71.40
    03:49:38 AM    8    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:38 AM    9   23.94    0.00    1.22    0.00    0.00    0.00    0.00    0.00   74.85
    03:49:38 AM   10   24.70    0.00    1.00    0.00    0.00    0.00    0.00    0.00   74.30
    03:49:38 AM   11    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:38 AM   12   16.43    0.00    0.40    0.00    0.00    0.00    0.00    0.00   83.17
    03:49:38 AM   13    1.82    0.00    0.81    0.00    0.00    0.00    0.00    0.00   97.37
    03:49:38 AM   14    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:38 AM   15    2.62    0.00    0.80    0.20    0.00    0.00    0.00    0.00   96.38
    03:49:38 AM   16    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:38 AM   17    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:38 AM   18    1.00    0.00    0.20    0.00    0.00    0.00    0.00    0.00   98.80
    03:49:38 AM   19    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:38 AM   20    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:38 AM   21    5.70    0.00    2.44    0.00    0.00    0.00    0.00    0.00   91.85
    03:49:38 AM   22    0.20    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.80
    03:49:38 AM   23    6.04    0.00    2.62    0.00    0.00    0.00    0.00    0.00   91.35
    
    03:49:38 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    03:49:43 AM  all    2.98    0.00    1.10    0.00    0.00    0.00    0.00    0.00   95.92
    03:49:43 AM    0   11.20    0.00   18.00    0.00    0.00    0.00    0.00    0.00   70.80
    03:49:43 AM    1    0.40    0.00    0.20    0.00    0.00    0.00    0.00    0.00   99.40
    03:49:43 AM    2    1.60    0.00    1.20    0.00    0.00    0.00    0.00    0.00   97.20
    03:49:43 AM    3   10.24    0.00    1.61    0.00    0.00    0.00    0.00    0.00   88.15
    03:49:43 AM    4    0.40    0.00    0.80    0.00    0.00    0.00    0.00    0.00   98.80
    03:49:43 AM    5    0.00    0.00    0.20    0.00    0.00    0.00    0.00    0.00   99.80
    03:49:43 AM    6    0.80    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.20
    03:49:43 AM    7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:43 AM    8    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:43 AM    9   30.46    0.00    0.80    0.00    0.00    0.00    0.00    0.00   68.74
    03:49:43 AM   10    9.22    0.00    0.40    0.00    0.00    0.00    0.00    0.00   90.38
    03:49:43 AM   11    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:43 AM   12    2.60    0.00    0.20    0.00    0.00    0.00    0.00    0.00   97.20
    03:49:43 AM   13    4.66    0.00    2.23    0.00    0.00    0.00    0.00    0.00   93.12
    03:49:43 AM   14    0.00    0.00    0.40    0.00    0.00    0.00    0.00    0.00   99.60
    03:49:43 AM   15    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:43 AM   16    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:43 AM   17    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:43 AM   18    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:43 AM   19    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:43 AM   20    0.20    0.00    0.20    0.00    0.00    0.00    0.00    0.00   99.60
    03:49:43 AM   21    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:43 AM   22    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:43 AM   23    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    03:49:43 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    03:49:48 AM  all    2.83    0.00    0.48    0.00    0.00    0.00    0.00    0.00   96.69
    03:49:48 AM    0    3.81    0.00    6.41    0.00    0.00    0.00    0.00    0.00   89.78
    03:49:48 AM    1    0.80    0.00    0.40    0.00    0.00    0.00    0.00    0.00   98.80
    03:49:48 AM    2    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM    3    1.81    0.00    0.60    0.00    0.00    0.00    0.00    0.00   97.58
    03:49:48 AM    4    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM    5    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM    6    3.40    0.00    1.20    0.00    0.00    0.00    0.00    0.00   95.40
    03:49:48 AM    7    2.22    0.00    1.01    0.00    0.00    0.00    0.00    0.00   96.77
    03:49:48 AM    8    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM    9   16.06    0.00    0.60    0.00    0.00    0.00    0.00    0.00   83.33
    03:49:48 AM   10    2.81    0.00    0.20    0.00    0.00    0.00    0.00    0.00   96.99
    03:49:48 AM   11    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM   12   35.96    0.00    1.41    0.00    0.00    0.00    0.00    0.00   62.63
    03:49:48 AM   13    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM   14    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM   15    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM   16    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM   17    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM   18    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM   19    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM   20    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM   21    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:48 AM   22    1.00    0.00    0.40    0.00    0.00    0.00    0.00    0.00   98.60
    03:49:48 AM   23    0.20    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.80
    
    03:49:48 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    03:49:53 AM  all    3.41    0.00    2.13    0.05    0.00    0.00    0.00    0.00   94.41
    03:49:53 AM    0    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM    1   12.02    0.00   22.24    0.60    0.00    0.00    0.00    0.00   65.13
    03:49:53 AM    2    1.60    0.00    0.80    0.00    0.00    0.00    0.00    0.00   97.60
    03:49:53 AM    3    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM    4    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM    5    0.20    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.80
    03:49:53 AM    6    1.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.00
    03:49:53 AM    7    1.20    0.00    0.00    0.00    0.00    0.00    0.00    0.00   98.80
    03:49:53 AM    8    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM    9   16.83    0.00    0.80    0.00    0.00    0.00    0.00    0.00   82.36
    03:49:53 AM   10    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM   11    2.42    0.00    1.01    0.00    0.00    0.00    0.00    0.00   96.57
    03:49:53 AM   12   27.88    0.00    1.01    0.00    0.00    0.00    0.00    0.00   71.11
    03:49:53 AM   13    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM   14   15.43    0.00   23.05    0.80    0.00    0.00    0.00    0.00   60.72
    03:49:53 AM   15    2.40    0.00    1.20    0.00    0.00    0.00    0.00    0.00   96.41
    03:49:53 AM   16    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM   17    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM   18    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM   19    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM   20    1.40    0.00    1.00    0.00    0.00    0.00    0.00    0.00   97.60
    03:49:53 AM   21    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM   22    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    03:49:53 AM   23    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    Average:     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    Average:     all    3.35    0.00    1.06    0.01    0.00    0.00    0.00    0.00   95.58
    Average:       0    3.44    0.00    5.12    0.00    0.00    0.00    0.00    0.00   91.43
    Average:       1    2.64    0.00    4.56    0.12    0.00    0.00    0.00    0.00   92.68
    Average:       2    0.64    0.00    0.40    0.00    0.00    0.00    0.00    0.00   98.96
    Average:       3    2.44    0.00    0.44    0.00    0.00    0.00    0.00    0.00   97.12
    Average:       4    0.54    0.00    0.29    0.00    0.00    0.00    0.00    0.00   99.17
    Average:       5    0.40    0.00    0.20    0.00    0.00    0.00    0.00    0.00   99.40
    Average:       6    1.96    0.00    0.56    0.00    0.00    0.00    0.00    0.00   97.48
    Average:       7    2.68    0.00    3.92    0.00    0.00    0.00    0.00    0.00   93.39
    Average:       8    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    Average:       9   19.16    0.00    0.76    0.00    0.00    0.00    0.00    0.00   80.07
    Average:      10   10.65    0.00    0.44    0.00    0.00    0.00    0.00    0.00   88.91
    Average:      11    0.48    0.00    0.20    0.00    0.00    0.00    0.00    0.00   99.32
    Average:      12   22.89    0.00    0.80    0.00    0.00    0.00    0.00    0.00   76.31
    Average:      13    1.28    0.00    0.60    0.00    0.00    0.00    0.00    0.00   98.11
    Average:      14    3.08    0.00    4.68    0.16    0.00    0.00    0.00    0.00   92.09
    Average:      15    1.00    0.00    0.40    0.04    0.00    0.00    0.00    0.00   98.56
    Average:      16    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    Average:      17    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    Average:      18    0.88    0.00    0.20    0.00    0.00    0.00    0.00    0.00   98.92
    Average:      19    0.40    0.00    0.20    0.00    0.00    0.00    0.00    0.00   99.40
    Average:      20    0.48    0.00    0.36    0.00    0.00    0.00    0.00    0.00   99.16
    Average:      21    1.12    0.00    0.48    0.00    0.00    0.00    0.00    0.00   98.40
    Average:      22    3.08    0.00    0.16    0.00    0.00    0.00    0.00    0.00   96.76
    Average:      23    1.24    0.00    0.52    0.00    0.00    0.00    0.00    0.00   98.24
    

    My database storage engine is MyISAM and I'm running a cron job once a day to optimize the database at 3am.

    I'm seeing ridiculous load averages, and there's only 5-10 members on the site, so this is quite odd, considering I've read posts of others with similar setups having 20 -30 people on their site at any given time, and not seeing loads in these amounts. I'm running only a Classified Ad script from flynax[dot]com and according to Google Analytics I get about 1000 visitor each day.

    If anyone is a server guru that can offer some support, it would be greatly appreciated. Thanks!
     
  2. mamdeen78

    mamdeen78 Registered

    Joined:
    Feb 13, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    And this is the output of the mysqlmymonlite.sh script I found here in the forums. As you can see the load average was : 19.67 !!!! and it's 5:30 AM here with absolutely NO Real traffic on the server !!

    Code:
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.4.6 WHM mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Thu Feb 14 05:28:05 EET 2013
    
    ----------------------------
    MySQL Uptime:
    ----------------------------
    MySQL server was started 
    Uptime: 2 days 7 hours 59 min 29 sec
    Uptime 201569
    Uptime_since_flush_status 201569
    
    Max Used Connections:      78/500 (15.60%)
    Key Buffer Used:           12.30M/32.00M (38.44%)
    Current Key Buffer Usage:  7.92M (24.76%)
    InnoDB Buffer Pool:        368.00k/8.00M (4.49%)
    Query Cache:               18.44M/32.00M (57.63%)
    Table Locks Waited:        51.79k Rate: 0.3/s (0.57%)
    --------------------
    Query Cache Limit (bytes): 4194304
    Query Cache Min Unit (bytes): 4096
    Query Cache Size (bytes): 33554432
    Query Cache Free Mem (bytes): 14216576
    Query Cache Used Mem (bytes): 19337856
    Queries in Query Cache: 1
    Query Cache Avg Size (bytes): 19337856
    
    ----------------------------
    Hardware Info:
    ----------------------------
    Processors physical = 2, cores = 12, virtual = 24, hyperthreading = yes
         24  2400.063
         24  Intel(R) Xeon(R) CPU           E5645  @ 2.40GHz
         24  12288 KB
    
    
    ----------------------------
    TOP stats
    ----------------------------
    
    Linux 2.6.18-028stab099.3 ((yourserverhostname)) 	02/14/2013 	_i686_	(24 CPU)
    
    05:28:05 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    05:28:07 AM  all    0.64    0.00    2.07   89.41    0.00    0.00    0.00    0.00    7.88
    05:28:07 AM    0    0.00    0.00    0.00  100.00    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM    1    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    05:28:07 AM    2    1.00    0.00    3.50   95.50    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM    3    0.00    0.00    0.50    0.00    0.00    0.00    0.00    0.00   99.50
    05:28:07 AM    4    0.00    0.00    0.50   99.50    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM    5    0.00    0.00    0.50   99.50    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM    6    0.00    0.00    0.00  100.00    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM    7    1.00    0.00    2.00   97.00    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM    8    1.01    0.00    4.02   94.97    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM    9    1.01    0.00    4.52   94.47    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   10    0.50    0.00    1.00   98.51    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   11    0.50    0.00    1.00   98.51    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   12    2.49    0.00   12.94   84.58    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   13    0.50    0.00    1.00   98.50    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   14    1.99    0.00    4.98   93.03    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   15    0.50    0.00    1.49   98.02    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   16    1.50    0.00    3.00   95.50    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   17    0.50    0.00    1.49   98.01    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   18    0.00    0.00    0.00  100.00    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   19    0.00    0.00    1.50   98.50    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   20    0.00    0.00    0.00  100.00    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   21    0.50    0.00    2.00   97.50    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   22    0.50    0.00    0.50   99.00    0.00    0.00    0.00    0.00    0.00
    05:28:07 AM   23    0.50    0.00    2.00   97.50    0.00    0.00    0.00    0.00    0.00
    
    05:28:07 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    05:28:09 AM  all    0.58    0.00    3.93   89.24    0.00    0.00    0.00    0.00    6.24
    05:28:09 AM    0    0.00    0.00    0.50   99.50    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM    1    0.00    0.00    0.50   50.00    0.00    0.00    0.00    0.00   49.50
    05:28:09 AM    2    0.50    0.00    1.00   98.50    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM    3    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    05:28:09 AM    4    0.50    0.00    8.00   91.50    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM    5    0.50    0.00    7.54   91.96    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM    6    0.50    0.00    1.49   98.01    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM    7    0.50    0.00    8.00   91.50    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM    8    0.50    0.00    1.49   98.01    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM    9    0.50    0.00    1.00   98.51    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   10    1.00    0.00    9.50   89.50    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   11    1.50    0.00    3.50   95.00    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   12    0.50    0.00    1.00   98.50    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   13    1.00    0.00    7.96   91.04    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   14    0.50    0.00    1.00   98.50    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   15    1.01    0.00    7.54   91.46    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   16    0.50    0.00    1.49   98.01    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   17    1.00    0.00    2.50   96.50    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   18    0.50    0.00    1.50   98.00    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   19    1.01    0.00    8.04   90.95    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   20    0.00    0.00    0.50   99.50    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   21    0.99    0.00    8.42   90.59    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   22    1.00    0.00    7.50   91.50    0.00    0.00    0.00    0.00    0.00
    05:28:09 AM   23    1.00    0.00    4.98   94.03    0.00    0.00    0.00    0.00    0.00
    
    Average:     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    Average:     all    0.61    0.00    3.01   89.33    0.00    0.00    0.00    0.00    7.05
    Average:       0    0.00    0.00    0.32   99.68    0.00    0.00    0.00    0.00    0.00
    Average:       1    0.00    0.00    0.27   26.95    0.00    0.00    0.00    0.00   72.78
    Average:       2    0.75    0.00    2.25   97.00    0.00    0.00    0.00    0.00    0.00
    Average:       3    0.00    0.00    0.25    0.00    0.00    0.00    0.00    0.00   99.75
    Average:       4    0.25    0.00    4.24   95.51    0.00    0.00    0.00    0.00    0.00
    Average:       5    0.25    0.00    4.00   95.75    0.00    0.00    0.00    0.00    0.00
    Average:       6    0.25    0.00    0.75   99.00    0.00    0.00    0.00    0.00    0.00
    Average:       7    0.75    0.00    5.00   94.25    0.00    0.00    0.00    0.00    0.00
    Average:       8    0.75    0.00    2.75   96.50    0.00    0.00    0.00    0.00    0.00
    Average:       9    0.75    0.00    2.75   96.50    0.00    0.00    0.00    0.00    0.00
    Average:      10    0.75    0.00    5.24   94.01    0.00    0.00    0.00    0.00    0.00
    Average:      11    1.00    0.00    2.24   96.76    0.00    0.00    0.00    0.00    0.00
    Average:      12    1.50    0.00    6.98   91.52    0.00    0.00    0.00    0.00    0.00
    Average:      13    0.75    0.00    4.49   94.76    0.00    0.00    0.00    0.00    0.00
    Average:      14    1.25    0.00    2.99   95.76    0.00    0.00    0.00    0.00    0.00
    Average:      15    0.75    0.00    4.49   94.76    0.00    0.00    0.00    0.00    0.00
    Average:      16    1.00    0.00    2.24   96.76    0.00    0.00    0.00    0.00    0.00
    Average:      17    0.75    0.00    2.00   97.26    0.00    0.00    0.00    0.00    0.00
    Average:      18    0.25    0.00    0.75   99.00    0.00    0.00    0.00    0.00    0.00
    Average:      19    0.50    0.00    4.76   94.74    0.00    0.00    0.00    0.00    0.00
    Average:      20    0.00    0.00    0.25   99.75    0.00    0.00    0.00    0.00    0.00
    Average:      21    0.75    0.00    5.22   94.03    0.00    0.00    0.00    0.00    0.00
    Average:      22    0.75    0.00    4.00   95.25    0.00    0.00    0.00    0.00    0.00
    Average:      23    0.75    0.00    3.49   95.76    0.00    0.00    0.00    0.00    0.00
    
    top - 05:28:09 up 2 days,  9:48,  1 user,  load average: 19.67, 7.41, 3.30
    Tasks: 128 total,   1 running, 125 sleeping,   0 stopped,   2 zombie
    Cpu(s):  2.9%us,  1.1%sy,  0.1%ni, 95.7%id,  0.2%wa,  0.0%hi,  0.0%si,  0.0%st
    Mem:   1572864k total,   551932k used,  1020932k free,        0k buffers
    Swap:        0k total,        0k used,        0k free,        0k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND            
    18051 mysql     19   3  270m 116m 5220 S 67.4  7.6   1265:25 mysqld             
        1 root      15   0  2892 1352 1176 S  0.0  0.1   0:02.42 init               
     1165 root      14  -4  2480  540  316 S  0.0  0.0   0:00.00 udevd              
     1546 root      18   0 36988 1732  952 S  0.0  0.1   0:01.03 rsyslogd           
     1559 named     21   0  342m  61m 2756 S  0.0  4.0   0:27.23 named              
     1601 rpc       15   0  2568  644  460 S  0.0  0.0   0:00.49 rpcbind            
     1636 root      18   0  8520 1000  520 S  0.0  0.1   0:00.01 sshd               
     1643 root      18   0  3188  864  680 S  0.0  0.1   0:00.00 xinetd             
     3223 mailnull  15   0 11168 1204  692 S  0.0  0.1   0:00.91 exim               
     3251 root      15   0  2388  720  568 S  0.0  0.0   0:06.41 dovecot            
     3252 root      15   0  3204 1116  896 S  0.0  0.1   0:03.33 dovecot-auth       
     3276 root      15   0 13748 6092 4144 S  0.0  0.4   0:09.18 httpd              
     3280 dovecot   15   0  6048 2168 1740 S  0.0  0.1   0:00.09 pop3-login         
     3281 dovecot   18   0  6048 2164 1740 S  0.0  0.1   0:00.03 pop3-login         
     3282 dovecot   16   0  6072 2368 1900 S  0.0  0.2   0:00.04 imap-login         
     3283 dovecot   18   0  6072 2172 1756 S  0.0  0.1   0:00.14 imap-login         
     3305 root      15   0  8636 1728 1296 S  0.0  0.1   0:00.19 pure-ftpd          
     3307 root      18   0  9460 1316 1008 S  0.0  0.1   0:00.04 pure-authd         
     3314 root      17   0  7104 1212  600 S  0.0  0.1   0:06.27 crond              
     3323 root      15   0 10668 5272 1532 S  0.0  0.3   0:06.39 munin-node         
     3596 root      18   0 44972  38m 1424 S  0.0  2.5   0:13.23 lfd                
     3656 root      18   0  2912  532  388 S  0.0  0.0   0:00.00 atd                
     3738 root      15   0  5616 3228 1248 S  0.0  0.2   0:00.69 queueprocd         
     3756 root      15   0  9564 5416 1696 S  0.0  0.3   0:10.89 tailwatchd         
     3766 root      33  18  4812 1960  712 S  0.0  0.1   0:00.53 cpanellogd         
     3769 root      18   0 15740 7968 1504 S  0.0  0.5   0:05.45 cpsrvd-ssl         
    17692 root      15   0  7484 1872  920 S  0.0  0.1   0:00.05 nginx              
    17957 root      18   0  3036 1292 1104 S  0.0  0.1   0:00.00 mysqld_safe        
    20472 nobody    18   0 14804 4140  836 S  0.0  0.3   0:04.44 nginx              
    20473 nobody    15   0 13684 3576  836 S  0.0  0.2   0:04.53 nginx              
    20475 root      17   0  9756 6116 2232 S  0.0  0.4   0:00.08 leechprotect       
    20476 nobody    15   0 14156 2972  808 S  0.0  0.2   0:00.09 httpd              
    20477 nobody    16   0 14156 4340 1964 S  0.0  0.3   0:00.28 httpd              
    20479 nobody    16   0 14152 4360 1976 S  0.0  0.3   0:00.28 httpd              
    21504 nobody    15   0 14284 5260 2836 S  0.0  0.3   0:00.29 httpd              
    21601 root      15   0 11436 3348 2632 S  0.0  0.2   0:00.10 sshd               
    22091 root      15   0  6392 1700 1404 S  0.0  0.1   0:00.02 bash               
    26038 nobody    18   0 14156 4324 1952 S  0.0  0.3   0:00.04 httpd              
    26047 nobody    15   0 14160 4356 1972 S  0.0  0.3   0:00.03 httpd              
    26049 nobody    16   0 14160 4360 1972 S  0.0  0.3   0:00.03 httpd              
    26054 nobody    16   0 14156 4340 1968 S  0.0  0.3   0:00.02 httpd              
    26055 nobody    15   0 14160 4352 1968 S  0.0  0.3   0:00.01 httpd              
    26068 nobody    18   0 14156 4328 1952 S  0.0  0.3   0:00.01 httpd              
    26077 nobody    15   0 14160 4344 1968 S  0.0  0.3   0:00.01 httpd              
    26138 nobody    16   0 14020 4048 1880 S  0.0  0.3   0:00.00 httpd              
    26139 nobody    18   0 14020 4124 1936 S  0.0  0.3   0:00.00 httpd              
    26140 nobody    16   0 14020 4124 1936 S  0.0  0.3   0:00.00 httpd              
    26141 nobody    16   0 14020 4164 1964 S  0.0  0.3   0:00.02 httpd              
    26142 nobody    16   0 14020 4056 1888 S  0.0  0.3   0:00.00 httpd              
    26143 nobody    16   0 14020 4052 1888 S  0.0  0.3   0:00.00 httpd              
    26144 nobody    16   0 14020 4120 1932 S  0.0  0.3   0:00.00 httpd              
    26145 nobody    16   0 14020 4136 1948 S  0.0  0.3   0:00.00 httpd              
    26146 nobody    18   0 14020 4124 1940 S  0.0  0.3   0:00.00 httpd              
    26147 nobody    18   0 14020 4128 1936 S  0.0  0.3   0:00.00 httpd              
    26148 nobody    16   0 14020 4136 1948 S  0.0  0.3   0:00.01 httpd              
    26149 nobody    16   0 14020 4124 1936 S  0.0  0.3   0:00.00 httpd              
    26150 nobody    18   0 14020 4136 1944 S  0.0  0.3   0:00.00 httpd              
    26151 nobody    16   0 14020 4136 1948 S  0.0  0.3   0:00.01 httpd              
    26152 nobody    18   0 14020 4132 1944 S  0.0  0.3   0:00.00 httpd              
    26154 nobody    16   0 14016 4140 1948 S  0.0  0.3   0:00.01 httpd              
    26155 nobody    18   0 14020 4128 1944 S  0.0  0.3   0:00.00 httpd              
    26156 nobody    16   0 14016 4172 1968 S  0.0  0.3   0:00.01 httpd              
    26157 nobody    16   0 14020 4132 1948 S  0.0  0.3   0:00.00 httpd              
    26158 nobody    15   0 14016 4136 1944 S  0.0  0.3   0:00.00 httpd              
    26160 nobody    16   0 14016 4140 1948 S  0.0  0.3   0:00.01 httpd              
    26161 nobody    16   0 14016 4172 1968 S  0.0  0.3   0:00.01 httpd              
    26162 nobody    16   0 14016 4116 1928 S  0.0  0.3   0:00.00 httpd              
    26164 nobody    16   0 14016 4132 1948 S  0.0  0.3   0:00.00 httpd              
    26165 nobody    18   0 14016 4140 1952 S  0.0  0.3   0:00.00 httpd              
    26166 nobody    16   0 14016 4132 1948 S  0.0  0.3   0:00.00 httpd              
    26167 nobody    16   0 14016 4136 1948 S  0.0  0.3   0:00.00 httpd              
    26168 nobody    16   0 14016 4136 1948 S  0.0  0.3   0:00.00 httpd              
    26179 nobody    16   0 14020 4060 1892 S  0.0  0.3   0:00.00 httpd              
    26181 nobody    16   0 14020 4136 1948 S  0.0  0.3   0:00.01 httpd              
    26182 nobody    16   0 14020 4064 1896 S  0.0  0.3   0:00.00 httpd              
    26184 nobody    17   0 14020 4064 1896 S  0.0  0.3   0:00.00 httpd              
    26186 nobody    17   0 14020 4140 1956 S  0.0  0.3   0:00.00 httpd              
    26187 nobody    16   0 14020 4076 1900 S  0.0  0.3   0:00.00 httpd              
    26189 nobody    16   0 14016 4124 1940 S  0.0  0.3   0:00.00 httpd              
    26190 nobody    16   0 14016 4140 1948 S  0.0  0.3   0:00.00 httpd              
    26192 nobody    16   0 14016 4172 1968 S  0.0  0.3   0:00.01 httpd              
    26193 nobody    16   0 14016 4140 1948 S  0.0  0.3   0:00.00 httpd              
    26194 nobody    16   0 14016 4112 1936 S  0.0  0.3   0:00.01 httpd              
    26196 nobody    16   0 14016 4140 1948 S  0.0  0.3   0:00.00 httpd              
    26211 nobody    16   0 14016 4120 1944 S  0.0  0.3   0:00.00 httpd              
    26212 nobody    16   0 14016 4100 1908 S  0.0  0.3   0:00.02 httpd              
    26213 nobody    16   0 14016 4120 1944 S  0.0  0.3   0:00.00 httpd              
    26230 nobody    20   0 14020 4092 1912 S  0.0  0.3   0:00.00 httpd              
    26231 nobody    16   0 14020 4028 1864 S  0.0  0.3   0:00.00 httpd              
    26240 nobody    16   0 14020 4072 1900 S  0.0  0.3   0:00.00 httpd              
    26243 nobody    18   0 14020 4100 1928 S  0.0  0.3   0:00.00 httpd              
    26244 nobody    16   0 14020 4108 1936 S  0.0  0.3   0:00.00 httpd              
    26245 nobody    16   0 14020 4080 1900 S  0.0  0.3   0:00.00 httpd              
    26247 nobody    16   0 14020 4064 1896 S  0.0  0.3   0:00.00 httpd              
    26249 nobody    16   0 14020 4072 1900 S  0.0  0.3   0:00.00 httpd              
    26252 nobody    16   0 14020 4060 1896 S  0.0  0.3   0:00.00 httpd              
    26253 nobody    16   0 14020 4060 1896 S  0.0  0.3   0:00.00 httpd              
    26254 nobody    16   0 14020 4068 1900 S  0.0  0.3   0:00.00 httpd              
    26255 nobody    16   0 14016 4116 1940 S  0.0  0.3   0:00.00 httpd              
    26256 nobody    15   0 14016 4096 1924 S  0.0  0.3   0:00.00 httpd              
    26257 nobody    15   0 14016 4096 1928 S  0.0  0.3   0:00.00 httpd              
    26258 nobody    16   0 14016 4104 1936 S  0.0  0.3   0:00.00 httpd              
    26267 nobody    16   0 14016 4132 1944 S  0.0  0.3   0:00.00 httpd              
    26268 nobody    16   0 14020 4068 1900 S  0.0  0.3   0:00.00 httpd              
    26271 Omlan     15   0     0    0    0 Z  0.0  0.0   0:01.25 php <defunct>      
    26273 nobody    16   0 14020 4000 1832 S  0.0  0.3   0:00.00 httpd              
    26275 nobody    16   0 13880 3976 1848 S  0.0  0.3   0:00.00 httpd              
    26276 nobody    16   0 14020 4016 1844 S  0.0  0.3   0:00.00 httpd              
    26278 nobody    16   0 14020 3996 1848 S  0.0  0.3   0:00.00 httpd              
    26281 Omlan     15   0     0    0    0 Z  0.0  0.0   0:00.51 php <defunct>      
    26282 Omlan     15   0  168m  23m  10m S  0.0  1.5   0:00.80 php                
    26283 Omlan     15   0  164m  18m  10m S  0.0  1.2   0:00.46 php                
    26284 Omlan     15   0  164m  18m  10m S  0.0  1.2   0:00.27 php                
    26285 Omlan     15   0  164m  18m  10m S  0.0  1.2   0:00.27 php                
    26286 Omlan     16   0  164m  18m  10m S  0.0  1.2   0:00.27 php                
    26287 Omlan     15   0  164m  18m  10m S  0.0  1.2   0:00.24 php                
    26288 Omlan     15   0  164m  18m  10m S  0.0  1.2   0:00.24 php                
    26289 Omlan     16   0  164m  18m  10m S  0.0  1.2   0:00.26 php                
    26290 Omlan     15   0  164m  18m  10m S  0.0  1.2   0:00.26 php                
    26293 Omlan     15   0  164m  18m  10m S  0.0  1.2   0:00.23 php                
    26294 Omlan     17   0  164m  18m  10m S  0.0  1.2   0:00.23 php                
    26295 Omlan     15   0  164m  18m 9700 S  0.0  1.2   0:00.23 php                
    26296 Omlan     18   0  164m  18m  10m S  0.0  1.2   0:00.24 php                
    26297 Omlan     16   0  164m  18m  10m S  0.0  1.2   0:00.27 php                
    26298 Omlan     15   0  164m  18m  10m S  0.0  1.2   0:00.25 php                
    26300 Omlan     15   0  164m  18m  10m S  0.0  1.2   0:00.23 php                
    26326 root      15   0  6468 1564 1124 S  0.0  0.1   0:00.02 mysqlmymonlite.    
    26482 root      15   0  2716 1016  764 R  0.0  0.1   0:00.00 top                
    
    
                 total       used       free     shared    buffers     cached
    Mem:          1536        538        997          0          0          0
    Low:          1536        538        997
    High:            0          0          0
    -/+ buffers/cache:        538        997
    Swap:            0          0          0
    
    MemTotal:      1572864 kB
    MemFree:       1021300 kB
    Buffers:             0 kB
    Cached:              0 kB
    SwapCached:          0 kB
    Active:              0 kB
    Inactive:            0 kB
    HighTotal:           0 kB
    HighFree:            0 kB
    LowTotal:      1572864 kB
    LowFree:       1021300 kB
    SwapTotal:           0 kB
    SwapFree:            0 kB
    Dirty:               0 kB
    Writeback:           0 kB
    AnonPages:           0 kB
    Mapped:         551564 kB
    Slab:                0 kB
    PageTables:          0 kB
    NFS_Unstable:        0 kB
    Bounce:              0 kB
    CommitLimit:         0 kB
    Committed_AS:  3164400 kB
    VmallocTotal:        0 kB
    VmallocUsed:         0 kB
    VmallocChunk:        0 kB
    HugePages_Total:     0
    HugePages_Free:      0
    HugePages_Rsvd:      0
    Hugepagesize:     2048 kB
    
    --------------------------
    ps_mem.py output:
    http://www.pixelbeat.org/scripts/ps_mem.py
    --------------------------
     Private  +   Shared  =  RAM used	Program 
    
    168.0 KiB +  28.0 KiB = 196.0 KiB	atd
    240.0 KiB +  30.5 KiB = 270.5 KiB	rpcbind
    264.0 KiB +  18.5 KiB = 282.5 KiB	udevd
    304.0 KiB +  17.0 KiB = 321.0 KiB	dovecot
    300.0 KiB +  35.0 KiB = 335.0 KiB	xinetd
    188.0 KiB + 191.0 KiB = 379.0 KiB	mysqld_safe
    320.0 KiB +  65.5 KiB = 385.5 KiB	pure-authd
    440.0 KiB +  31.5 KiB = 471.5 KiB	dovecot-auth
    516.0 KiB + 110.5 KiB = 626.5 KiB	pure-ftpd
    448.0 KiB + 206.0 KiB = 654.0 KiB	mysqlmymonlite.
    632.0 KiB +  45.0 KiB = 677.0 KiB	init
    656.0 KiB +  31.5 KiB = 687.5 KiB	crond
    468.0 KiB + 224.5 KiB = 692.5 KiB	bash
    708.0 KiB +  50.5 KiB = 758.5 KiB	exim
    852.0 KiB + 329.0 KiB =   1.2 MiB	pop3-login (2)
      1.2 MiB +  41.0 KiB =   1.2 MiB	rsyslogd
    888.0 KiB + 402.0 KiB =   1.3 MiB	imap-login (2)
      1.2 MiB +  90.0 KiB =   1.3 MiB	cpanellogd
      1.8 MiB + 379.0 KiB =   2.2 MiB	sshd (2)
      2.0 MiB + 178.5 KiB =   2.2 MiB	queueprocd
      3.7 MiB + 237.5 KiB =   3.9 MiB	munin-node
      3.7 MiB + 269.0 KiB =   3.9 MiB	tailwatchd
      3.9 MiB + 300.5 KiB =   4.2 MiB	leechprotect
      5.5 MiB + 977.0 KiB =   6.4 MiB	nginx (3)
      7.2 MiB +  60.0 KiB =   7.3 MiB	cpsrvd-ssl
     36.7 MiB + 207.5 KiB =  36.9 MiB	lfd
     31.7 MiB +   7.0 MiB =  38.7 MiB	httpd (76)
     60.4 MiB + 145.5 KiB =  60.5 MiB	named
    115.2 MiB + 193.0 KiB = 115.4 MiB	mysqld
    177.3 MiB +   5.9 MiB = 183.2 MiB	php (14)
    ---------------------------------
                            476.2 MiB
    =================================
    
     Private  +   Shared  =  RAM used	Program 
    
    
    ----------------------------
    Server Disk Usage
    ----------------------------
    Filesystem    Type    Size  Used Avail Use% Mounted on
    /dev/vzfs reiserfs     65G   14G   52G  22% /
    /dev/simfs   simfs     65G   14G   52G  22% /tmp
    none         tmpfs    768M  4.0K  768M   1% /dev
    
    ----------------------------
    MySQL datadir disk usage
    ----------------------------
    /var/lib/mysql/ uses 592656 kilobytes of disk space
    
    ----------------------------
    ulimit -aH
    ----------------------------
    core file size          (blocks, -c) unlimited
    data seg size           (kbytes, -d) unlimited
    scheduling priority             (-e) 0
    file size               (blocks, -f) unlimited
    pending signals                 (-i) 401408
    max locked memory       (kbytes, -l) 32
    max memory size         (kbytes, -m) unlimited
    open files                      (-n) 1024
    pipe size            (512 bytes, -p) 8
    POSIX message queues     (bytes, -q) 819200
    real-time priority              (-r) 0
    stack size              (kbytes, -s) unlimited
    cpu time               (seconds, -t) unlimited
    max user processes              (-u) 401408
    virtual memory          (kbytes, -v) unlimited
    file locks                      (-x) unlimited
    
    ----------------------------------------------------------
    tail -15 /etc/security/limits.conf
    ----------------------------------------------------------
    #        - nice - max nice priority allowed to raise to values: [-20, 19]
    #        - rtprio - max realtime priority
    #
    #<domain>      <type>  <item>         <value>
    #
    
    #*               soft    core            0
    #*               hard    rss             10000
    #@student        hard    nproc           20
    #@faculty        soft    nproc           20
    #@faculty        hard    nproc           50
    #ftp             hard    nproc           0
    #@student        -       maxlogins       4
    
    # End of file
    
    ----------------------------------------------------------
    mysqld process limits: 
    cat /proc/18051/limits
    ----------------------------------------------------------
    Limit                     Soft Limit           Hard Limit           Units     
    Max cpu time              unlimited            unlimited            seconds   
    Max file size             unlimited            unlimited            bytes     
    Max data size             unlimited            unlimited            bytes     
    Max stack size            10485760             unlimited            bytes     
    Max core file size        0                    0                    bytes     
    Max resident set          unlimited            unlimited            bytes     
    Max processes             401408               401408               processes 
    Max open files            2500                 2500                 files     
    Max locked memory         32768                32768                bytes     
    Max address space         unlimited            unlimited            bytes     
    Max file locks            unlimited            unlimited            locks     
    Max pending signals       401408               401408               signals   
    Max msgqueue size         819200               819200               bytes     
    Max nice priority         0                    0                    
    Max realtime priority     0                    0                    
    
    ----------------------------------
    CPANEL WEB SERVER & PHP Info:
    ----------------------------------
    WHM / Cpanel version: 11.34.1.7
    
    WHM's PHP Handler config:
    /usr/local/cpanel/bin/rebuild_phpconf --current
    Available handlers: suphp dso fcgi cgi none
    DEFAULT PHP: 5
    PHP4 SAPI: none
    PHP5 SAPI: fcgi
    SUEXEC: enabled
    RUID2: not installed
    
    PHP 5.4.11 (cli) (built: Feb  8 2013 02:35:19) 
    Copyright (c) 1997-2013 The PHP Group
    Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
        with XCache v3.0.1, Copyright (c) 2005-2013, by mOo
        with the ionCube PHP Loader v4.2.2, Copyright (c) 2002-2012, by ionCube Ltd.
        with XCache Cacher v3.0.1, Copyright (c) 2005-2013, by mOo
    
    System => Linux yourserverhostname 2.6.18-028stab099.3 #1 SMP Wed Mar 7 15:20:22 MSK 2012 i686
    Build Date => Feb  8 2013 02:34:51
    
    Configure Command =>  './configure'  '--disable-fileinfo' '--disable-pdo' '--disable-phar' '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-mbstring' '--enable-sockets' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-curl=/opt/curlssl/' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-zlib' '--with-zlib-dir=/usr' '--without-sqlite3'
    
    Server API | Command Line Interface
    Configuration File (php.ini) Path | /usr/local/lib
    Loaded Configuration File | /usr/local/lib/php.ini
    PHP API | 20100412
    Zend Extension Build | API220100525,NTS
    PHP Extension Build | API20100525,NTS
    DOM/XML API Version | 20031129
    Client API version | 5.1.66
    Client API library version | 5.1.66
    Client API header version | 5.1.66
    
    display_errors | STDOUT | STDOUT
    error_log | error_log | error_log
    extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20100525 | /usr/local/lib/php/extensions/no-debug-non-zts-20100525
    file_uploads | On | On
    log_errors | On | On
    log_errors_max_len | 1024 | 1024
    max_execution_time | 0 | 0
    max_file_uploads | 20 | 20
    memory_limit | 512M | 512M
    open_basedir | no value | no value
    post_max_size | 8M | 8M
    realpath_cache_size | 16K | 16K
    realpath_cache_ttl | 120 | 120
    sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
    sql.safe_mode | Off | Off
    upload_max_filesize | 64M | 64M
    upload_tmp_dir | no value | no value
    
    cURL support | enabled
    cURL Information | 7.24.0
    ZLib Version | 1.2.3
    GD Support | enabled
    GD Version | bundled (2.0.34 compatible)
    FreeType Support | enabled
    FreeType Linkage | with freetype
    FreeType Version | 2.3.11
    GIF Read Support | enabled
    GIF Create Support | enabled
    JPEG Support | enabled
    libJPEG Version | 6b
    PNG Support | enabled
    libPNG Version | 1.2.49
    WBMP Support | enabled
    libXML support | active
    libXML Compiled Version | 2.9.0
    libXML Loaded Version | 20900
    libXML streams | enabled
    PCRE (Perl Compatible Regular Expressions) Support | enabled
    PCRE Library Version | 8.21 2011-12-12
    ZLib Support | enabled
    
    xcache.coredump_directory | no value | no value
    xcache.coredump_type | 0 | 0
    xcache.disable_on_crash | Off | Off
    xcache.experimental | Off | Off
    xcache.test | Off | Off
    xcache.admin.enable_auth | Off | Off
    xcache.allocator | bestfit | bestfit
    xcache.cacher | On | On
    xcache.count | 24 | 24
    xcache.gc_interval | 0 | 0
    xcache.mmap_path | /dev/zero | /dev/zero
    xcache.readonly_protection | Off | Off
    xcache.shm_scheme | mmap | mmap
    xcache.size | 128M | 128M
    xcache.slots | 8K | 8K
    xcache.stat | On | On
    xcache.ttl | 0 | 0
    xcache.var_allocator | bestfit | bestfit
    xcache.var_count | 1 | 1
    xcache.var_gc_interval | 300 | 300
    xcache.var_maxttl | 0 | 0
    xcache.var_namespace | no value | no value
    xcache.var_namespace_mode | 0 | 0
    xcache.var_size | 4M | 4M
    xcache.var_slots | 8K | 8K
    xcache.var_ttl | 0 | 0
    
    
    
    
    
    
    Server version: Apache/2.2.23 (Unix)
    Server built:   Feb  8 2013 02:31:44
    Cpanel::Easy::Apache v3.18.0 rev9999
    Server's Module Magic Number: 20051115:31
    Server loaded:  APR 1.4.6, APR-Util 1.4.1
    Compiled using: APR 1.4.6, APR-Util 1.4.1
    Architecture:   32-bit
    Server MPM:     Prefork
      threaded:     no
        forked:     yes (variable process count)
    Server compiled with....
     -D APACHE_MPM_DIR="server/mpm/prefork"
     -D APR_HAS_SENDFILE
     -D APR_HAS_MMAP
     -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
     -D APR_USE_SYSVSEM_SERIALIZE
     -D APR_USE_PTHREAD_SERIALIZE
     -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
     -D APR_HAS_OTHER_CHILD
     -D AP_HAVE_RELIABLE_PIPED_LOGS
     -D DYNAMIC_MODULE_LIMIT=128
     -D HTTPD_ROOT="/usr/local/apache"
     -D SUEXEC_BIN="/usr/local/apache/bin/suexec"
     -D DEFAULT_PIDLOG="logs/httpd.pid"
     -D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
     -D DEFAULT_LOCKFILE="logs/accept.lock"
     -D DEFAULT_ERRORLOG="logs/error_log"
     -D AP_TYPES_CONFIG_FILE="conf/mime.types"
     -D SERVER_CONFIG_FILE="conf/httpd.conf"
    
    Loaded Modules:
     core_module (static)
     authn_file_module (static)
     authn_default_module (static)
     authz_host_module (static)
     authz_groupfile_module (static)
     authz_user_module (static)
     authz_default_module (static)
     auth_basic_module (static)
     include_module (static)
     filter_module (static)
     deflate_module (static)
     log_config_module (static)
     logio_module (static)
     env_module (static)
     expires_module (static)
     headers_module (static)
     unique_id_module (static)
     setenvif_module (static)
     version_module (static)
     proxy_module (static)
     proxy_connect_module (static)
     proxy_ftp_module (static)
     proxy_http_module (static)
     proxy_scgi_module (static)
     proxy_ajp_module (static)
     proxy_balancer_module (static)
     ssl_module (static)
     mpm_prefork_module (static)
     http_module (static)
     mime_module (static)
     status_module (static)
     autoindex_module (static)
     asis_module (static)
     info_module (static)
     suexec_module (static)
     cgi_module (static)
     negotiation_module (static)
     dir_module (static)
     actions_module (static)
     userdir_module (static)
     alias_module (static)
     rewrite_module (static)
     so_module (static)
     bwlimited_module (shared)
     rpaf_module (shared)
     fcgid_module (shared)
     security2_module (shared)
    
    Compiled in modules:
      core.c
      mod_authn_file.c
      mod_authn_default.c
      mod_authz_host.c
      mod_authz_groupfile.c
      mod_authz_user.c
      mod_authz_default.c
      mod_auth_basic.c
      mod_include.c
      mod_filter.c
      mod_deflate.c
      mod_log_config.c
      mod_logio.c
      mod_env.c
      mod_expires.c
      mod_headers.c
      mod_unique_id.c
      mod_setenvif.c
      mod_version.c
      mod_proxy.c
      mod_proxy_connect.c
      mod_proxy_ftp.c
      mod_proxy_http.c
      mod_proxy_scgi.c
      mod_proxy_ajp.c
      mod_proxy_balancer.c
      mod_ssl.c
      prefork.c
      http_core.c
      mod_mime.c
      mod_status.c
      mod_autoindex.c
      mod_asis.c
      mod_info.c
      mod_suexec.c
      mod_cgi.c
      mod_negotiation.c
      mod_dir.c
      mod_actions.c
      mod_userdir.c
      mod_alias.c
      mod_rewrite.c
      mod_so.c
    
    
    -------------------------------
    From /usr/local/apache/conf/httpd.conf
    -------------------------------
    Timeout 20
    KeepAlive On
    MaxKeepAliveRequests 100
    KeepAliveTimeout 3
    
    </IfModule>
    StartServers 5
    <IfModule prefork.c>
    MinSpareServers 5
    MaxSpareServers 10
    </IfModule>
    ServerLimit 256
    MaxClients 150
    MaxRequestsPerChild 1000
    
    
    ---------------
    You are running Nginx
    ---------------
    
    
    user  nobody;
    # no need for more workers in the proxy mode
    worker_processes  2;
    worker_rlimit_nofile 20480;
     worker_connections 5120; # increase for busier servers
     use epoll; # you should use epoll here for Linux kernels 2.6.x
     sendfile on;
     keepalive_timeout  5;
     gzip on;
     gzip_vary on;
     gzip_disable "MSIE [1-6]\.";
     gzip_proxied any;
     gzip_http_version 1.1;
     gzip_min_length  1000;
     gzip_comp_level  6;
     gzip_buffers  16 8k;
     gzip_types    text/plain text/xml text/css application/x-javascript application/xml image/png image/x-icon image/gif image/jpeg application/xml+rss text/javascript application/atom+xml;
     client_header_timeout  3m;
     client_body_timeout 3m;
     client_header_buffer_size 256k;
     large_client_header_buffers 4 256k;
     client_max_body_size 200M; 
     client_body_buffer_size 128k;
     proxy_temp_path  /tmp/nginx_proxy/;
     client_body_in_file_only on;
    
    ----------------------------
    mysqlreport output
    ----------------------------
    
    MySQL 5.1.66-cll         uptime 2 7:59:39       Thu Feb 14 05:28:14 2013
    
    __ Key _________________________________________________________________
    Buffer used    12.30M of  32.00M  %Used:  38.44
      Current       7.92M            %Usage:  24.76
    Write hit      71.48%
    Read hit      100.00%
    
    __ Questions ___________________________________________________________
    Total          56.58M   280.7/s
      QC Hits      51.87M   257.3/s  %Total:  91.68
      DMS           3.67M    18.2/s            6.48
      Com_        778.30k     3.9/s            1.38
      COM_QUIT    266.73k     1.3/s            0.47
      -Unknown      4.04k     0.0/s            0.01
    Slow 1 s       15.99k     0.1/s            0.03  %DMS:   0.44  Log:  ON
    DMS             3.67M    18.2/s            6.48
      SELECT        3.50M    17.3/s            6.18         95.28
      UPDATE      143.75k     0.7/s            0.25          3.92
      INSERT       27.76k     0.1/s            0.05          0.76
      DELETE        1.80k     0.0/s            0.00          0.05
      REPLACE           0       0/s            0.00          0.00
    Com_          778.30k     3.9/s            1.38
      set_option  513.65k     2.5/s            0.91
      change_db   256.45k     1.3/s            0.45
      show_status   3.47k     0.0/s            0.01
    
    __ SELECT and Sort _____________________________________________________
    Scan          633.78k     3.1/s %SELECT:  18.13
    Range           1.10M     5.4/s           31.42
    Full join       1.54M     7.7/s           44.20
    Range check         0       0/s            0.00
    Full rng join       0       0/s            0.00
    Sort scan       1.18M     5.9/s
    Sort range    560.97k     2.8/s
    Sort mrg pass       5     0.0/s
    
    __ Query Cache _________________________________________________________
    Memory usage   18.44M of  32.00M  %Used:  57.63
    Block Fragmnt  11.74%
    Hits           51.87M   257.3/s
    Inserts       602.54k     3.0/s
    Insrt:Prune    8.66:1     2.6/s
    Hit:Insert    86.09:1
    
    __ Table Locks _________________________________________________________
    Waited         51.79k     0.3/s  %Total:   0.57
    Immediate       8.98M    44.5/s
    
    __ Tables ______________________________________________________________
    Open              512 of  512    %Cache: 100.00
    Opened          3.20k     0.0/s
    
    __ Connections _________________________________________________________
    Max used           78 of  500      %Max:  15.60
    Total         266.96k     1.3/s
    
    __ Created Temp ________________________________________________________
    Disk table      1.08M     5.4/s
    Table           1.96M     9.7/s    Size:  32.0M
    File               15     0.0/s
    
    __ Threads _____________________________________________________________
    Running            49 of   49
    Cached             29 of 1638      %Hit:  99.97
    Created            78     0.0/s
    Slow                0       0/s
    
    __ Aborted _____________________________________________________________
    Clients           471     0.0/s
    Connects        2.72k     0.0/s
    
    __ Bytes _______________________________________________________________
    Sent          162.28G  805.0k/s
    Received       11.14G   55.3k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage         368.00k of   8.00M  %Used:   4.49
    Read hit       99.91%
    Pages
      Free            489            %Total:  95.51
      Data             23                      4.49 %Drty:   0.00
      Misc              0                      0.00
      Latched                                  0.00
    Reads          17.71k     0.1/s
      From file        16     0.0/s            0.09
      Ahead Rnd         1     0.0/s
    Writes              0       0/s
    Flushes             0       0/s
    Wait Free           0       0/s
    
    __ InnoDB Lock _________________________________________________________
    Waits               0       0/s
    Current             0
    Time acquiring
      Total             0 ms
      Average           0 ms
      Max               0 ms
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads            29     0.0/s
      Writes            3     0.0/s
      fsync             3     0.0/s
      Pending
        Reads           0
        Writes          0
        fsync           0
    
    Pages
      Created           0       0/s
      Read             23     0.0/s
      Written           0       0/s
    
    Rows
      Deleted           0       0/s
      Inserted          0       0/s
      Read              0       0/s
      Updated           0       0/s
    
    ----------------------------
    Total Server MyISAM and InnoDB Size
    ----------------------------
    *************************** 1. row ***************************
    innodb_tablespace_utilization_perc: 0
                         total_size_gb: 0.517665512859821
                         index_size_gb: 0.218725204467773
                          data_size_gb: 0.298940308392048
                  innodb_total_size_gb: 4.57763671875e-05
                   innodb_data_size_gb: 3.0517578125e-05
                  innodb_index_size_gb: 1.52587890625e-05
                  myisam_total_size_gb: 0.517619736492634
                   myisam_data_size_gb: 0.298909790813923
                  myisam_index_size_gb: 0.218709945678711
                            perc_index: 42.252226300
                             perc_data: 57.747773600
                     innodb_perc_index: 33.333333300
                      innodb_perc_data: 66.666666600
                     myisam_perc_index: 42.253015100
                      myisam_perc_data: 57.746984800
               innodb_perc_total_index: 0.006976200
                innodb_perc_total_data: 0.010208500
               myisam_perc_total_index: 99.993023700
                myisam_perc_total_data: 99.989791400
    
    ----------------------------
    Table Index Size
    ----------------------------
    ------------------------------
    **c**h**ld Index Size = 0.01 MB
    ------------------------------
    ------------------------------
    **e**l**n**b**c**u Index Size = 167.55 MB
    ------------------------------
    ------------------------------
    **e**l**n**z**r**a Index Size = 34.35 MB
    ------------------------------
    ------------------------------
    **e**a**_**a**l**f**et Index Size = 0.14 MB
    ------------------------------
    ------------------------------
    **e**i**s**as Index Size = 21.66 MB
    ------------------------------
    ------------------------------
    **h**re Index Size = 0.14 MB
    ------------------------------
    ------------------------------
    **l**e**h**r**t**c Index Size = 0.00 MB
    ------------------------------
    ------------------------------
    **l**g**h**l**c**B**h**s Index Size = 0.02 MB
    ------------------------------
    ------------------------------
    **m**d**e Index Size = 0.00 MB
    ------------------------------
    ------------------------------
    **m**n**n**i**n**d Index Size = 0.00 MB
    ------------------------------
    ------------------------------
    **m**sl Index Size = 0.09 MB
    ------------------------------
    ------------------------------
    **r**u**d**ue Index Size = 0.00 MB
    ------------------------------
    
    ----------------------------
    Table Data Size
    ----------------------------
    ------------------------------
    **c**h**ld Data Size = 0.00 MB
    ------------------------------
    ------------------------------
    **e**l**n**b**c**u Data Size = 142.49 MB
    ------------------------------
    ------------------------------
    **e**l**n**z**r**a Data Size = 64.64 MB
    ------------------------------
    ------------------------------
    **e**a**_**a**l**f**et Data Size = 1.84 MB
    ------------------------------
    ------------------------------
    **e**i**s**as Data Size = 96.53 MB
    ------------------------------
    ------------------------------
    **h**re Data Size = 0.02 MB
    ------------------------------
    ------------------------------
    **l**e**h**r**t**c Data Size = 0.00 MB
    ------------------------------
    ------------------------------
    **l**g**h**l**c**B**h**s Data Size = 0.00 MB
    ------------------------------
    ------------------------------
    **m**d**e Data Size = 0.00 MB
    ------------------------------
    ------------------------------
    **m**n**n**i**n**d Data Size = 0.02 MB
    ------------------------------
    ------------------------------
    **m**sl Data Size = 0.56 MB
    ------------------------------
    ------------------------------
    **r**u**d**ue Data Size = 0.00 MB
    ------------------------------
    
    ----------------------------
    Database per Table Size
    ----------------------------
    
    ----------------------
    **e**l**n**b**c**u per Table Size
    ----------------------
    +--------------------------------------------------+----------------+----------------+-----------+------------+----------+
    | Table Name                                       | Number of Rows | Storage Engine | Data Size | Index Size | Total    |
    +--------------------------------------------------+----------------+----------------+-----------+------------+----------+
    | **e**l**n**b**c**u.tu_articles_shows                   | 48506 Rows     | MyISAM         | 1.42MB    | 0.64MB     | 2.06MB   |
    | **e**l**n**b**c**u.tu_data_formats                     | 6120 Rows      | MyISAM         | 0.27MB    | 0.17MB     | 0.45MB   |
    | **e**l**n**b**c**u.tu_geo_blocks_empty                 | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB   |
    | **e**l**n**b**c**u.tu_geo_blocks_optimized             | 1928596 Rows   | MyISAM         | 23.91MB   | 48.16MB    | 72.07MB  |
    | **e**l**n**b**c**u.tu_geo_blocks_original              | 4237491 Rows   | MyISAM         | 52.54MB   | 91.42MB    | 143.95MB |
    | **e**l**n**b**c**u.tu_geo_blocks_withoutcities_withusa | 695405 Rows    | MyISAM         | 8.62MB    | 18.13MB    | 26.75MB  |
    | **e**l**n**b**c**u.tu_geo_location                     | 292412 Rows    | MyISAM         | 17.71MB   | 0.00MB     | 17.71MB  |
    | **e**l**n**b**c**u.tu_geo_location_backup              | 292412 Rows    | MyISAM         | 17.71MB   | 0.00MB     | 17.71MB  |
    | **e**l**n**b**c**u.tu_listings_shows                   | 685462 Rows    | MyISAM         | 20.30MB   | 9.03MB     | 29.34MB  |
    +--------------------------------------------------+----------------+----------------+-----------+------------+----------+
    
    ----------------------
    **e**l**n**z**r**a per Table Size
    ----------------------
    +----------------------------------------+----------------+----------------+-----------+------------+---------+
    | Table Name                             | Number of Rows | Storage Engine | Data Size | Index Size | Total   |
    +----------------------------------------+----------------+----------------+-----------+------------+---------+
    | **e**l**n**z**r**a.tu_account_fields         | 15 Rows        | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_account_types          | 4 Rows         | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_accounts               | 3444 Rows      | MyISAM         | 0.64MB    | 0.04MB     | 0.67MB  |
    | **e**l**n**z**r**a.tu_admin_controllers      | 47 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_admins                 | 3 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_articles               | 108 Rows       | MyISAM         | 0.63MB    | 0.00MB     | 0.63MB  |
    | **e**l**n**z**r**a.tu_articles_comments      | 8 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_articles_shows         | 53574 Rows     | MyISAM         | 1.58MB    | 0.86MB     | 2.43MB  |
    | **e**l**n**z**r**a.tu_banner_plans           | 3 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_blocks                 | 50 Rows        | MyISAM         | 0.01MB    | 0.01MB     | 0.02MB  |
    | **e**l**n**z**r**a.tu_categories             | 312 Rows       | MyISAM         | 0.03MB    | 0.06MB     | 0.08MB  |
    | **e**l**n**z**r**a.tu_comments               | 39 Rows        | MyISAM         | 0.01MB    | 0.00MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_config                 | 284 Rows       | MyISAM         | 0.01MB    | 0.00MB     | 0.02MB  |
    | **e**l**n**z**r**a.tu_config_groups          | 31 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_contacts               | 16 Rows        | MyISAM         | 0.01MB    | 0.01MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_coupon_code            | 1 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_coupon_users           | 1 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_data_formats           | 6120 Rows      | MyISAM         | 0.27MB    | 0.39MB     | 0.66MB  |
    | **e**l**n**z**r**a.tu_dealer_banners         | 5 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_dealer_banners_clicks  | 929 Rows       | MyISAM         | 0.02MB    | 0.03MB     | 0.04MB  |
    | **e**l**n**z**r**a.tu_email_templates        | 45 Rows        | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_favorites              | 25 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_featured_form          | 39 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_geo_blocks             | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_geo_blocks_1           | 695405 Rows    | MyISAM         | 8.62MB    | 15.00MB    | 23.63MB |
    | **e**l**n**z**r**a.tu_geo_location           | 292412 Rows    | MyISAM         | 17.71MB   | 6.36MB     | 24.07MB |
    | **e**l**n**z**r**a.tu_hooks                  | 89 Rows        | MyISAM         | 0.04MB    | 0.01MB     | 0.05MB  |
    | **e**l**n**z**r**a.tu_ip_country             | 99753 Rows     | MyISAM         | 4.27MB    | 0.00MB     | 4.27MB  |
    | **e**l**n**z**r**a.tu_lang_keys              | 29446 Rows     | MyISAM         | 3.75MB    | 0.95MB     | 4.70MB  |
    | **e**l**n**z**r**a.tu_languages              | 3 Rows         | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_listing_fields         | 39 Rows        | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_listing_groups         | 3 Rows         | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_listing_packages       | 5 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_listing_photos         | 7052 Rows      | MyISAM         | 1.18MB    | 0.20MB     | 1.38MB  |
    | **e**l**n**z**r**a.tu_listing_plans          | 4 Rows         | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_listing_relations      | 75 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_listing_sections       | 5 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_listing_titles         | 282 Rows       | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_listing_video          | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_listings               | 5363 Rows      | MyISAM         | 4.73MB    | 0.32MB     | 5.05MB  |
    | **e**l**n**z**r**a.tu_listings_shows         | 710597 Rows    | MyISAM         | 21.05MB   | 9.93MB     | 30.98MB |
    | **e**l**n**z**r**a.tu_massmailer             | 1 Rows         | MyISAM         | 0.01MB    | 0.00MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_messages               | 29 Rows        | MyISAM         | 0.01MB    | 0.00MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_news                   | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_pages                  | 54 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_paymet_gateways        | 8 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_plugins                | 27 Rows        | MyISAM         | 0.01MB    | 0.00MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_polls                  | 1 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_polls_items            | 6 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_reg_prevent            | 219 Rows       | MyISAM         | 0.02MB    | 0.00MB     | 0.02MB  |
    | **e**l**n**z**r**a.tu_report_broken_listing  | 4 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_rss_feed               | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_saved_search           | 4 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_search_forms           | 15 Rows        | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_search_forms_relations | 39 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_short_forms            | 39 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_subscribe              | 166 Rows       | MyISAM         | 0.01MB    | 0.01MB     | 0.01MB  |
    | **e**l**n**z**r**a.tu_tag_cloud              | 487 Rows       | MyISAM         | 0.01MB    | 0.01MB     | 0.02MB  |
    | **e**l**n**z**r**a.tu_tmp_categories         | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_transactions           | 15 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    | **e**l**n**z**r**a.tu_trash_box              | 11 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  |
    +----------------------------------------+----------------+----------------+-----------+------------+---------+
    
    ----------------------
    **e**a**_**a**l**f**et per Table Size
    ----------------------
    +------------------------------------------+----------------+----------------+-----------+------------+--------+
    | Table Name                               | Number of Rows | Storage Engine | Data Size | Index Size | Total  |
    +------------------------------------------+----------------+----------------+-----------+------------+--------+
    | **e**a**_**a**l**f**et.x68z1_bwps_lockouts      | 5 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    | **e**a**_**a**l**f**et.x68z1_bwps_log           | 1068 Rows      | MyISAM         | 0.48MB    | 0.01MB     | 0.49MB |
    | **e**a**_**a**l**f**et.x68z1_commentmeta        | 0 Rows         | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB |
    | **e**a**_**a**l**f**et.x68z1_comments           | 11 Rows        | MyISAM         | 0.01MB    | 0.01MB     | 0.01MB |
    | **e**a**_**a**l**f**et.x68z1_links              | 4 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    | **e**a**_**a**l**f**et.x68z1_options            | 345 Rows       | MyISAM         | 0.53MB    | 0.02MB     | 0.55MB |
    | **e**a**_**a**l**f**et.x68z1_postmeta           | 348 Rows       | MyISAM         | 0.03MB    | 0.03MB     | 0.06MB |
    | **e**a**_**a**l**f**et.x68z1_posts              | 168 Rows       | MyISAM         | 0.79MB    | 0.02MB     | 0.81MB |
    | **e**a**_**a**l**f**et.x68z1_term_relationships | 27 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    | **e**a**_**a**l**f**et.x68z1_term_taxonomy      | 23 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    | **e**a**_**a**l**f**et.x68z1_terms              | 23 Rows        | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB |
    | **e**a**_**a**l**f**et.x68z1_usermeta           | 27 Rows        | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB |
    | **e**a**_**a**l**f**et.x68z1_users              | 1 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    +------------------------------------------+----------------+----------------+-----------+------------+--------+
    
    ----------------------
    **l**g**h**l**c**B**h**s per Table Size
    ----------------------
    +------------------------------------------------+----------------+----------------+-----------+------------+--------+
    | Table Name                                     | Number of Rows | Storage Engine | Data Size | Index Size | Total  |
    +------------------------------------------------+----------------+----------------+-----------+------------+--------+
    | **l**g**h**l**c**B**h**s._logaholic_GlobalSettings     | 4 Rows         | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB |
    | **l**g**h**l**c**B**h**s._logaholic_Profile_URL_Params | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    | **l**g**h**l**c**B**h**s._logaholic_Profiles           | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    | **l**g**h**l**c**B**h**s._logaholic_Traffic_Sources    | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    | **l**g**h**l**c**B**h**s._logaholic_users              | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    | **l**g**h**l**c**B**h**s._user_Agents                  | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    | **l**g**h**l**c**B**h**s.lgstatus                      | 50 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    | **l**g**h**l**c**B**h**s.notes                         | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    +------------------------------------------------+----------------+----------------+-----------+------------+--------+
    
    ----------------------
    **m**d**e per Table Size
    ----------------------
    +---------------+----------------+----------------+-----------+------------+--------+
    | Table Name    | Number of Rows | Storage Engine | Data Size | Index Size | Total  |
    +---------------+----------------+----------------+-----------+------------+--------+
    | **m**d**e.**m**d**e | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    +---------------+----------------+----------------+-----------+------------+--------+
    
    ----------------------
    **m**n**n**i**n**d per Table Size
    ----------------------
    +---------------------------+----------------+----------------+-----------+------------+--------+
    | Table Name                | Number of Rows | Storage Engine | Data Size | Index Size | Total  |
    +---------------------------+----------------+----------------+-----------+------------+--------+
    | **m**n**n**i**n**d.sample_table | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    +---------------------------+----------------+----------------+-----------+------------+--------+
    
    ----------------------------
    MySQL settings
    ----------------------------
    [mysqld]
    max_connections=500
    query_cache_size=32M
    query_cache_limit=4M
    thread_cache_size=8M
    table_definition_cache=512
    table_open_cache=512
    key_buffer_size=32M
    tmp_table_size=32M
    max_heap_table_size=32M
    interactive_timeout=120
    wait_timeout=120
    long_query_time = 1
    #general_log    
    slow_query_log---
    +-----------------------------------------+-------------------------------------------------------------------------------------------+
    | Variable_name | Value |
    +-----------------------------------------+-------------------------------------------------------------------------------------------+
    | auto_increment_increment | 1 |
    | auto_increment_offset | 1 |
    | autocommit | ON |
    | automatic_sp_privileges | ON |
    | back_log | 50 |
    | basedir | / |
    | big_tables | OFF |
    | binlog_cache_size | 32768 |
    | binlog_direct_non_transactional_updates | OFF |
    | binlog_format | STATEMENT |
    | bulk_insert_buffer_size | 8388608 |
    | character_set_client | latin1 |
    | character_set_connection | latin1 |
    | character_set_database | latin1 |
    | character_set_filesystem | binary |
    | character_set_results | latin1 |
    | character_set_server | latin1 |
    | character_set_system | utf8 |
    | character_sets_dir | /usr/share/mysql/charsets/ |
    | collation_connection | latin1_swedish_ci |
    | collation_database | latin1_swedish_ci |
    | collation_server | latin1_swedish_ci |
    | completion_type | 0 |
    | concurrent_insert | 1 |
    | connect_timeout | 10 |
    | datadir | /var/lib/mysql/ |
    | date_format | %Y-%m-%d |
    | datetime_format | %Y-%m-%d %H:%i:%s |
    | default_week_format | 0 |
    | delay_key_write | ON |
    | delayed_insert_limit | 100 |
    | delayed_insert_timeout | 300 |
    | delayed_queue_size | 1000 |
    | div_precision_increment | 4 |
    | engine_condition_pushdown | ON |
    | error_count | 0 |
    | event_scheduler | OFF |
    | expire_logs_days | 0 |
    | flush | OFF |
    | flush_time | 0 |
    | foreign_key_checks | ON |
    | ft_boolean_syntax | + -><()~*:""&| |
    | ft_max_word_len | 84 |
    | ft_min_word_len | 4 |
    | ft_query_expansion_limit | 20 |
    | ft_stopword_file | (built-in) |
    | general_log | OFF |
    | general_log_file | /var/lib/mysql/host.log |
    | group_concat_max_len | 1024 |
    | have_community_features | YES |
    | have_compress | YES |
    | have_crypt | YES |
    | have_csv | YES |
    | have_dynamic_loading | YES |
    | have_geometry | YES |
    | have_innodb | YES |
    | have_ndbcluster | NO |
    | have_openssl | DISABLED |
    | have_partitioning | YES |
    | have_query_cache | YES |
    | have_rtree_keys | YES |
    | have_ssl | DISABLED |
    | have_symlink | YES |
    | hostname | yourserverhostname |
    | identity | 0 |
    | ignore_builtin_innodb | OFF |
    | init_connect | |
    | init_file | |
    | init_slave | |
    | innodb_adaptive_hash_index | ON |
    | innodb_additional_mem_pool_size | 1048576 |
    | innodb_autoextend_increment | 8 |
    | innodb_autoinc_lock_mode | 1 |
    | innodb_buffer_pool_size | 8388608 |
    | innodb_checksums | ON |
    | innodb_commit_concurrency | 0 |
    | innodb_concurrency_tickets | 500 |
    | innodb_data_file_path | ibdata1:10M:autoextend |
    | innodb_data_home_dir | |
    | innodb_doublewrite | ON |
    | innodb_fast_shutdown | 1 |
    | innodb_file_io_threads | 4 |
    | innodb_file_per_table | OFF |
    | innodb_flush_log_at_trx_commit | 1 |
    | innodb_flush_method | |
    | innodb_force_recovery | 0 |
    | innodb_lock_wait_timeout | 50 |
    | innodb_locks_unsafe_for_binlog | OFF |
    | innodb_log_buffer_size | 1048576 |
    | innodb_log_file_size | 5242880 |
    | innodb_log_files_in_group | 2 |
    | innodb_log_group_home_dir | ./ |
    | innodb_max_dirty_pages_pct | 90 |
    | innodb_max_purge_lag | 0 |
    | innodb_mirrored_log_groups | 1 |
    | innodb_open_files | 300 |
    | innodb_rollback_on_timeout | OFF |
    | innodb_stats_method | nulls_equal |
    | innodb_stats_on_metadata | ON |
    | innodb_support_xa | ON |
    | innodb_sync_spin_loops | 20 |
    | innodb_table_locks | ON |
    | innodb_thread_concurrency | 8 |
    | innodb_thread_sleep_delay | 10000 |
    | innodb_use_legacy_cardinality_algorithm | ON |
    | insert_id | 0 |
    | interactive_timeout | 120 |
    | join_buffer_size | 131072 |
    | keep_files_on_create | OFF |
    | key_buffer_size | 33554432 |
    | key_cache_age_threshold | 300 |
    | key_cache_block_size | 1024 |
    | key_cache_division_limit | 100 |
    | language | /usr/share/mysql/english/ |
    | large_files_support | ON |
    | large_page_size | 0 |
    | large_pages | OFF |
    | last_insert_id | 0 |
    | lc_time_names | en_US |
    | license | GPL |
    | local_infile | ON |
    | locked_in_memory | OFF |
    | log | OFF |
    | log_bin | OFF |
    | log_bin_trust_function_creators | OFF |
    | log_bin_trust_routine_creators | OFF |
    | log_error | /var/lib/mysql/yourserverhostname.err |
    | log_output | FILE |
    | log_queries_not_using_indexes | OFF |
    | log_slave_updates | OFF |
    | log_slow_queries | ON |
    | log_warnings | 1 |
    | long_query_time | 1.000000 |
    | low_priority_updates | OFF |
    | lower_case_file_system | OFF |
    | lower_case_table_names | 0 |
    | max_allowed_packet | 1048576 |
    | max_binlog_cache_size | 4294963200 |
    | max_binlog_size | 1073741824 |
    | max_connect_errors | 10 |
    | max_connections | 500 |
    | max_delayed_threads | 20 |
    | max_error_count | 64 |
    | max_heap_table_size | 33554432 |
    | max_insert_delayed_threads | 20 |
    | max_join_size | 18446744073709551615 |
    | max_length_for_sort_data | 1024 |
    | max_long_data_size | 1048576 |
    | max_prepared_stmt_count | 16382 |
    | max_relay_log_size | 0 |
    | max_seeks_for_key | 4294967295 |
    | max_sort_length | 1024 |
    | max_sp_recursion_depth | 0 |
    | max_tmp_tables | 32 |
    | max_user_connections | 0 |
    | max_write_lock_count | 4294967295 |
    | min_examined_row_limit | 0 |
    | multi_range_count | 256 |
    | myisam_data_pointer_size | 6 |
    | myisam_max_sort_file_size | 2146435072 |
    | myisam_mmap_size | 4294967295 |
    | myisam_recover_options | OFF |
    | myisam_repair_threads | 1 |
    | myisam_sort_buffer_size | 8388608 |
    | myisam_stats_method | nulls_unequal |
    | myisam_use_mmap | OFF |
    | net_buffer_length | 16384 |
    | net_read_timeout | 30 |
    | net_retry_count | 10 |
    | net_write_timeout | 60 |
    | new | OFF |
    | old | OFF |
    | old_alter_table | OFF |
    | old_passwords | OFF |
    | open_files_limit | 2500 |
    | optimizer_prune_level | 1 |
    | optimizer_search_depth | 62 |
    | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on |
    | pid_file | /var/lib/mysql/yourserverhostname.pid |
    | plugin_dir | /usr/lib/mysql/plugin |
    | port | 3306 |
    | preload_buffer_size | 32768 |
    | profiling | OFF |
    | profiling_history_size | 15 |
    | protocol_version | 10 |
    | pseudo_thread_id | 0 |
    | query_alloc_block_size | 8192 |
    | query_cache_limit | 4194304 |
    | query_cache_min_res_unit | 4096 |
    | query_cache_size | 33554432 |
    | query_cache_type | ON |
    | query_cache_wlock_invalidate | OFF |
    | query_prealloc_size | 8192 |
    | rand_seed1 | |
    | rand_seed2 | |
    | range_alloc_block_size | 4096 |
    | read_buffer_size | 131072 |
    | read_only | OFF |
    | read_rnd_buffer_size | 262144 |
    | relay_log | |
    | relay_log_index | |
    | relay_log_info_file | relay-log.info |
    | relay_log_purge | ON |
    | relay_log_space_limit | 0 |
    | report_host | |
    | report_password | |
    | report_port | 3306 |
    | report_user | |
    | rpl_recovery_rank | 0 |
    | secure_auth | OFF |
    | secure_file_priv | |
    | server_id | 0 |
    | skip_external_locking | ON |
    | skip_name_resolve | OFF |
    | skip_networking | OFF |
    | skip_show_database | OFF |
    | slave_compressed_protocol | OFF |
    | slave_exec_mode | STRICT |
    | slave_load_tmpdir | /tmp |
    | slave_max_allowed_packet | 1073741824 |
    | slave_net_timeout | 3600 |
    | slave_skip_errors | OFF |
    | slave_transaction_retries | 10 |
    | slow_launch_time | 2 |
    | slow_query_log | ON |
    | slow_query_log_file | /var/lib/mysql/host-slow.log |
    | socket | /var/lib/mysql/mysql.sock |
    | sort_buffer_size | 2097144 |
    | sql_auto_is_null | ON |
    | sql_big_selects | ON |
    | sql_big_tables | OFF |
    | sql_buffer_result | OFF |
    | sql_log_bin | ON |
    | sql_log_off | OFF |
    | sql_log_update | ON |
    | sql_low_priority_updates | OFF |
    | sql_max_join_size | 18446744073709551615 |
    | sql_mode | |
    | sql_notes | ON |
    | sql_quote_show_create | ON |
    | sql_safe_updates | OFF |
    | sql_select_limit | 18446744073709551615 |
    | sql_slave_skip_counter | |
    | sql_warnings | OFF |
    | ssl_ca | |
    | ssl_capath | |
    | ssl_cert | |
    | ssl_cipher | |
    | ssl_key | |
    | storage_engine | MyISAM |
    | sync_binlog | 0 |
    | sync_frm | ON |
    | system_time_zone | EET |
    | table_definition_cache | 512 |
    | table_lock_wait_timeout | 50 |
    | table_open_cache | 512 |
    | table_type | MyISAM |
    | thread_cache_size | 16384 |
    | thread_handling | one-thread-per-connection |
    | thread_stack | 196608 |
    | thread_statistics | OFF |
    | time_format | %H:%i:%s |
    | time_zone | SYSTEM |
    | timed_mutexes | OFF |
    | timestamp | 1360812503 |
    | tmp_table_size | 33554432 |
    | tmpdir | /tmp |
    | transaction_alloc_block_size | 8192 |
    | transaction_prealloc_size | 4096 |
    | tx_isolation | REPEATABLE-READ |
    | unique_checks | ON |
    | updatable_views_with_limit | YES |
    | userstat_running | OFF |
    | version | 5.1.66-cll |
    | version_comment | MySQL Community Server (GPL) |
    | version_compile_machine | i686 |
    | version_compile_os | pc-linux-gnu |
    | wait_timeout | 120 |
    | warning_count | 0 |
    +-----------------------------------------+-------------------------------------------------------------------------------------------+
    +-----------------------------------+--------------+
    | Variable_name | Value |
    +-----------------------------------+--------------+
    | Aborted_clients | 476 |
    | Aborted_connects | 2719 |
    | Binlog_cache_disk_use | 0 |
    | Binlog_cache_use | 0 |
    | Bytes_received | 11138884253 |
    | Bytes_sent | 162276357363 |
    | Com_admin_commands | 830 |
    | Com_assign_to_keycache | 0 |
    | Com_alter_db | 0 |
    | Com_alter_db_upgrade | 0 |
    | Com_alter_event | 0 |
    | Com_alter_function | 0 |
    | Com_alter_procedure | 0 |
    | Com_alter_server | 0 |
    | Com_alter_table | 0 |
    | Com_alter_tablespace | 0 |
    | Com_analyze | 0 |
    | Com_backup_table | 0 |
    | Com_begin | 0 |
    | Com_binlog | 0 |
    | Com_call_procedure | 0 |
    | Com_change_db | 256447 |
    | Com_change_master | 0 |
    | Com_check | 0 |
    | Com_checksum | 0 |
    | Com_commit | 0 |
    | Com_create_db | 0 |
    | Com_create_event | 0 |
    | Com_create_function | 0 |
    | Com_create_index | 0 |
    | Com_create_procedure | 0 |
    | Com_create_server | 0 |
    | Com_create_table | 0 |
    | Com_create_trigger | 0 |
    | Com_create_udf | 0 |
    | Com_create_user | 0 |
    | Com_create_view | 0 |
    | Com_dealloc_sql | 0 |
    | Com_delete | 1798 |
    | Com_delete_multi | 0 |
    | Com_do | 0 |
    | Com_drop_db | 0 |
    | Com_drop_event | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_procedure | 0 |
    | Com_drop_server | 0 |
    | Com_drop_table | 0 |
    | Com_drop_trigger | 0 |
    | Com_drop_user | 0 |
    | Com_drop_view | 0 |
    | Com_empty_query | 0 |
    | Com_execute_sql | 0 |
    | Com_flush | 2 |
    | Com_grant | 5 |
    | Com_ha_close | 0 |
    | Com_ha_open | 0 |
    | Com_ha_read | 0 |
    | Com_help | 0 |
    | Com_insert | 27762 |
    | Com_insert_select | 0 |
    | Com_install_plugin | 0 |
    | Com_kill | 0 |
    | Com_load | 0 |
    | Com_load_master_data | 0 |
    | Com_load_master_table | 0 |
    | Com_lock_tables | 179 |
    | Com_optimize | 184 |
    | Com_preload_keys | 0 |
    | Com_prepare_sql | 0 |
    | Com_purge | 0 |
    | Com_purge_before_date | 0 |
    | Com_release_savepoint | 0 |
    | Com_rename_table | 0 |
    | Com_rename_user | 0 |
    | Com_repair | 0 |
    | Com_replace | 0 |
    | Com_replace_select | 0 |
    | Com_reset | 0 |
    | Com_restore_table | 0 |
    | Com_revoke | 0 |
    | Com_revoke_all | 0 |
    | Com_rollback | 0 |
    | Com_rollback_to_savepoint | 0 |
    | Com_savepoint | 0 |
    | Com_select | 3495428 |
    | Com_set_option | 513651 |
    | Com_show_authors | 0 |
    | Com_show_binlog_events | 0 |
    | Com_show_binlogs | 2 |
    | Com_show_charsets | 0 |
    | Com_show_client_statistics | 0 |
    | Com_show_collations | 0 |
    | Com_show_column_types | 0 |
    | Com_show_contributors | 0 |
    | Com_show_create_db | 9 |
    | Com_show_create_event | 0 |
    | Com_show_create_func | 0 |
    | Com_show_create_proc | 0 |
    | Com_show_create_table | 263 |
    | Com_show_create_trigger | 0 |
    | Com_show_databases | 17 |
    | Com_show_engine_logs | 0 |
    | Com_show_engine_mutex | 0 |
    | Com_show_engine_status | 0 |
    | Com_show_events | 0 |
    | Com_show_errors | 0 |
    | Com_show_fields | 626 |
    | Com_show_function_status | 71 |
    | Com_show_grants | 62 |
    | Com_show_index_statistics | 0 |
    | Com_show_keys | 10 |
    | Com_show_master_status | 10 |
    | Com_show_new_master | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_plugins | 7 |
    | Com_show_privileges | 0 |
    | Com_show_procedure_status | 71 |
    | Com_show_processlist | 731 |
    | Com_show_profile | 0 |
    | Com_show_profiles | 0 |
    | Com_show_slave_hosts | 0 |
    | Com_show_slave_status | 10 |
    | Com_show_status | 3469 |
    | Com_show_storage_engines | 8 |
    | Com_show_table_statistics | 0 |
    | Com_show_table_status | 644 |
    | Com_show_tables | 143 |
    | Com_show_thread_statistics | 0 |
    | Com_show_triggers | 560 |
    | Com_show_user_statistics | 0 |
    | Com_show_variables | 111 |
    | Com_show_warnings | 3 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_stmt_close | 0 |
    | Com_stmt_execute | 0 |
    | Com_stmt_fetch | 0 |
    | Com_stmt_prepare | 0 |
    | Com_stmt_reprepare | 0 |
    | Com_stmt_reset | 0 |
    | Com_stmt_send_long_data | 0 |
    | Com_truncate | 0 |
    | Com_uninstall_plugin | 0 |
    | Com_unlock_tables | 179 |
    | Com_update | 143518 |
    | Com_update_multi | 227 |
    | Com_xa_commit | 0 |
    | Com_xa_end | 0 |
    | Com_xa_prepare | 0 |
    | Com_xa_recover | 0 |
    | Com_xa_rollback | 0 |
    | Com_xa_start | 0 |
    | Compression | OFF |
    | Connections | 266996 |
    | Created_tmp_disk_tables | 1083233 |
    | Created_tmp_files | 15 |
    | Created_tmp_tables | 1958486 |
    | Delayed_errors | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 1081 |
    | Flush_commands | 1 |
    | Handler_commit | 0 |
    | Handler_delete | 1676 |
    | Handler_discover | 0 |
    | Handler_prepare | 0 |
    | Handler_read_first | 102318 |
    | Handler_read_key | 927235815 |
    | Handler_read_next | 4255866310 |
    | Handler_read_prev | 0 |
    | Handler_read_rnd | 414342774 |
    | Handler_read_rnd_next | 1901937748 |
    | Handler_rollback | 0 |
    | Handler_savepoint | 0 |
    | Handler_savepoint_rollback | 0 |
    | Handler_update | 391714 |
    | Handler_write | 195728785 |
    | Innodb_buffer_pool_pages_data | 23 |
    | Innodb_buffer_pool_pages_dirty | 0 |
    | Innodb_buffer_pool_pages_flushed | 0 |
    | Innodb_buffer_pool_pages_free | 489 |
    | Innodb_buffer_pool_pages_misc | 0 |
    | Innodb_buffer_pool_pages_total | 512 |
    | Innodb_buffer_pool_read_ahead_rnd | 1 |
    | Innodb_buffer_pool_read_ahead_seq | 0 |
    | Innodb_buffer_pool_read_requests | 17977 |
    | Innodb_buffer_pool_reads | 16 |
    | Innodb_buffer_pool_wait_free | 0 |
    | Innodb_buffer_pool_write_requests | 0 |
    | Innodb_data_fsyncs | 3 |
    | Innodb_data_pending_fsyncs | 0 |
    | Innodb_data_pending_reads | 0 |
    | Innodb_data_pending_writes | 0 |
    | Innodb_data_read | 2560000 |
    | Innodb_data_reads | 29 |
    | Innodb_data_writes | 3 |
    | Innodb_data_written | 1536 |
    | Innodb_dblwr_pages_written | 0 |
    | Innodb_dblwr_writes | 0 |
    | Innodb_log_waits | 0 |
    | Innodb_log_write_requests | 0 |
    | Innodb_log_writes | 1 |
    | Innodb_os_log_fsyncs | 3 |
    | Innodb_os_log_pending_fsyncs | 0 |
    | Innodb_os_log_pending_writes | 0 |
    | Innodb_os_log_written | 512 |
    | Innodb_page_size | 16384 |
    | Innodb_pages_created | 0 |
    | Innodb_pages_read | 23 |
    | Innodb_pages_written | 0 |
    | Innodb_row_lock_current_waits | 0 |
    | Innodb_row_lock_time | 0 |
    | Innodb_row_lock_time_avg | 0 |
    | Innodb_row_lock_time_max | 0 |
    | Innodb_row_lock_waits | 0 |
    | Innodb_rows_deleted | 0 |
    | Innodb_rows_inserted | 0 |
    | Innodb_rows_read | 0 |
    | Innodb_rows_updated | 0 |
    | Key_blocks_not_flushed | 0 |
    | Key_blocks_unused | 24657 |
    | Key_blocks_used | 12596 |
    | Key_read_requests | 2635589249 |
    | Key_reads | 96562 |
    | Key_write_requests | 743717 |
    | Key_writes | 212112 |
    | Last_query_cost | 0.000000 |
    | Max_used_connections | 78 |
    | Not_flushed_delayed_rows | 0 |
    | Open_files | 718 |
    | Open_streams | 0 |
    | Open_table_definitions | 185 |
    | Open_tables | 512 |
    | Opened_files | 4338178 |
    | Opened_table_definitions | 429 |
    | Opened_tables | 3225 |
    | Prepared_stmt_count | 0 |
    | Qcache_free_blocks | 2743 |
    | Qcache_free_memory | 14216576 |
    | Qcache_hits | 51874167 |
    | Qcache_inserts | 602539 |
    | Qcache_lowmem_prunes | 69589 |
    | Qcache_not_cached | 2891614 |
    | Qcache_queries_in_cache | 10214 |
    | Qcache_total_blocks | 23356 |
    | Queries | 56583919 |
    | Questions | 56583919 |
    | Rpl_status | NULL |
    | Select_full_join | 1544999 |
    | Select_full_range_join | 0 |
    | Select_range | 1098112 |
    | Select_range_check | 0 |
    | Select_scan | 633812 |
    | Slave_open_temp_tables | 0 |
    | Slave_retried_transactions | 0 |
    | Slave_running | OFF |
    | Slow_launch_threads | 0 |
    | Slow_queries | 16000 |
    | Sort_merge_passes | 5 |
    | Sort_range | 560965 |
    | Sort_rows | 482700295 |
    | Sort_scan | 1184962 |
    | Ssl_accept_renegotiates | 0 |
    | Ssl_accepts | 0 |
    | Ssl_callback_cache_hits | 0 |
    | Ssl_cipher | |
    | Ssl_cipher_list | |
    | Ssl_client_connects | 0 |
    | Ssl_connect_renegotiates | 0 |
    | Ssl_ctx_verify_depth | 0 |
    | Ssl_ctx_verify_mode | 0 |
    | Ssl_default_timeout | 0 |
    | Ssl_finished_accepts | 0 |
    | Ssl_finished_connects | 0 |
    | Ssl_session_cache_hits | 0 |
    | Ssl_session_cache_misses | 0 |
    | Ssl_session_cache_mode | NONE |
    | Ssl_session_cache_overflows | 0 |
    | Ssl_session_cache_size | 0 |
    | Ssl_session_cache_timeouts | 0 |
    | Ssl_sessions_reused | 0 |
    | Ssl_used_session_cache_entries | 0 |
    | Ssl_verify_depth | 0 |
    | Ssl_verify_mode | 0 |
    | Ssl_version | |
    | Table_locks_immediate | 8976145 |
    | Table_locks_waited | 51786 |
    | Tc_log_max_pages_used | 0 |
    | Tc_log_page_size | 0 |
    | Tc_log_page_waits | 0 |
    | Threads_cached | 34 |
    | Threads_connected | 44 |
    | Threads_created | 78 |
    | Threads_running | 44 |
    | Uptime | 201588 |
    | Uptime_since_flush_status | 201588 |
    +-----------------------------------+--------------+
    +--------+--------------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +--------+--------------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | 266786 | Omlan_manar | localhost | Omlan_manar | Query | 62 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266801 | Omlan_manar | localhost | Omlan_manar | Query | 46 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266821 | Omlan_manar | localhost | Omlan_manar | Query | 53 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266857 | Omlan_manar | localhost | Omlan_manar | Query | 62 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266858 | Omlan_manar | localhost | Omlan_manar | Query | 63 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266859 | Omlan_manar | localhost | Omlan_manar | Query | 62 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266861 | Omlan_manar | localhost | Omlan_manar | Query | 62 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266862 | Omlan_manar | localhost | Omlan_manar | Query | 62 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266863 | Omlan_manar | localhost | Omlan_manar | Query | 63 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266869 | Omlan_manar | localhost | Omlan_manar | Query | 62 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266873 | Omlan_manar | localhost | Omlan_manar | Query | 63 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266876 | Omlan_manar | localhost | Omlan_manar | Query | 63 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266878 | Omlan_manar | localhost | Omlan_manar | Query | 62 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266879 | Omlan_manar | localhost | Omlan_manar | Query | 62 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266882 | Omlan_manar | localhost | Omlan_manar | Query | 62 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266888 | Omlan_manar | localhost | Omlan_manar | Query | 62 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266890 | Omlan_manar | localhost | Omlan_manar | Query | 63 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266901 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | SELECT COUNT(`T1`.`ID`) AS `Count` FROM `tu_listings` AS `T1` LEFT JOIN `tu_listing_plans` AS `T2` O |
    | 266902 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | SELECT COUNT(`T1`.`ID`) AS `Count` FROM `tu_listings` AS `T1` LEFT JOIN `tu_listing_plans` AS `T2` O |
    | 266903 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | SELECT COUNT(`T1`.`ID`) AS `Count` FROM `tu_listings` AS `T1` LEFT JOIN `tu_listing_plans` AS `T2` O |
    | 266904 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | SELECT SQL_CALC_FOUND_ROWS DISTINCT SUBSTRING_INDEX(GROUP_CONCAT(DISTINCT `T6`.`Thumbnail` ORDER BY |
    | 266905 | Omlan_manar | localhost | Omlan_manar | Query | 62 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266906 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | SELECT SQL_CALC_FOUND_ROWS DISTINCT SUBSTRING_INDEX(GROUP_CONCAT(DISTINCT `T6`.`Thumbnail` ORDER BY |
    | 266909 | Omlan_manar | localhost | Omlan_manar | Query | 62 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS `T1`.*, `T3`.`Path` AS `Path`, `T3`.`Type`, IF(UNIX_TIMESTAMP(DATE_ADD(`T |
    | 266912 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | SELECT COUNT(`T1`.`ID`) AS `Count` FROM `tu_listings` AS `T1` LEFT JOIN `tu_listing_plans` AS `T2` O |
    | 266925 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | SELECT COUNT(`T1`.`ID`) AS `Count` FROM `tu_listings` AS `T1` LEFT JOIN `tu_listing_plans` AS `T2` O |
    | 266930 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | SELECT SQL_CALC_FOUND_ROWS DISTINCT SUBSTRING_INDEX(GROUP_CONCAT(DISTINCT `T6`.`Thumbnail` ORDER BY |
    | 266932 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | SELECT SQL_CALC_FOUND_ROWS DISTINCT SUBSTRING_INDEX(GROUP_CONCAT(DISTINCT `T6`.`Thumbnail` ORDER BY |
    | 266933 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266934 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266935 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266936 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266937 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266938 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266939 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266940 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266941 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266942 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266943 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | SELECT COUNT(`T1`.`ID`) AS `Count` FROM `tu_listings` AS `T1` LEFT JOIN `tu_listing_plans` AS `T2` O |
    | 266944 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266945 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266946 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266947 | Omlan_manar | localhost | Omlan_manar | Query | 26 | Locked | UPDATE `tu_listings` SET `Last_show` = NOW() WHERE `ID` = '1181' |
    | 266995 | root | localhost | | Query | 0 | | show processlist |
    +--------+--------------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    
    ----------------------------
    INNODB Status
    ----------------------------
    *************************** 1. row ***************************
      Type: InnoDB
      Name: 
    Status: 
    =====================================
    130214  5:28:23 INNODB MONITOR OUTPUT
    =====================================
    Per second averages calculated from the last 44 seconds
    ----------
    SEMAPHORES
    ----------
    OS WAIT ARRAY INFO: reservation count 6, signal count 6
    Mutex spin waits 0, rounds 60, OS waits 3
    RW-shared spins 4, OS waits 2; RW-excl spins 1, OS waits 1
    ------------
    TRANSACTIONS
    ------------
    Trx id counter 0 6400
    Purge done for trx's n:o < 0 4371 undo n:o < 0 0
    History list length 3
    LIST OF TRANSACTIONS FOR EACH SESSION:
    ---TRANSACTION 0 0, not started, process no 18051, OS thread id 2961869680
    MySQL thread id 266996, query id 56583923 localhost root
    show engine innodb status
    --------
    FILE I/O
    --------
    I/O thread 0 state: waiting for i/o request (insert buffer thread)
    I/O thread 1 state: waiting for i/o request (log thread)
    I/O thread 2 state: waiting for i/o request (read thread)
    I/O thread 3 state: waiting for i/o request (write thread)
    Pending normal aio reads: 0, aio writes: 0,
     ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
    Pending flushes (fsync) log: 0; buffer pool: 0
    29 OS file reads, 3 OS file writes, 3 OS fsyncs
    0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
    -------------------------------------
    INSERT BUFFER AND ADAPTIVE HASH INDEX
    -------------------------------------
    Ibuf: size 1, free list len 0, seg size 2,
    0 inserts, 0 merged recs, 0 merges
    Hash table size 34679, node heap has 0 buffer(s)
    0.00 hash searches/s, 0.55 non-hash searches/s
    ---
    LOG
    ---
    Log sequence number 0 83625
    Log flushed up to   0 83625
    Last checkpoint at  0 83625
    0 pending log writes, 0 pending chkp writes
    8 log i/o's done, 0.00 log i/o's/second
    ----------------------
    BUFFER POOL AND MEMORY
    ----------------------
    Total memory allocated 17575460; in additional pool allocated 874112
    Dictionary memory allocated 28912
    Buffer pool size   512
    Free buffers       489
    Database pages     23
    Modified db pages  0
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages read 23, created 0, written 0
    0.00 reads/s, 0.00 creates/s, 0.00 writes/s
    Buffer pool hit rate 1000 / 1000
    --------------
    ROW OPERATIONS
    --------------
    0 queries inside InnoDB, 0 queries in queue
    1 read views open inside InnoDB
    Main thread process no. 18051, id 2915887984, state: waiting for server activity
    Number of rows inserted 0, updated 0, deleted 0, read 0
    0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
    ----------------------------
    END OF INNODB MONITOR OUTPUT
    ============================
    
    
    ----------------------------
    MySQL Error Log
    ----------------------------
    
    or, the table contains indexes that this version of the engine
    doesn't support.
    See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
    how you can resolve the problem.
    
    130214  5:28:23 [ERROR] Cannot find or open table roundcube/users from
    the internal data dictionary of InnoDB though the .frm file for the
    table exists. Maybe you have deleted and recreated InnoDB data
    files but have forgotten to delete the corresponding .frm files
    of InnoDB tables, or you have moved .frm files to another database?
    or, the table contains indexes that this version of the engine
    doesn't support.
    See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
    how you can resolve the problem.
    
    
    Report Complete:
    Thu Feb 14 05:28:24 EET 2013
    ----------------------------
    
    I analyzed the Traffic hits on the server in the last 5 hours today 14/Feb/2013 and also for yesterday 13/Feb/2013. I don't know how come I have all these site requests and Google Analytics is only reporting 1000 visitors a day!. Am I having a bot attack ?! I have no clue.

    Code:
    root@host [~]# sh traff.sh mydomain.com 14/Feb/2013
    Date: 14/Feb/2013, hour: 00, site requests: 12003
    Date: 14/Feb/2013, hour: 01, site requests: 9189
    Date: 14/Feb/2013, hour: 02, site requests: 22492
    Date: 14/Feb/2013, hour: 03, site requests: 4907
    Date: 14/Feb/2013, hour: 04, site requests: 6259
    Date: 14/Feb/2013, hour: 05, site requests: 6266
    Date: 14/Feb/2013, hour: 06, site requests: 0
    Date: 14/Feb/2013, hour: 07, site requests: 0
    Date: 14/Feb/2013, hour: 08, site requests: 0
    Date: 14/Feb/2013, hour: 09, site requests: 0
    Date: 14/Feb/2013, hour: 10, site requests: 0
    Date: 14/Feb/2013, hour: 11, site requests: 0
    Date: 14/Feb/2013, hour: 12, site requests: 0
    Date: 14/Feb/2013, hour: 13, site requests: 0
    Date: 14/Feb/2013, hour: 14, site requests: 0
    Date: 14/Feb/2013, hour: 15, site requests: 0
    Date: 14/Feb/2013, hour: 16, site requests: 0
    Date: 14/Feb/2013, hour: 17, site requests: 0
    Date: 14/Feb/2013, hour: 18, site requests: 0
    Date: 14/Feb/2013, hour: 19, site requests: 0
    Date: 14/Feb/2013, hour: 20, site requests: 0
    Date: 14/Feb/2013, hour: 21, site requests: 0
    Date: 14/Feb/2013, hour: 22, site requests: 0
    Date: 14/Feb/2013, hour: 23, site requests: 0
    
    
    root@host [~]# sh traff.sh mydomain.com 13/Feb/2013
    Date: 13/Feb/2013, hour: 00, site requests: 8353
    Date: 13/Feb/2013, hour: 01, site requests: 7713
    Date: 13/Feb/2013, hour: 02, site requests: 6105
    Date: 13/Feb/2013, hour: 03, site requests: 4760
    Date: 13/Feb/2013, hour: 04, site requests: 5086
    Date: 13/Feb/2013, hour: 05, site requests: 5791
    Date: 13/Feb/2013, hour: 06, site requests: 4916
    Date: 13/Feb/2013, hour: 07, site requests: 6550
    Date: 13/Feb/2013, hour: 08, site requests: 7799
    Date: 13/Feb/2013, hour: 09, site requests: 7901
    Date: 13/Feb/2013, hour: 10, site requests: 9278
    Date: 13/Feb/2013, hour: 11, site requests: 9702
    Date: 13/Feb/2013, hour: 12, site requests: 11626
    Date: 13/Feb/2013, hour: 13, site requests: 13297
    Date: 13/Feb/2013, hour: 14, site requests: 12353
    Date: 13/Feb/2013, hour: 15, site requests: 11638
    Date: 13/Feb/2013, hour: 16, site requests: 15877
    Date: 13/Feb/2013, hour: 17, site requests: 14226
    Date: 13/Feb/2013, hour: 18, site requests: 15512
    Date: 13/Feb/2013, hour: 19, site requests: 13842
    Date: 13/Feb/2013, hour: 20, site requests: 16470
    Date: 13/Feb/2013, hour: 21, site requests: 14402
    Date: 13/Feb/2013, hour: 22, site requests: 10655
    Date: 13/Feb/2013, hour: 23, site requests: 11265
    
    Please help!
     
  3. srpurdy

    srpurdy Well-Known Member

    Joined:
    Jun 1, 2011
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Well first if you only have 5-10 members on.
    But your using 78/500 connections. You may look into not using pconnect in your mysql configuration for the website itself. So in the php code or whatever coding language your using connect to mysql without pconnect so your not wasting connections. This will save a lot of ram to start.

    You also should make these changes to mysql. my.cnf
    max_connections=150
    join_buffer_size=512K
    query_cache_size=96M
    query_cache_limit=90M
    query_cache_type=1
    query_cache_min_res_unit=4K
    key_buffer_size=240M

    After that. Go through all your tables in mysql, and add indexes for tables that are relational to other tables. Because you have 1.4 million joins without indexes. This means mysql has to do large amounts of table scans to get the information it needs. You can keep putting join_buffer_size higher. But the problem with this is it uses a ton of memory, and is actually slower than having a properly designed database. But at the very least start with the above. key_buffer_size may need to be bigger after you add indexes.

    Basically all where,order_by and joins should have indexes on both fields that are in the clause.

    Then let mysql run for at least 24 hours or longer, and post a new mysqltuner report.
     
    #3 srpurdy, Feb 14, 2013
    Last edited: Feb 14, 2013
  4. mamdeen78

    mamdeen78 Registered

    Joined:
    Feb 13, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hello Srpurdy,

    Thanks for your help. Much appreciated. I moved to a new dedicated server to improve the performance.

    Server Specifications :

    Intel® Xeon® E3-1245 Quad-Core
    16 GB DDR 3 RAM ECC
    2 x 3 TB SATA 6 Gb/s Enterprise HDD; 7200 rpm (Software-RAID 1)

    PHP 5.4.11 , CGI/FastCGI , Nginx as proxy , MySQL version 5.1.66-cll

    Current My.cnf settings :
    Code:
    [mysqld]
    local-infile=0
    max_connections=150
    join_buffer_size=1024K
    query_cache_size=96M
    query_cache_limit=90M
    query_cache_type=1
    query_cache_min_res_unit=4K
    key_buffer_size=240M
    thread_cache_size=8M
    table_definition_cache=512
    table_open_cache=512
    tmp_table_size=128M
    max_heap_table_size=128M
    interactive_timeout=120
    wait_timeout=120
    long_query_time = 1
    #general_log    
    slow_query_log

    Mysqltuner output :

    Code:
    root@host:~# mysqltuner.pl
    
     >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Run with '--help' for additional options and output filtering
    
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.1.68-cll
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
    [--] Data in MyISAM tables: 252M (Tables: 201)
    [--] Data in InnoDB tables: 208K (Tables: 13)
    [!!] Total fragmented tables: 4
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 1d 3h 21m 5s (32M q [334.641 qps], 208K conn, TX: 91B, RX: 6B)
    [--] Reads / Writes: 92% / 8%
    [--] Total buffers: 474.0M global + 3.1M per thread (150 max threads)
    [OK] Maximum possible memory usage: 942.7M (5% of installed RAM)
    [OK] Slow queries: 0% (2K/32M)
    [OK] Highest usage of available connections: 66% (100/150)
    [OK] Key buffer size / total MyISAM indexes: 240.0M/233.8M
    [OK] Key buffer hit rate: 100.0% (1B cached / 263K reads)
    [OK] Query cache efficiency: 93.8% (29M cached / 31M selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (84 temp sorts / 968K sorts)
    [!!] Joins performed without indexes: 804025
    [!!] Temporary tables created on disk: 36% (686K on disk / 1M total)
    [OK] Thread cache hit rate: 99% (100 created / 208K connections)
    [!!] Table cache hit rate: 14% (398 open / 2K opened)
    [OK] Open file limit used: 14% (610/4K)
    [OK] Table locks acquired immediately: 98% (5M immediate / 5M locks)
    [OK] InnoDB data size / buffer pool: 208.0K/8.0M
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        Adjust your join queries to always utilize indexes
        When making adjustments, make tmp_table_size/max_heap_table_size equal
        Reduce your SELECT DISTINCT queries without LIMIT clauses
        Increase table_cache gradually to avoid file descriptor limits
    Variables to adjust:
        join_buffer_size (> 512.0K, or always use indexes with joins)
        tmp_table_size (> 128M)
        max_heap_table_size (> 128M)
        table_cache (> 512)
    
    I'm planing to make a huge advertisement campaigns and I want to optimize the site to handle high traffic ( about 50 k visitor per day ).

    I will add the indexes to the database. What else should I optimize in the my.cnf settings ?

    Thanks for your help
     
  5. mamdeen78

    mamdeen78 Registered

    Joined:
    Feb 13, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    If anybody see this. I'm willing to pay for a Mysql optimization pro to tweak my settings for optimum performance. PM me if you are interested.
     
  6. arunsv84

    arunsv84 Well-Known Member

    Joined:
    Oct 20, 2008
    Messages:
    373
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    As your server is having enough memory, you can safely increase the parameters. You can always send pm to me for assistance.

    Cheers!!!
     
Loading...

Share This Page