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.

Help with optimizing MySQL - already ran MySQlTuner

Discussion in 'Workarounds and Optimization' started by cfhoagland, May 23, 2014.

  1. cfhoagland

    cfhoagland Registered

    Joined:
    May 23, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    Forgive me for being a non-admin kinda guy - I am the hardware person. But we have a server running an i7 - 24 Gigs Ram and 10 Tera in HD. Its a great machine hardware wise - BUT... I do not know how to optimize the SQL

    I have the generic my.cnf and its the one that comes when installing the system, now we are trying to speed this up as the load seems to spike a lot and again hardware wise this machine can handle what we have on the server. So here goes my FIRST attempt on the forum and asking for help.

    Code:
    [mysqld]
    
    local-infile=0
    log-warnings=2
    symbolic-links=0
    query_cache_size=32m
    innodb_file_per_table=1
    open_files_limit=31936
    [mysqld_safe]
    
    log-error=/var/log/mysqld.log
    
    And this it what mysqltuner says

    Code:
    [OK] Currently running supported MySQL version 5.5.36-cll
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
    [--] Data in MyISAM tables: 32G (Tables: 4151)
    [--] Data in InnoDB tables: 245M (Tables: 1667)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 498K (Tables: 53)
    [!!] Total fragmented tables: 40
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 1d 6h 29m 8s (5M q [47.818 qps], 149K conn, TX: 9B, RX: 710M)
    [--] Reads / Writes: 59% / 41%
    [--] Total buffers: 200.0M global + 2.8M per thread (151 max threads)
    [OK] Maximum possible memory usage: 615.2M (2% of installed RAM)
    [OK] Slow queries: 0% (43/5M)
    [OK] Highest usage of available connections: 24% (37/151)
    [OK] Key buffer size / total MyISAM indexes: 8.0M/1.7G
    [OK] Key buffer hit rate: 99.8% (2B cached / 4M reads)
    [OK] Query cache efficiency: 80.0% (3M cached / 4M selects)
    [!!] Query cache prunes per day: 231057
    [OK] Sorts requiring temporary tables: 0% (276 temp sorts / 176K sorts)
    [!!] Joins performed without indexes: 1445
    [!!] Temporary tables created on disk: 26% (54K on disk / 202K total)
    [!!] Thread cache is disabled
    [!!] Table cache hit rate: 0% (400 open / 4M opened)
    [OK] Open file limit used: 2% (674/31K)
    [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)
    [!!] InnoDB  buffer pool / data size: 128.0M/245.6M
    [OK] InnoDB log waits: 0
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        Enable the slow query log to troubleshoot bad queries
        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
        Set thread_cache_size to 4 as a starting value
        Increase table_cache gradually to avoid file descriptor limits
        Read this before increasing table_cache over 64: http://bit.ly/1mi7c4C
    Variables to adjust:
        query_cache_size (> 32M)
        join_buffer_size (> 128.0K, or always use indexes with joins)
        tmp_table_size (> 16M)
        max_heap_table_size (> 16M)
        thread_cache_size (start at 4)
        table_cache (> 400)
        innodb_buffer_pool_size (>= 245M)
    
    
     
    Any help as to what I need my.cnf to look like.

    THANKS a MILLION to anyone who can help!
     
  2. gopkris2005

    gopkris2005 Well-Known Member

    Joined:
    Jan 9, 2007
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    INDIA
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi,

    Its depends on your RAM size. You should optimize these values in your /etc/my.cnf file and then run mysqltuner again.

    query_cache_size (> 32M)
    join_buffer_size (> 128.0K, or always use indexes with joins)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    thread_cache_size (start at 4)
    table_cache (> 400)
    innodb_buffer_pool_size (>= 245M)


     
  3. cfhoagland

    cfhoagland Registered

    Joined:
    May 23, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider

    I have 24 Gigs of RAM - its an i7 960 Processor with 10 terabytes in HD.. The question I guess is I do not know what my.cnf should look like - I have seen others post their output and got a reply as to what the my.cnf should look like.

    Here is the recent MySQLTuner output
    Code:
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.2 mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Sat May 24 22:01:17 EDT 2014
    
    -------------------------------------------------
    mysqltuner output
    -------------------------------------------------
    mysqltuner.pl [found]
    
     >>  MySQLTuner 1.3.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
    [OK] Currently running supported MySQL version 5.5.36-cll
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
    [--] Data in MyISAM tables: 32G (Tables: 4151)
    [--] Data in InnoDB tables: 252M (Tables: 1667)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 498K (Tables: 53)
    [!!] Total fragmented tables: 81
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 8h 1m 58s (1M q [62.630 qps], 39K conn, TX: 2B, RX: 231M)
    [--] Reads / Writes: 41% / 59%
    [--] Total buffers: 200.0M global + 2.8M per thread (151 max threads)
    [OK] Maximum possible memory usage: 615.2M (2% of installed RAM)
    [OK] Slow queries: 0% (4/1M)
    [OK] Highest usage of available connections: 19% (30/151)
    [OK] Key buffer size / total MyISAM indexes: 8.0M/1.7G
    [OK] Key buffer hit rate: 99.9% (727M cached / 412K reads)
    [OK] Query cache efficiency: 83.5% (1M cached / 1M selects)
    [!!] Query cache prunes per day: 230090
    [OK] Sorts requiring temporary tables: 0% (38 temp sorts / 69K sorts)
    [!!] Joins performed without indexes: 309
    [!!] Temporary tables created on disk: 27% (20K on disk / 73K total)
    [!!] Thread cache is disabled
    [!!] Table cache hit rate: 0% (400 open / 1M opened)
    [OK] Open file limit used: 2% (727/31K)
    [OK] Table locks acquired immediately: 99% (592K immediate / 594K locks)
    [!!] InnoDB  buffer pool / data size: 128.0M/252.9M
    [OK] InnoDB log waits: 0
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        MySQL started within last 24 hours - recommendations may be inaccurate
        Enable the slow query log to troubleshoot bad queries
        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
        Set thread_cache_size to 4 as a starting value
        Increase table_cache gradually to avoid file descriptor limits
        Read this before increasing table_cache over 64: http://bit.ly/1mi7c4C
    Variables to adjust:
        query_cache_size (> 32M)
        join_buffer_size (> 128.0K, or always use indexes with joins)
        tmp_table_size (> 16M)
        max_heap_table_size (> 16M)
        thread_cache_size (start at 4)
        table_cache (> 400)
        innodb_buffer_pool_size (>= 252M)
    
    
    And here is the MySQLMyMonLite output:

    Code:
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.2 mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Sat May 24 21:51:25 EDT 2014
    
    ----------------------------
    MySQL Uptime:
    ----------------------------
    MySQL server was started 2014-05-24 13:59:19
    Uptime: 7 hours 52 min 6 sec  
    Uptime 28326
    Uptime_since_flush_status 28326
    
    Max Used Connections:      30/151 (19.87%)
    Key Buffer Used:           6.54M/8.00M (81.76%)
    Current Key Buffer Usage:  4.65M (58.18%)
    InnoDB Buffer Pool:        128.00M/128.00M (100.00%)
    Query Cache:               24.65M/32.00M (77.03%)
    Table Locks Waited:        2.35k Rate: 0.1/s (0.40%)
    --------------------
    Query Cache Limit (bytes): 1048576
    Query Cache Min Unit (bytes): 4096
    Query Cache Size (bytes): 33554432
    Query Cache Free Mem (bytes): 7707184
    Query Cache Used Mem (bytes): 25847248
    Queries in Query Cache: 1
    Query Cache Avg Size (bytes): 25847248
    
    ----------------------------
    Hardware Info:
    ----------------------------
    Processors physical = 1, cores = 4, virtual = 8, hyperthreading = yes
          8  2800.005
          8  Intel(R) Core(TM) i7 CPU         960  @ 3.20GHz
          8  8192 KB
    
    
    ----------------------------
    TOP stats
    ----------------------------
    
    Linux 3.2.58-68.art.x86_64 ((yourserverhostname)) 	05/24/2014 	_x86_64_	(8 CPU)
    
    09:51:26 PM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    09:51:28 PM  all    5.90    0.00    0.82    0.00    0.00    0.06    0.00    0.00   93.22
    09:51:28 PM    0    3.09    0.00    0.52    0.00    0.00    0.00    0.00    0.00   96.39
    09:51:28 PM    1    0.00    0.00    0.50    0.00    0.00    0.00    0.00    0.00   99.50
    09:51:28 PM    2   36.00    0.00    3.50    0.00    0.00    0.00    0.00    0.00   60.50
    09:51:28 PM    3    7.00    0.00    0.50    0.00    0.00    0.00    0.00    0.00   92.50
    09:51:28 PM    4    0.50    0.00    0.50    0.00    0.00    0.00    0.00    0.00   99.00
    09:51:28 PM    5    0.50    0.00    0.50    0.00    0.00    0.00    0.00    0.00   98.99
    09:51:28 PM    6    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    09:51:28 PM    7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    09:51:28 PM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    09:51:30 PM  all    6.47    0.00    1.95    6.28    0.00    0.69    0.00    0.00   84.61
    09:51:30 PM    0   10.77    0.00    1.54   48.72    0.00    1.03    0.00    0.00   37.95
    09:51:30 PM    1    4.04    0.00    2.02    1.01    0.00    1.01    0.00    0.00   91.92
    09:51:30 PM    2   22.61    0.00    2.01    0.00    0.00    0.50    0.00    0.00   74.87
    09:51:30 PM    3    7.50    0.00    4.50    1.00    0.00    1.50    0.00    0.00   85.50
    09:51:30 PM    4    0.00    0.00    1.51    0.00    0.00    0.00    0.00    0.00   98.49
    09:51:30 PM    5    3.50    0.00    0.50    0.00    0.00    0.00    0.00    0.00   96.00
    09:51:30 PM    6    2.51    0.00    2.51    0.00    0.00    1.51    0.00    0.00   93.47
    09:51:30 PM    7    0.50    0.00    1.00    0.00    0.00    0.00    0.00    0.00   98.51
    
    Average:     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    Average:     all    6.18    0.00    1.38    3.14    0.00    0.38    0.00    0.00   88.92
    Average:       0    6.94    0.00    1.03   24.42    0.00    0.51    0.00    0.00   67.10
    Average:       1    2.02    0.00    1.26    0.50    0.00    0.50    0.00    0.00   95.72
    Average:       2   29.32    0.00    2.76    0.00    0.00    0.25    0.00    0.00   67.67
    Average:       3    7.25    0.00    2.50    0.50    0.00    0.75    0.00    0.00   89.00
    Average:       4    0.25    0.00    1.00    0.00    0.00    0.00    0.00    0.00   98.75
    Average:       5    2.01    0.00    0.50    0.00    0.00    0.00    0.00    0.00   97.49
    Average:       6    1.25    0.00    1.25    0.00    0.00    0.75    0.00    0.00   96.74
    Average:       7    0.25    0.00    0.50    0.00    0.00    0.00    0.00    0.00   99.25
    
    top - 21:51:31 up  7:55,  1 user,  load average: 0.73, 0.56, 0.47
    Tasks: 246 total,   1 running, 245 sleeping,   0 stopped,   0 zombie
    Cpu(s):  3.7%us,  1.5%sy,  0.4%ni, 92.3%id,  1.8%wa,  0.0%hi,  0.2%si,  0.0%st
    Mem:  24611332k total, 14951924k used,  9659408k free,  1012032k buffers
    Swap: 61849596k total,        0k used, 61849596k free,  8976252k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND            
    25248 useruser  20   0  289m  37m 9416 S 15.7  0.2   0:01.99 php                
    23349 nobody    20   0  160m  84m 3976 S  5.9  0.4   0:06.25 httpd              
     4573 mysql     20   0 2727m 463m 7224 S  2.0  1.9  98:20.06 mysqld             
    11370 root      20   0  104m 2376 2136 S  2.0  0.0   0:01.10 whmsonicsrv        
    23336 prosexvi  20   0  269m  15m 9560 S  2.0  0.1   0:01.86 php                
        1 root      20   0 19280 1536 1264 S  0.0  0.0   0:01.31 init               
        2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthreadd           
        3 root      20   0     0    0    0 S  0.0  0.0   0:00.73 ksoftirqd/0        
        6 root      RT   0     0    0    0 S  0.0  0.0   0:00.13 migration/0        
        7 root      RT   0     0    0    0 S  0.0  0.0   0:02.09 watchdog/0         
        8 root      RT   0     0    0    0 S  0.0  0.0   0:00.03 migration/1        
        9 root      20   0     0    0    0 S  0.0  0.0   0:00.78 kworker/1:0        
       10 root      20   0     0    0    0 S  0.0  0.0   0:00.37 ksoftirqd/1        
       12 root      RT   0     0    0    0 S  0.0  0.0   0:00.12 watchdog/1         
       13 root      RT   0     0    0    0 S  0.0  0.0   0:00.03 migration/2        
       15 root      20   0     0    0    0 S  0.0  0.0   0:00.30 ksoftirqd/2        
       16 root      RT   0     0    0    0 S  0.0  0.0   0:00.11 watchdog/2         
       17 root      RT   0     0    0    0 S  0.0  0.0   0:00.04 migration/3        
       19 root      20   0     0    0    0 S  0.0  0.0   0:00.26 ksoftirqd/3        
       20 root      RT   0     0    0    0 S  0.0  0.0   0:00.10 watchdog/3         
       21 root      RT   0     0    0    0 S  0.0  0.0   0:00.19 migration/4        
       23 root      20   0     0    0    0 S  0.0  0.0   0:00.39 ksoftirqd/4        
       24 root      RT   0     0    0    0 S  0.0  0.0   0:00.10 watchdog/4         
       25 root      RT   0     0    0    0 S  0.0  0.0   0:00.24 migration/5        
       27 root      20   0     0    0    0 S  0.0  0.0   0:00.31 ksoftirqd/5        
       28 root      RT   0     0    0    0 S  0.0  0.0   0:00.10 watchdog/5         
       29 root      RT   0     0    0    0 S  0.0  0.0   0:00.24 migration/6        
       30 root      20   0     0    0    0 S  0.0  0.0   0:00.17 kworker/6:0        
       31 root      20   0     0    0    0 S  0.0  0.0   0:00.30 ksoftirqd/6        
       32 root      RT   0     0    0    0 S  0.0  0.0   0:00.09 watchdog/6         
       33 root      RT   0     0    0    0 S  0.0  0.0   0:00.31 migration/7        
       34 root      20   0     0    0    0 S  0.0  0.0   0:00.02 kworker/7:0        
       35 root      20   0     0    0    0 S  0.0  0.0   0:00.31 ksoftirqd/7        
       36 root      RT   0     0    0    0 S  0.0  0.0   0:00.11 watchdog/7         
       37 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 cpuset             
       38 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 khelper            
       39 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kdevtmpfs          
       40 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 netns              
       41 root      20   0     0    0    0 S  0.0  0.0   0:00.07 sync_supers        
       42 root      20   0     0    0    0 S  0.0  0.0   0:00.00 bdi-default        
       43 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kintegrityd        
       44 root       0 -20     0    0    0 S  0.0  0.0   0:00.35 kblockd            
       45 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ata_sff            
       46 root      20   0     0    0    0 S  0.0  0.0   0:00.00 khubd              
       47 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 md                 
       49 root      20   0     0    0    0 S  0.0  0.0   0:00.67 kworker/2:1        
       50 root      20   0     0    0    0 S  0.0  0.0   0:00.35 kworker/3:1        
       51 root      20   0     0    0    0 S  0.0  0.0   0:00.17 kworker/4:1        
       52 root      20   0     0    0    0 S  0.0  0.0   0:00.11 kworker/5:1        
       53 root      20   0     0    0    0 S  0.0  0.0   0:00.33 kworker/6:1        
       54 root      20   0     0    0    0 S  0.0  0.0   0:00.60 kworker/7:1        
       55 root      20   0     0    0    0 S  0.0  0.0   0:00.01 khungtaskd         
       56 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kswapd0            
       57 root      25   5     0    0    0 S  0.0  0.0   0:00.00 ksmd               
       58 root      39  19     0    0    0 S  0.0  0.0   0:05.83 khugepaged         
       59 root      20   0     0    0    0 S  0.0  0.0   0:00.00 fsnotify_mark      
       60 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 crypto             
       67 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kthrotld           
       69 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kpsmoused          
      127 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ttm_swap           
      185 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_0          
      186 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_1          
      187 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_2          
      188 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_3          
      189 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_4          
      190 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_5          
      191 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_6          
      192 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_7          
      196 root      20   0     0    0    0 S  0.0  0.0   0:00.25 kworker/u:5        
      197 root      20   0     0    0    0 S  0.0  0.0   0:00.59 kworker/u:6        
      201 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_8          
      202 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_9          
      215 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_10         
      216 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_11         
      217 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_12         
      218 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_13         
      288 root      20   0     0    0    0 S  0.0  0.0   0:00.40 kworker/3:2        
      321 root      20   0     0    0    0 S  0.0  0.0   0:00.26 kworker/5:2        
      335 root      20   0     0    0    0 S  0.0  0.0   0:00.59 kworker/1:2        
      337 root      20   0     0    0    0 S  0.0  0.0   0:00.28 kworker/4:2        
      346 root      20   0     0    0    0 S  0.0  0.0   0:00.84 kworker/2:2        
      416 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kdmflush           
      418 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kdmflush           
      434 root      20   0     0    0    0 S  0.0  0.0   0:06.53 jbd2/dm-0-8        
      435 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ext4-dio-unwrit    
      520 root      16  -4 10684  736  320 S  0.0  0.0   0:00.85 udevd              
      575 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 edac-poller        
      848 allnjdea  20   0  288m  36m 9300 S  0.0  0.2   0:00.66 php                
      856 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kdmflush           
      866 root      20   0     0    0    0 S  0.0  0.0   0:02.61 flush-253:0        
      876 root      20   0     0    0    0 S  0.0  0.0   0:00.44 flush-253:2        
      906 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jbd2/sdf1-8        
      907 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ext4-dio-unwrit    
      908 root      20   0     0    0    0 S  0.0  0.0   0:00.85 jbd2/dm-2-8        
      909 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ext4-dio-unwrit    
     1051 root      20   0     0    0    0 S  0.0  0.0   0:00.22 kauditd            
     1122 topsexpl  20   0  382m  34m 9596 S  0.0  0.1   0:00.44 php                
     1126 valueddi  20   0  296m  43m   9m S  0.0  0.2   0:00.41 php                
     1134 valueddi  20   0  286m  34m 9352 S  0.0  0.1   0:00.50 php                
     1172 tortix    20   0  409m  84m 7832 S  0.0  0.4   0:33.02 tortixd            
     1444 root      16  -4 91200  772  580 S  0.0  0.0   0:01.30 auditd             
     1485 mommagti  20   0  297m  45m 9416 S  0.0  0.2   0:00.61 php                
     1502 root      20   0  237m 1592  980 S  0.0  0.0   0:03.03 rsyslogd           
     1516 named     20   0  668m  31m 2428 S  0.0  0.1   0:13.40 named              
     1565 root      20   0 66656 1204  480 S  0.0  0.0   0:00.00 sshd               
     1573 root      20   0  654m 449m 5748 S  0.0  1.9   0:18.98 clamd              
     1596 root      20   0  105m 1700 1364 S  0.0  0.0   0:00.01 mysqld_safe        
     1638 mommagsh  20   0  269m  17m 9168 S  0.0  0.1   0:00.08 php                
     1831 root      20   0     0    0    0 S  0.0  0.0   0:07.05 kworker/0:1        
     1838 tortix    20   0  409m  83m 6556 S  0.0  0.3   1:18.27 tortixd            
     1859 tortix    20   0  405m  74m 2120 S  0.0  0.3   0:00.43 tortixd            
     1951 root      20   0 19656 1128  828 S  0.0  0.0   0:00.04 dovecot            
     1974 dovenull  20   0 42400 3372 2592 S  0.0  0.0   0:00.10 pop3-login         
     1975 dovenull  20   0 42272 3120 2412 S  0.0  0.0   0:00.16 imap-login         
     1976 dovecot   20   0 13356 1076  900 S  0.0  0.0   0:00.01 anvil              
     1977 root      20   0 13484 1264  940 S  0.0  0.0   0:00.02 log                
     1979 dovenull  20   0 42268 3116 2412 S  0.0  0.0   0:00.00 pop3-login         
     1980 dovenull  20   0 42272 3116 2412 S  0.0  0.0   0:00.02 imap-login         
     1981 root      20   0 16468 2036 1096 S  0.0  0.0   0:00.05 config             
     2009 mailnull  20   0 71540 2984  704 S  0.0  0.0   0:00.07 exim               
     2027 root      20   0  161m  49m 3288 S  0.0  0.2   0:04.68 /usr/local/cpan    
     2062 root      20   0  161m  47m 1120 S  0.0  0.2   0:00.01 spamd child        
     2063 root      20   0  161m  47m 1120 S  0.0  0.2   0:00.01 spamd child        
     2071 root      20   0  159m  84m 5372 S  0.0  0.4   0:05.02 httpd              
     2079 root      20   0  135m 2012 1340 S  0.0  0.0   0:00.02 pure-ftpd          
     2082 root      20   0  133m  488    0 S  0.0  0.0   0:00.00 pure-uploadscri    
     2084 root      20   0  133m 1828 1344 S  0.0  0.0   0:00.03 pure-authd         
     2110 root      20   0  404m  84m  11m S  0.0  0.3   0:01.27 tortixd            
     2122 root      20   0  114m 1360  644 S  0.0  0.0   0:00.99 crond              
     2140 root      20   0  142m 8584 1772 S  0.0  0.0   0:01.50 /usr/local/cpan    
     2155 root      20   0 21588  400  220 S  0.0  0.0   0:00.00 atd                
     2386 root      20   0 71704 8036 2584 S  0.0  0.0   0:01.57 cPhulkd - proce    
     2621 root      20   0 99124  14m 1884 S  0.0  0.1   0:04.28 cpsrvd-ssl         
     2658 root      20   0 38376 6564 1436 S  0.0  0.0   0:00.78 queueprocd - wa    
     2666 root      20   0  110m  16m  344 S  0.0  0.1   0:00.03 cpdavd - accept    
     2719 allnjsto  20   0  292m  38m   9m S  0.0  0.2   0:00.29 php                
     2725 nobody    20   0  160m  84m 3872 S  0.0  0.4   0:02.78 httpd              
     2745 allnjsto  20   0  286m  32m 9352 S  0.0  0.1   0:00.51 php                
     2754 usgeodir  20   0  300m  47m 9612 S  0.0  0.2   0:01.78 php                
     2764 usgeodir  20   0  306m  51m   9m S  0.0  0.2   0:00.38 php                
     2817 root      20   0 79344  12m 1376 S  0.0  0.1   0:01.71 tailwatchd         
     2873 root      38  18 27164 3060  768 S  0.0  0.0   0:00.03 cpanellogd - sl    
     3111 root      20   0  219m 7084 2452 S  0.0  0.0   0:00.03 watchmysql         
     3140 buyandse  20   0  277m  20m 9180 S  0.0  0.1   0:00.21 php                
     3144 buyandse  20   0  277m  22m 9180 S  0.0  0.1   0:00.13 php                
     3297 cupidspl  20   0  275m  20m 9272 S  0.0  0.1   0:01.74 php                
     3706 emogurlz  20   0  295m  42m 9852 S  0.0  0.2   0:01.71 php                
     4876 ossecm    20   0 61384 9.8m 1064 S  0.0  0.0   0:17.97 ossec-dbd          
     4881 ossecm    20   0  8820  664  308 S  0.0  0.0   0:00.19 ossec-maild        
     4911 root      20   0 15624 1088  752 S  0.0  0.0   0:00.25 ossec-execd        
     4919 ossec     20   0 17668 9768  616 S  0.0  0.0   4:07.36 ossec-analysisd    
     4925 root      20   0  6540  512  312 S  0.0  0.0   0:01.20 ossec-logcollec    
     4973 root      20   0 18380  12m  516 S  0.0  0.1   0:56.70 ossec-syscheckd    
     4977 ossec     20   0  8700  420  236 S  0.0  0.0   0:00.01 ossec-monitord     
     5107 root      20   0  4112  552  468 S  0.0  0.0   0:00.00 mingetty           
     5109 root      20   0  4108  556  476 S  0.0  0.0   0:00.00 mingetty           
     5111 root      20   0  4108  552  472 S  0.0  0.0   0:00.00 mingetty           
     5113 root      20   0  4112  556  476 S  0.0  0.0   0:00.00 mingetty           
     5115 root      20   0  4108  552  472 S  0.0  0.0   0:00.00 mingetty           
     5117 root      18  -2 10680  740  324 S  0.0  0.0   0:00.70 udevd              
     5118 root      18  -2 10680  704  288 S  0.0  0.0   0:00.00 udevd              
     5284 allnjart  20   0  269m  14m 8764 S  0.0  0.1   0:01.34 php                
     5608 allnjdin  20   0  285m  33m 9236 S  0.0  0.1   0:02.03 php                
     5799 nobody    20   0  160m  84m 3940 S  0.0  0.4   0:01.90 httpd              
     6427 root      20   0  4108  552  468 S  0.0  0.0   0:00.00 mingetty           
     6836 allnjadv  20   0  292m  38m   9m S  0.0  0.2   0:00.33 php                
     6932 allnjadv  20   0  286m  34m 9352 S  0.0  0.1   0:00.49 php                
     7532 dumbestc  20   0  268m  16m 8192 S  0.0  0.1   0:00.02 php                
     8125 root      20   0     0    0    0 S  0.0  0.0   0:03.28 kworker/0:3        
     8126 allnjcha  20   0  292m  36m   9m S  0.0  0.2   0:00.30 php                
     8168 allnjcha  20   0  286m  34m 9352 S  0.0  0.1   0:00.50 php                
     8293 root      20   0  147m 8992 1196 S  0.0  0.0   0:00.35 psmon              
     8889 nobody    20   0  160m  83m 3060 S  0.0  0.3   0:00.89 httpd              
    10582 allnjsoc  20   0  296m  44m 9372 S  0.0  0.2   0:00.57 php                
    10650 thatsoci  20   0  271m  20m 8980 S  0.0  0.1   0:00.09 php                
    10665 cutename  20   0  268m  14m 8168 S  0.0  0.1   0:00.02 php                
    10710 root      20   0  102m 4208 3196 S  0.0  0.0   0:00.12 sshd               
    10755 root      20   0  105m 1936 1516 S  0.0  0.0   0:00.02 bash               
    10798 nobody    20   0  159m  83m 2924 S  0.0  0.3   0:00.39 httpd              
    11059 allnjart  20   0  269m  16m 8764 S  0.0  0.1   0:00.17 php                
    11198 nobody    20   0  159m  83m 3056 S  0.0  0.3   0:00.23 httpd              
    12267 coolvipg  20   0  298m  44m 9.9m S  0.0  0.2   0:01.39 php                
    12291 nobody    20   0  159m  82m 2812 S  0.0  0.3   0:00.06 httpd              
    12318 nobody    20   0  159m  83m 3028 S  0.0  0.3   0:00.06 httpd              
    12594 root      20   0  104m 1980 1236 S  0.0  0.0   0:00.01 mysqlmymonlite.    
    12807 root      20   0 15080 1316  884 R  0.0  0.0   0:00.00 top                
    14980 tortix    20   0  408m  82m 6460 S  0.0  0.3   0:47.01 tortixd            
    15047 root      20   0     0    0    0 S  0.0  0.0   0:16.56 kworker/0:0        
    23328 root      20   0 80056  10m 2872 S  0.0  0.0   0:00.09 leechprotect       
    23329 nobody    20   0  159m  80m  792 S  0.0  0.3   0:00.26 httpd              
    23330 nobody    20   0  160m  83m 3180 S  0.0  0.3   0:05.39 httpd              
    23377 cupidspl  20   0  269m  19m 9272 S  0.0  0.1   0:09.73 php                
    23383 carmarke  20   0  298m  44m 9616 S  0.0  0.2   0:01.10 php                
    23394 sextubee  20   0  269m  16m 8852 S  0.0  0.1   0:00.05 php                
    23397 triplexf  20   0  283m  29m 9276 S  0.0  0.1   0:00.70 php                
    23447 googlia   20   0  275m  21m 9412 S  0.0  0.1   0:02.05 php                
    23529 allnjauc  20   0  275m  24m 9048 S  0.0  0.1   0:01.61 php                
    23571 buyandse  20   0  277m  23m 9180 S  0.0  0.1   0:01.03 php                
    23716 spectroa  20   0  269m  18m 8996 S  0.0  0.1   0:00.05 php                
    23746 allussho  20   0  294m  42m 9308 S  0.0  0.2   0:02.30 php                
    23751 adultsxx  20   0  282m  30m 9428 S  0.0  0.1   0:00.85 php                
    23781 colonyvi  20   0  285m  31m 9196 S  0.0  0.1   0:00.78 php                
    23816 studcart  20   0  306m  53m 9704 S  0.0  0.2   0:03.21 php                
    23819 spectroy  20   0  276m  23m 9848 S  0.0  0.1   0:06.10 php                
    23868 allnjwex  20   0  292m  38m  10m S  0.0  0.2   0:18.91 php                
    23991 nobody    20   0  166m  89m 3220 S  0.0  0.4   0:07.28 httpd              
    23999 mommagga  20   0  301m  50m   9m S  0.0  0.2   0:01.87 php                
    24003 nobody    20   0  160m  84m 3940 S  0.0  0.4   0:06.24 httpd              
    24013 showertw  20   0  286m  32m 9476 S  0.0  0.1   0:01.77 php                
    24141 gaytubeg  20   0  283m  28m 9192 S  0.0  0.1   0:00.70 php                
    24342 allnjads  20   0  270m  15m 8940 S  0.0  0.1   0:00.08 php                
    24506 noteboar  20   0  281m  28m 9288 S  0.0  0.1   0:00.85 php                
    25108 allnjspp  20   0  372m 118m 9908 S  0.0  0.5   0:08.37 php                
    25114 allnjspp  20   0  365m 112m 9920 S  0.0  0.5   0:14.19 php                
    25127 fashionm  20   0  296m  45m  10m S  0.0  0.2   0:01.01 php                
    25131 fashionm  20   0  298m  42m 9616 S  0.0  0.2   0:00.81 php                
    25166 mommagti  20   0  300m  48m 9528 S  0.0  0.2   0:01.21 php                
    25174 naughtya  20   0  288m  36m 9208 S  0.0  0.2   0:00.49 php                
    25243 spectrov  20   0  271m  17m 9592 S  0.0  0.1   0:01.03 php                
    25251 oldbridg  20   0  288m  33m 9260 S  0.0  0.1   0:00.68 php                
    25360 emogurlz  20   0  295m  44m 9840 S  0.0  0.2   0:03.74 php                
    25417 stankhol  20   0  286m  35m 9.9m S  0.0  0.1   0:02.03 php                
    25437 stankhol  20   0  291m  37m 9.8m S  0.0  0.2   0:02.58 php                
    25452 spectrot  20   0  303m  51m 9320 S  0.0  0.2   0:01.51 php                
    25457 spectrop  20   0  285m  31m 9528 S  0.0  0.1   0:00.80 php                
    25460 allnjeve  20   0  297m  44m  10m S  0.0  0.2   0:01.81 php                
    25513 allnjwex  20   0  286m  32m 9352 S  0.0  0.1   0:00.49 php                
    25680 chaven    20   0  298m  44m 9712 S  0.0  0.2   0:04.67 php                
    26023 spicypor  20   0  308m  55m 9.8m S  0.0  0.2   0:02.19 php                
    26029 spicypor  20   0  309m  55m 9824 S  0.0  0.2   0:01.86 php                
    26096 njdiscou  20   0  297m  42m   9m S  0.0  0.2   0:00.41 php                
    26105 njdiscou  20   0  290m  38m 9360 S  0.0  0.2   0:00.51 php                
    26821 triplexx  20   0  271m  18m 9016 S  0.0  0.1   0:00.06 php                
    26927 allpasho  20   0  298m  46m 9444 S  0.0  0.2   0:00.59 php                
    28214 hughelli  20   0  303m  49m 9396 S  0.0  0.2   0:01.46 php                
    29464 galaxyof  20   0  269m  14m 8852 S  0.0  0.1   0:00.10 php                
    29593 allnjinf  20   0  283m  33m 9424 S  0.0  0.1   0:01.17 php                
    29689 ultimate  20   0  293m  39m 9664 S  0.0  0.2   0:00.54 php                
    29903 allnjgif  20   0  270m  16m 9252 S  0.0  0.1   0:00.31 php                
    31127 studcart  20   0  288m  34m 9612 S  0.0  0.1   0:01.15 php                
    31305 chavenb   20   0  288m  34m 9184 S  0.0  0.1   0:00.67 php                
    31335 allnjcla  20   0  323m  71m 9604 S  0.0  0.3   0:00.56 php                
    31341 allnjcla  20   0  331m  77m 9676 S  0.0  0.3   0:01.77 php                
    31381 mommagco  20   0  299m  47m 9768 S  0.0  0.2   0:00.93 php                
    31389 mommagco  20   0  296m  45m 9.9m S  0.0  0.2   0:00.99 php                
    32100 dietblas  20   0  268m  14m 8168 S  0.0  0.1   0:00.02 php                
    
    
                 total       used       free     shared    buffers     cached
    Mem:         24034      14601       9433          0        988       8765
    Low:         24034      14601       9433
    High:            0          0          0
    -/+ buffers/cache:       4846      19187
    Swap:        60399          0      60399
    
    MemTotal:       24611332 kB
    MemFree:         9660128 kB
    Buffers:         1012032 kB
    Cached:          8976252 kB
    SwapCached:            0 kB
    Active:          8670012 kB
    Inactive:        5014208 kB
    Active(anon):    3696972 kB
    Inactive(anon):     1468 kB
    Active(file):    4973040 kB
    Inactive(file):  5012740 kB
    Unevictable:           0 kB
    Mlocked:               0 kB
    SwapTotal:      61849596 kB
    SwapFree:       61849596 kB
    Dirty:              1144 kB
    Writeback:            12 kB
    AnonPages:       3695864 kB
    Mapped:            54792 kB
    Shmem:              2512 kB
    Slab:             848408 kB
    SReclaimable:     795152 kB
    SUnreclaim:        53256 kB
    KernelStack:        2408 kB
    PageTables:        53156 kB
    NFS_Unstable:          0 kB
    Bounce:                0 kB
    WritebackTmp:          0 kB
    CommitLimit:    74155260 kB
    Committed_AS:    6260012 kB
    VmallocTotal:   34359738367 kB
    VmallocUsed:      256968 kB
    VmallocChunk:   34359288200 kB
    HardwareCorrupted:     0 kB
    AnonHugePages:   2332672 kB
    HugePages_Total:       0
    HugePages_Free:        0
    HugePages_Rsvd:        0
    HugePages_Surp:        0
    Hugepagesize:       2048 kB
    DirectMap4k:        8192 kB
    DirectMap2M:    25149440 kB
    
    
     Private  +   Shared  =  RAM used	Program 
    
    180.0 KiB + 220.0 KiB = 400.0 KiB	atd
    184.0 KiB + 236.0 KiB = 420.0 KiB	ossec-monitord
    488.0 KiB +   0.0 KiB = 488.0 KiB	pure-uploadscript
    200.0 KiB + 312.0 KiB = 512.0 KiB	ossec-logcollector
    356.0 KiB + 308.0 KiB = 664.0 KiB	ossec-maild
    192.0 KiB + 580.0 KiB = 772.0 KiB	auditd
    488.0 KiB + 476.0 KiB = 964.0 KiB	mingetty (6)
    176.0 KiB + 900.0 KiB =   1.1 MiB	anvil
    336.0 KiB + 752.0 KiB =   1.1 MiB	ossec-execd
    300.0 KiB + 828.0 KiB =   1.1 MiB	dovecot
    324.0 KiB + 940.0 KiB =   1.2 MiB	log
    716.0 KiB + 644.0 KiB =   1.3 MiB	crond
    272.0 KiB +   1.2 MiB =   1.5 MiB	init
      1.2 MiB + 324.0 KiB =   1.5 MiB	udevd (3)
    612.0 KiB + 980.0 KiB =   1.6 MiB	rsyslogd
    336.0 KiB +   1.3 MiB =   1.7 MiB	mysqld_safe
    484.0 KiB +   1.3 MiB =   1.8 MiB	pure-authd
    420.0 KiB +   1.5 MiB =   1.9 MiB	bash
    744.0 KiB +   1.2 MiB =   1.9 MiB	mysqlmymonlite.
    672.0 KiB +   1.3 MiB =   2.0 MiB	pure-ftpd
    940.0 KiB +   1.1 MiB =   2.0 MiB	config
    240.0 KiB +   2.1 MiB =   2.3 MiB	whmsonicsrv
      2.2 MiB + 704.0 KiB =   2.9 MiB	exim
      2.2 MiB + 768.0 KiB =   3.0 MiB	cpanellogd - sl
      1.4 MiB +   2.4 MiB =   3.7 MiB	imap-login (2)
      1.4 MiB +   2.5 MiB =   4.0 MiB	pop3-login (2)
      1.7 MiB +   3.1 MiB =   4.8 MiB	sshd (2)
      5.0 MiB +   1.4 MiB =   6.4 MiB	queueprocd - wa
      4.5 MiB +   2.4 MiB =   6.9 MiB	watchmysql
      5.3 MiB +   2.5 MiB =   7.8 MiB	cPhulkd - proce
      7.6 MiB +   1.2 MiB =   8.8 MiB	psmon
      8.9 MiB + 616.0 KiB =   9.5 MiB	ossec-analysisd
      8.7 MiB +   1.0 MiB =   9.8 MiB	ossec-dbd
      7.4 MiB +   2.8 MiB =  10.2 MiB	leechprotect
     10.8 MiB +   1.3 MiB =  12.2 MiB	tailwatchd
     11.9 MiB + 516.0 KiB =  12.4 MiB	ossec-syscheckd
     13.2 MiB +   1.8 MiB =  15.0 MiB	cpsrvd-ssl
     16.2 MiB + 344.0 KiB =  16.5 MiB	cpdavd - accept
     29.5 MiB +   2.4 MiB =  31.9 MiB	named
     53.0 MiB +   3.2 MiB =  56.2 MiB	/usr/local/cpan (2)
     92.6 MiB +   1.1 MiB =  93.7 MiB	spamd child (2)
    375.3 MiB +  11.7 MiB = 387.0 MiB	tortixd (5)
    443.9 MiB +   5.6 MiB = 449.5 MiB	clamd
    456.3 MiB +   7.1 MiB = 463.3 MiB	mysqld
      1.0 GiB +   5.2 MiB =   1.0 GiB	httpd (13)
      2.2 GiB +  10.3 MiB =   2.2 GiB	php (81)
    
     Private  +   Shared  =  RAM used	Program 
    
    
    
    ----------------------------
    Server Disk Usage
    ----------------------------
    Filesystem           Type   Size  Used Avail Use% Mounted on
    /dev/mapper/vg_server1-lv_root
                         ext4   247G   57G  178G  25% /
    tmpfs                tmpfs   12G     0   12G   0% /dev/shm
    /dev/sdf1            ext4   485M  114M  346M  25% /boot
    /dev/mapper/vg_server1-lv_home
                         ext4    13T  110G   12T   1% /home
    
    ----------------------------
    MySQL datadir disk usage
    ----------------------------
    /var/lib/mysql/ uses 36667792 kilobytes of disk space
    
    ----------------------------
    ulimit -aH
    ----------------------------
    core file size          (blocks, -c) 1000000
    data seg size           (kbytes, -d) unlimited
    scheduling priority             (-e) 0
    file size               (blocks, -f) unlimited
    pending signals                 (-i) 192158
    max locked memory       (kbytes, -l) 64
    max memory size         (kbytes, -m) unlimited
    open files                      (-n) 4096
    pipe size            (512 bytes, -p) 8
    POSIX message queues     (bytes, -q) 819200
    real-time priority              (-r) 0
    stack size              (kbytes, -s) 8192
    cpu time               (seconds, -t) unlimited
    max user processes              (-u) 14335
    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/4573/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            8388608              unlimited            bytes     
    Max core file size        0                    unlimited            bytes     
    Max resident set          unlimited            unlimited            bytes     
    Max processes             192158               192158               processes 
    Max open files            31936                31936                files     
    Max locked memory         65536                65536                bytes     
    Max address space         unlimited            unlimited            bytes     
    Max file locks            unlimited            unlimited            locks     
    Max pending signals       192158               192158               signals   
    Max msgqueue size         819200               819200               bytes     
    Max nice priority         0                    0                    
    Max realtime priority     0                    0                    
    Max realtime timeout      unlimited            unlimited            us        
    
    ----------------------------------
    WEB SERVER & PHP Info:
    ----------------------------------
    PHP 5.3.28 (cli) (built: May 23 2014 21:29:22) 
    Copyright (c) 1997-2013 The PHP Group
    Zend Engine v2.3.0, Copyright (c) 1998-2013 Zend Technologies
        with the ionCube PHP Loader v4.4.1, Copyright (c) 2002-2013, by ionCube Ltd.
    
    System => Linux yourserverhostname 3.2.58-68.art.x86_64 #1 SMP Thu May 15 13:40:36 EDT 2014 x86_64
    Build Date => May 23 2014 21:28:32
    
    Configure Command =>  './configure'  '--disable-fileinfo' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-magic-quotes' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-wddx' '--enable-zip' '--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-libdir=lib64' '--with-libxml-dir=/opt/xml2' '--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-pdo-mysql=shared' '--with-pdo-sqlite=shared' '--with-pic' '--with-png-dir=/usr' '--with-pspell' '--with-sqlite=shared' '--with-tidy=/opt/tidy/' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr'
    
    Server API | Command Line Interface
    Configuration File (php.ini) Path | /usr/local/lib
    Loaded Configuration File | /usr/local/lib/php.ini
    PHP API | 20090626
    Zend Extension Build | API220090626,NTS
    PHP Extension Build | API20090626,NTS
    DOM/XML API Version | 20031129
    Client API version | 5.5.36
    Client API library version | 5.5.36
    Client API header version | 5.5.36
    Client API version | 5.5.36
    Phar API version | 1.1.1
    
    display_errors | STDOUT | STDOUT
    error_log | error_log | error_log
    extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20090626 | /usr/local/lib/php/extensions/no-debug-non-zts-20090626
    file_uploads | On | On
    log_errors | On | On
    log_errors_max_len | 1024 | 1024
    magic_quotes_gpc | Off | Off
    magic_quotes_sybase | Off | Off
    max_execution_time | 0 | 0
    max_file_uploads | 20 | 20
    memory_limit | 256M | 256M
    open_basedir | no value | no value
    post_max_size | 4096M | 4096M
    realpath_cache_size | 16K | 16K
    realpath_cache_ttl | 120 | 120
    safe_mode | Off | Off
    safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
    safe_mode_gid | Off | Off
    safe_mode_include_dir | no value | no value
    sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
    sql.safe_mode | Off | Off
    upload_max_filesize | 4096M | 4096M
    upload_tmp_dir | no value | no value
    sqlite3.extension_dir | no value | no value
    safe_mode_allowed_env_vars | PHP_ | PHP_
    safe_mode_protected_env_vars | LD_LIBRARY_PATH | LD_LIBRARY_PATH
    
    cURL support | enabled
    cURL Information | 7.24.0
    ZLib Version | 1.2.3
    GD Support | enabled
    GD Version | bundled (2.1.0 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
    Soap Client | enabled
    Soap Server | enabled
    ZLib Support | enabled
    
    
    PCRE (Perl Compatible Regular Expressions) Support => enabled
    PCRE Library Version => 8.21 2011-12-12
    
    Directive => Local Value => Master Value
    pcre.backtrack_limit => 1000000 => 1000000
    pcre.recursion_limit => 100000 => 100000
    
    PDO support => enabled
    PDO drivers => sqlite, sqlite2, mysql
    
    PDO Driver for MySQL => enabled
    Client API version => 5.5.36
    
    PDO Driver for SQLite 3.x => enabled
    SQLite Library => 3.7.7.1
    
    Phar: PHP Archive support => enabled
    Phar EXT version => 2.0.1
    Phar API version => 1.1.1
    SVN revision => $Id: 21d763042eb5769ae0a09dc1118df2b5aae6fb33 $
    Phar-based phar archives => enabled
    Tar-based phar archives => enabled
    ZIP-based phar archives => enabled
    gzip compression => enabled
    bzip2 compression => disabled (install pecl/bz2)
    OpenSSL support => enabled
    
    
    Phar based on pear/PHP_Archive, original concept by Davey Shafik.
    Phar fully realized by Gregory Beaver and Marcus Boerger.
    Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
    Directive => Local Value => Master Value
    phar.cache_list => no value => no value
    phar.readonly => On => On
    phar.require_hash => On => On
    
    
    
    
       Server Version: Apache/2.2.27 (Unix) mod_ssl/2.2.27 OpenSSL/1.0.1e-fips
       Server Built: May 23 2014 21:25:55
       Current Time: Saturday, 24-May-2014 21:51:25 EDT
       Restart Time: Saturday, 24-May-2014 13:57:59 EDT
       Parent Server Generation: 5
       Total accesses: 70508 - Total Traffic: 616.0 MB
       CPU Usage: u37.67 s9.88 cu7.27 cs0 - .193% CPU load
       2.48 requests/sec - 22.2 kB/second - 8.9 kB/request
       2 requests currently being processed, 9 idle workers
    
    Server version: Apache/2.2.27 (Unix)
    Server built:   May 23 2014 21:25:55
    Cpanel::Easy::Apache v3.24.18 rev9999
    Server's Module Magic Number: 20051115:33
    Server loaded:  APR 1.5.0, APR-Util 1.5.3
    Compiled using: APR 1.5.0, APR-Util 1.5.3
    Architecture:   64-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 disabled)
     -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_dbm_module (static)
     authn_dbd_module (static)
     authn_default_module (static)
     authn_alias_module (static)
     authz_host_module (static)
     authz_groupfile_module (static)
     authz_user_module (static)
     authz_dbm_module (static)
     authz_default_module (static)
     auth_basic_module (static)
     auth_digest_module (static)
     file_cache_module (static)
     cache_module (static)
     disk_cache_module (static)
     mem_cache_module (static)
     include_module (static)
     filter_module (static)
     deflate_module (static)
     log_config_module (static)
     log_forensic_module (static)
     logio_module (static)
     env_module (static)
     mime_magic_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)
     dav_module (static)
     status_module (static)
     autoindex_module (static)
     asis_module (static)
     info_module (static)
     suexec_module (static)
     cgi_module (static)
     dav_fs_module (static)
     dav_lock_module (static)
     negotiation_module (static)
     dir_module (static)
     actions_module (static)
     speling_module (static)
     userdir_module (static)
     alias_module (static)
     rewrite_module (static)
     so_module (static)
     sed_module (shared)
     security2_module (shared)
     evasive20_module (shared)
     bwlimited_module (shared)
     cloudflare_module (shared)
     fastinclude_module (shared)
     fcgid_module (shared)
    
    Compiled in modules:
      core.c
      mod_authn_file.c
      mod_authn_dbm.c
      mod_authn_dbd.c
      mod_authn_default.c
      mod_authn_alias.c
      mod_authz_host.c
      mod_authz_groupfile.c
      mod_authz_user.c
      mod_authz_dbm.c
      mod_authz_default.c
      mod_auth_basic.c
      mod_auth_digest.c
      mod_file_cache.c
      mod_cache.c
      mod_disk_cache.c
      mod_mem_cache.c
      mod_include.c
      mod_filter.c
      mod_deflate.c
      mod_log_config.c
      mod_log_forensic.c
      mod_logio.c
      mod_env.c
      mod_mime_magic.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_dav.c
      mod_status.c
      mod_autoindex.c
      mod_asis.c
      mod_info.c
      mod_suexec.c
      mod_cgi.c
      mod_dav_fs.c
      mod_dav_lock.c
      mod_negotiation.c
      mod_dir.c
      mod_actions.c
      mod_speling.c
      mod_userdir.c
      mod_alias.c
      mod_rewrite.c
      mod_so.c
    
    
    -------------------------------
    From /usr/local/apache/conf/httpd.conf
    -------------------------------
    Timeout 300
    KeepAlive Off
    MaxKeepAliveRequests 100
    KeepAliveTimeout 5
    
    </IfModule>
    StartServers 5
    <IfModule prefork.c>
    MinSpareServers 5
    MaxSpareServers 10
    </IfModule>
    MinSpareServers 5
    MaxSpareServers 10
    </IfModule>
    ServerLimit 2048
    MaxClients 150
    MaxRequestsPerChild 10000
    </IfModule>
    
    
    ----------------------------
    mysqlreport output
    ----------------------------
    
    MySQL   5.5.36-cll          uptime 0 7:52:45    Sat May 24 21:52:04 2014
    
    __ Key _________________________________________________________________
    Buffer used     6.54M of    8.00M   %Used:  81.76
      Current       4.73M              %Usage:  59.12
    Write hit      99.04%
    Read hit       99.94%
    
    __ Questions ___________________________________________________________
    Total           1.78M      62.7/s
      QC Hits       1.13M      40.0/s  %Total:  63.70
      DMS         541.95k      19.1/s           30.46
      Com_        223.61k       7.9/s           12.57
      -Unknown    157.84k       5.6/s            8.87
      COM_QUIT     38.20k       1.3/s            2.15
    Slow 10 s           4       0.0/s            0.00  %DMS:   0.00 Log: OFF
    DMS           541.95k      19.1/s           30.46
      INSERT      272.48k       9.6/s           15.31         50.28
      SELECT      224.72k       7.9/s           12.63         41.47
      DELETE       16.05k       0.6/s            0.90          2.96
      REPLACE      15.53k       0.5/s            0.87          2.86
      UPDATE       13.17k       0.5/s            0.74          2.43
    Com_          223.61k       7.9/s           12.57
      set_option   52.85k       1.9/s            2.97
      change_db    33.20k       1.2/s            1.87
      stmt_close   30.93k       1.1/s            1.74
    
    __ Rows ________________________________________________________________
    Rows            2.17G     76.3k/s
      Using idx   651.58M     23.0k/s  %Index:  30.09
    Rows/question   1.22k
    
    __ SELECT and Sort _____________________________________________________
    Scan           44.98k       1.6/s %SELECT:  20.02
    Range          30.60k       1.1/s           13.62
    Full join         305       0.0/s            0.14
    Range check         2       0.0/s            0.00
    Full rng join      16       0.0/s            0.01
    Sort scan      53.37k       1.9/s
    Sort range     15.12k       0.5/s
    Sort mrg pass      38       0.0/s
    
    __ Query Cache _________________________________________________________
    Memory usage   24.57M of   32.00M  %Usage:  76.78
    Block Fragmnt   6.91%
    Hits            1.13M      40.0/s
    Inserts       184.82k       6.5/s
    Insrt:Prune    2.47:1       3.9/s
    Hit:Insert     6.13:1
    
    __ Table Locks _________________________________________________________
    Waited          2.35k       0.1/s  %Total:   0.40
    Immediate     585.43k      20.6/s
    
    __ Tables ______________________________________________________________
    Open              400 of    400    %Cache: 100.00
    Opened          1.15M      40.5/s
    
    __ Connections _________________________________________________________
    Max used           30 of    151      %Max:  19.87
    Total          38.88k       1.4/s
    
    __ Created Temp ________________________________________________________
    Disk table     19.75k       0.7/s   %Disk:  37.83
    Table          52.21k       1.8/s    Size:  16.0M
    File               46       0.0/s
    
    __ Threads _____________________________________________________________
    Running             1 of      6
    Created        38.82k       1.4/s
    Slow                0         0/s
    Cached              0 of      0      %Hit:   0.16
    
    __ Aborted _____________________________________________________________
    Clients         1.35k       0.0/s
    Connects           11       0.0/s
    
    __ Bytes _______________________________________________________________
    Sent            2.32G     81.7k/s
    Received      226.99M      8.0k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage         128.00M of  128.00M  %Usage: 100.00
    Read hit       99.80%
    Pages
      Free              0              %Total:   0.00
      Data          8.05k                       98.32  %Drty:   0.00
      Misc            138                        1.68
      Latched           0                        0.00
    Reads         548.34M     19.3k/s
      From disk     1.09M      38.5/s   %Disk:   0.20
      Ahead Rnd         0         0/s
    Writes        482.12k      17.0/s
    Wait Free           0         0/s   %Wait:   0.00
    Flushes        97.56k       3.4/s
    
    __ InnoDB Lock _________________________________________________________
    Waits               2       0.0/s
    Current             0
    Time acquiring
      Total            44 ms
      Average          22 ms
      Max              43 ms
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads         1.12M      39.5/s
      Writes      123.09k       4.3/s
      fsync        38.09k       1.3/s
      Pending
        Reads           0
        Writes          0
        fsync           1
    
    Pages
      Created       8.42k       0.3/s
      Read          1.12M      39.4/s
      Written      97.57k       3.4/s
    
    Rows
      Deleted       1.70k       0.1/s
      Inserted     21.61k       0.8/s
      Read        289.57M     10.2k/s
      Updated      31.72k       1.1/s
    
    ----------------------------
    Total Server MyISAM and InnoDB Size
    ----------------------------
    *************************** 1. row ***************************
    innodb_tablespace_utilization_perc: 100
                         total_size_gb: 34.510652558878064
                         index_size_gb: 1.8998483717441559
                          data_size_gb: 32.61080418713391
                  innodb_total_size_gb: 0.404937744140625
                   innodb_data_size_gb: 0.246978759765625
                  innodb_index_size_gb: 0.157958984375
                  myisam_total_size_gb: 34.104802990332246
                   myisam_data_size_gb: 32.36334981955588
                  myisam_index_size_gb: 1.7414531707763672
                            perc_index: 5.505107000
                             perc_data: 94.494892900
                     innodb_perc_index: 39.008214600
                      innodb_perc_data: 60.991785300
                     myisam_perc_index: 5.106181500
                      myisam_perc_data: 94.893818400
               innodb_perc_total_index: 8.314294200
                innodb_perc_total_data: 0.757352500
               myisam_perc_total_index: 91.662745100
                myisam_perc_total_data: 99.241189000
    
    ----------------------------
    MySQL settings
    ----------------------------
    [mysqld]
    
    local-infile=0
    log-warnings=2
    symbolic-links=0
    query_cache_size=32m
    innodb_file_per_table=1
    open_files_limit=31936
    [mysqld_safe]
    
    log-error=/var/log/mysqld.log
    ---
    +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
    | Variable_name | Value |
    +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
    | auto_increment_increment | 1 |
    | auto_increment_offset | 1 |
    | autocommit | ON |
    | automatic_sp_privileges | ON |
    | back_log | 50 |
    | basedir | /usr |
    | big_tables | OFF |
    | binlog_cache_size | 32768 |
    | binlog_direct_non_transactional_updates | OFF |
    | binlog_format | STATEMENT |
    | binlog_stmt_cache_size | 32768 |
    | 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 | NO_CHAIN |
    | concurrent_insert | AUTO |
    | connect_timeout | 10 |
    | datadir | /var/lib/mysql/ |
    | date_format | %Y-%m-%d |
    | datetime_format | %Y-%m-%d %H:%i:%s |
    | default_storage_engine | InnoDB |
    | 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 |
    | 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/server1.log |
    | group_concat_max_len | 1024 |
    | 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_profiling | YES |
    | have_query_cache | YES |
    | have_rtree_keys | YES |
    | have_ssl | DISABLED |
    | have_symlink | DISABLED |
    | hostname | yourserverhostname |
    | ignore_builtin_innodb | OFF |
    | init_connect | |
    | init_file | |
    | init_slave | |
    | innodb_adaptive_flushing | ON |
    | innodb_adaptive_hash_index | ON |
    | innodb_additional_mem_pool_size | 8388608 |
    | innodb_autoextend_increment | 8 |
    | innodb_autoinc_lock_mode | 1 |
    | innodb_buffer_pool_instances | 1 |
    | innodb_buffer_pool_size | 134217728 |
    | innodb_change_buffering | all |
    | 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_format | Antelope |
    | innodb_file_format_check | ON |
    | innodb_file_format_max | Antelope |
    | innodb_file_per_table | ON |
    | innodb_flush_log_at_trx_commit | 1 |
    | innodb_flush_method | |
    | innodb_force_load_corrupted | OFF |
    | innodb_force_recovery | 0 |
    | innodb_io_capacity | 200 |
    | innodb_large_prefix | OFF |
    | innodb_lock_wait_timeout | 50 |
    | innodb_locks_unsafe_for_binlog | OFF |
    | innodb_log_buffer_size | 8388608 |
    | innodb_log_file_size | 5242880 |
    | innodb_log_files_in_group | 2 |
    | innodb_log_group_home_dir | ./ |
    | innodb_max_dirty_pages_pct | 75 |
    | innodb_max_purge_lag | 0 |
    | innodb_mirrored_log_groups | 1 |
    | innodb_old_blocks_pct | 37 |
    | innodb_old_blocks_time | 0 |
    | innodb_open_files | 300 |
    | innodb_print_all_deadlocks | OFF |
    | innodb_purge_batch_size | 20 |
    | innodb_purge_threads | 0 |
    | innodb_random_read_ahead | OFF |
    | innodb_read_ahead_threshold | 56 |
    | innodb_read_io_threads | 4 |
    | innodb_replication_delay | 0 |
    | innodb_rollback_on_timeout | OFF |
    | innodb_rollback_segments | 128 |
    | innodb_spin_wait_delay | 6 |
    | innodb_stats_method | nulls_equal |
    | innodb_stats_on_metadata | ON |
    | innodb_stats_sample_pages | 8 |
    | innodb_strict_mode | OFF |
    | innodb_support_xa | ON |
    | innodb_sync_spin_loops | 30 |
    | innodb_table_locks | ON |
    | innodb_thread_concurrency | 0 |
    | innodb_thread_sleep_delay | 10000 |
    | innodb_use_native_aio | ON |
    | innodb_use_sys_malloc | ON |
    | innodb_version | 5.5.36 |
    | innodb_write_io_threads | 4 |
    | interactive_timeout | 28800 |
    | join_buffer_size | 131072 |
    | keep_files_on_create | OFF |
    | key_buffer_size | 8388608 |
    | key_cache_age_threshold | 300 |
    | key_cache_block_size | 1024 |
    | key_cache_division_limit | 100 |
    | large_files_support | ON |
    | large_page_size | 0 |
    | large_pages | OFF |
    | lc_messages | en_US |
    | lc_messages_dir | /usr/share/mysql/ |
    | lc_time_names | en_US |
    | license | GPL |
    | local_infile | OFF |
    | lock_wait_timeout | 31536000 |
    | locked_in_memory | OFF |
    | log | OFF |
    | log_bin | OFF |
    | log_bin_trust_function_creators | OFF |
    | log_error | /var/log/mysqld.log |
    | log_output | FILE |
    | log_queries_not_using_indexes | OFF |
    | log_slave_updates | OFF |
    | log_slow_queries | OFF |
    | log_warnings | 2 |
    | long_query_time | 10.000000 |
    | low_priority_updates | OFF |
    | lower_case_file_system | OFF |
    | lower_case_table_names | 0 |
    | max_allowed_packet | 1048576 |
    | max_binlog_cache_size | 18446744073709547520 |
    | max_binlog_size | 1073741824 |
    | max_binlog_stmt_cache_size | 18446744073709547520 |
    | max_connect_errors | 10 |
    | max_connections | 151 |
    | max_delayed_threads | 20 |
    | max_error_count | 64 |
    | max_heap_table_size | 16777216 |
    | 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 | 18446744073709551615 |
    | max_sort_length | 1024 |
    | max_sp_recursion_depth | 0 |
    | max_tmp_tables | 32 |
    | max_user_connections | 0 |
    | max_write_lock_count | 18446744073709551615 |
    | metadata_locks_cache_size | 1024 |
    | min_examined_row_limit | 0 |
    | multi_range_count | 256 |
    | myisam_data_pointer_size | 6 |
    | myisam_max_sort_file_size | 9223372036853727232 |
    | myisam_mmap_size | 18446744073709551615 |
    | 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 | 31936 |
    | 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,engine_condition_pushdown=on |
    | performance_schema | OFF |
    | performance_schema_events_waits_history_long_size | 10000 |
    | performance_schema_events_waits_history_size | 10 |
    | performance_schema_max_cond_classes | 80 |
    | performance_schema_max_cond_instances | 1000 |
    | performance_schema_max_file_classes | 50 |
    | performance_schema_max_file_handles | 32768 |
    | performance_schema_max_file_instances | 10000 |
    | performance_schema_max_mutex_classes | 200 |
    | performance_schema_max_mutex_instances | 1000000 |
    | performance_schema_max_rwlock_classes | 30 |
    | performance_schema_max_rwlock_instances | 1000000 |
    | performance_schema_max_table_handles | 100000 |
    | performance_schema_max_table_instances | 50000 |
    | performance_schema_max_thread_classes | 50 |
    | performance_schema_max_thread_instances | 1000 |
    | pid_file | /var/lib/mysql/yourserverhostname.pid |
    | plugin_dir | /usr/lib64/mysql/plugin/ |
    | port | 3306 |
    | preload_buffer_size | 32768 |
    | profiling | OFF |
    | profiling_history_size | 15 |
    | protocol_version | 10 |
    | query_alloc_block_size | 8192 |
    | query_cache_limit | 1048576 |
    | query_cache_min_res_unit | 4096 |
    | query_cache_size | 33554432 |
    | query_cache_type | ON |
    | query_cache_wlock_invalidate | OFF |
    | query_prealloc_size | 8192 |
    | 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_recovery | OFF |
    | 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 |
    | slave_type_conversions | |
    | slow_launch_time | 2 |
    | slow_query_log | OFF |
    | slow_query_log_file | /var/lib/mysql/server1-slow.log |
    | socket | /var/lib/mysql/mysql.sock |
    | sort_buffer_size | 2097152 |
    | sql_auto_is_null | OFF |
    | sql_big_selects | ON |
    | sql_big_tables | OFF |
    | sql_buffer_result | OFF |
    | sql_log_bin | ON |
    | sql_log_off | OFF |
    | 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 | 0 |
    | sql_warnings | OFF |
    | ssl_ca | |
    | ssl_capath | |
    | ssl_cert | |
    | ssl_cipher | |
    | ssl_key | |
    | storage_engine | InnoDB |
    | stored_program_cache | 256 |
    | sync_binlog | 0 |
    | sync_frm | ON |
    | sync_master_info | 0 |
    | sync_relay_log | 0 |
    | sync_relay_log_info | 0 |
    | system_time_zone | EDT |
    | table_definition_cache | 400 |
    | table_open_cache | 400 |
    | thread_cache_size | 0 |
    | thread_concurrency | 10 |
    | thread_handling | one-thread-per-connection |
    | thread_stack | 262144 |
    | thread_statistics | OFF |
    | time_format | %H:%i:%s |
    | time_zone | SYSTEM |
    | timed_mutexes | OFF |
    | tmp_table_size | 16777216 |
    | tmpdir | /tmp |
    | transaction_alloc_block_size | 8192 |
    | transaction_prealloc_size | 4096 |
    | tx_isolation | REPEATABLE-READ |
    | unique_checks | ON |
    | updatable_views_with_limit | YES |
    | userstat | OFF |
    | version | 5.5.36-cll |
    | version_comment | MySQL Community Server (GPL) |
    | version_compile_machine | x86_64 |
    | version_compile_os | Linux |
    | wait_timeout | 28800 |
    +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
    +------------------------------------------+-------------+
    | Variable_name | Value |
    +------------------------------------------+-------------+
    | Aborted_clients | 1355 |
    | Aborted_connects | 11 |
    | Binlog_cache_disk_use | 0 |
    | Binlog_cache_use | 0 |
    | Binlog_stmt_cache_disk_use | 0 |
    | Binlog_stmt_cache_use | 0 |
    | Bytes_received | 227016539 |
    | Bytes_sent | 2318370272 |
    | Com_admin_commands | 3004 |
    | 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_begin | 70 |
    | Com_binlog | 0 |
    | Com_call_procedure | 0 |
    | Com_change_db | 33203 |
    | Com_change_master | 0 |
    | Com_check | 0 |
    | Com_checksum | 0 |
    | Com_commit | 71 |
    | 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 | 43 |
    | Com_create_trigger | 0 |
    | Com_create_udf | 0 |
    | Com_create_user | 0 |
    | Com_create_view | 0 |
    | Com_dealloc_sql | 0 |
    | Com_delete | 15996 |
    | Com_delete_multi | 61 |
    | 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 | 2 |
    | Com_drop_trigger | 0 |
    | Com_drop_user | 0 |
    | Com_drop_view | 0 |
    | Com_empty_query | 0 |
    | Com_execute_sql | 0 |
    | Com_flush | 1 |
    | Com_grant | 0 |
    | Com_ha_close | 0 |
    | Com_ha_open | 0 |
    | Com_ha_read | 0 |
    | Com_help | 0 |
    | Com_insert | 271983 |
    | Com_insert_select | 502 |
    | Com_install_plugin | 0 |
    | Com_kill | 1349 |
    | Com_load | 0 |
    | Com_lock_tables | 596 |
    | Com_optimize | 17 |
    | Com_preload_keys | 0 |
    | Com_prepare_sql | 0 |
    | Com_purge | 0 |
    | Com_purge_before_date | 0 |
    | Com_release_savepoint | 0 |
    | Com_rename_table | 1 |
    | Com_rename_user | 0 |
    | Com_repair | 0 |
    | Com_replace | 15525 |
    | Com_replace_select | 0 |
    | Com_reset | 0 |
    | Com_resignal | 0 |
    | Com_revoke | 0 |
    | Com_revoke_all | 0 |
    | Com_rollback | 0 |
    | Com_rollback_to_savepoint | 0 |
    | Com_savepoint | 0 |
    | Com_select | 224742 |
    | Com_set_option | 52855 |
    | Com_signal | 0 |
    | Com_show_authors | 0 |
    | Com_show_binlog_events | 0 |
    | Com_show_binlogs | 0 |
    | Com_show_charsets | 0 |
    | Com_show_client_statistics | 0 |
    | Com_show_collations | 0 |
    | Com_show_contributors | 0 |
    | Com_show_create_db | 0 |
    | Com_show_create_event | 0 |
    | Com_show_create_func | 0 |
    | Com_show_create_proc | 0 |
    | Com_show_create_table | 449 |
    | Com_show_create_trigger | 0 |
    | Com_show_databases | 6 |
    | 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 | 2421 |
    | Com_show_function_status | 0 |
    | Com_show_grants | 0 |
    | Com_show_index_statistics | 0 |
    | Com_show_keys | 70 |
    | Com_show_master_status | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_plugins | 0 |
    | Com_show_privileges | 0 |
    | Com_show_procedure_status | 0 |
    | Com_show_processlist | 129 |
    | Com_show_profile | 0 |
    | Com_show_profiles | 0 |
    | Com_show_relaylog_events | 0 |
    | Com_show_slave_hosts | 0 |
    | Com_show_slave_status | 0 |
    | Com_show_status | 390 |
    | Com_show_storage_engines | 0 |
    | Com_show_table_statistics | 0 |
    | Com_show_table_status | 219 |
    | Com_show_tables | 1509 |
    | Com_show_thread_statistics | 0 |
    | Com_show_triggers | 1544 |
    | Com_show_user_statistics | 0 |
    | Com_show_variables | 22 |
    | Com_show_warnings | 0 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_stmt_close | 30932 |
    | Com_stmt_execute | 30932 |
    | Com_stmt_fetch | 0 |
    | Com_stmt_prepare | 30932 |
    | Com_stmt_reprepare | 0 |
    | Com_stmt_reset | 30932 |
    | Com_stmt_send_long_data | 0 |
    | Com_truncate | 1337 |
    | Com_uninstall_plugin | 0 |
    | Com_unlock_tables | 596 |
    | Com_update | 11885 |
    | Com_update_multi | 1288 |
    | 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 | 38887 |
    | Created_tmp_disk_tables | 19762 |
    | Created_tmp_files | 46 |
    | Created_tmp_tables | 52273 |
    | Delayed_errors | 0 |
    | Delayed_insert_threads | 1 |
    | Delayed_writes | 678 |
    | Flush_commands | 1 |
    | Handler_commit | 127823 |
    | Handler_delete | 3564 |
    | Handler_discover | 0 |
    | Handler_prepare | 0 |
    | Handler_read_first | 49209 |
    | Handler_read_key | 225607554 |
    | Handler_read_last | 1422 |
    | Handler_read_next | 402555782 |
    | Handler_read_prev | 23604027 |
    | Handler_read_rnd | 1339261 |
    | Handler_read_rnd_next | 1506848416 |
    | Handler_rollback | 0 |
    | Handler_savepoint | 0 |
    | Handler_savepoint_rollback | 0 |
    | Handler_update | 97846458 |
    | Handler_write | 124906324 |
    | Innodb_buffer_pool_pages_data | 8074 |
    | Innodb_buffer_pool_bytes_data | 132284416 |
    | Innodb_buffer_pool_pages_dirty | 0 |
    | Innodb_buffer_pool_bytes_dirty | 0 |
    | Innodb_buffer_pool_pages_flushed | 97569 |
    | Innodb_buffer_pool_pages_free | 0 |
    | Innodb_buffer_pool_pages_misc | 118 |
    | Innodb_buffer_pool_pages_total | 8192 |
    | Innodb_buffer_pool_read_ahead_rnd | 0 |
    | Innodb_buffer_pool_read_ahead | 17721 |
    | Innodb_buffer_pool_read_ahead_evicted | 6858 |
    | Innodb_buffer_pool_read_requests | 548751230 |
    | Innodb_buffer_pool_reads | 1103518 |
    | Innodb_buffer_pool_wait_free | 0 |
    | Innodb_buffer_pool_write_requests | 482124 |
    | Innodb_data_fsyncs | 38091 |
    | Innodb_data_pending_fsyncs | 0 |
    | Innodb_data_pending_reads | 0 |
    | Innodb_data_pending_writes | 0 |
    | Innodb_data_read | 18487676928 |
    | Innodb_data_reads | 1131609 |
    | Innodb_data_writes | 123091 |
    | Innodb_data_written | 3251286528 |
    | Innodb_dblwr_pages_written | 97569 |
    | Innodb_dblwr_writes | 3625 |
    | Innodb_have_atomic_builtins | ON |
    | Innodb_log_waits | 0 |
    | Innodb_log_write_requests | 102668 |
    | Innodb_log_writes | 13875 |
    | Innodb_os_log_fsyncs | 15984 |
    | Innodb_os_log_pending_fsyncs | 0 |
    | Innodb_os_log_pending_writes | 0 |
    | Innodb_os_log_written | 53076992 |
    | Innodb_page_size | 16384 |
    | Innodb_pages_created | 8419 |
    | Innodb_pages_read | 1128136 |
    | Innodb_pages_written | 97569 |
    | Innodb_row_lock_current_waits | 0 |
    | Innodb_row_lock_time | 44 |
    | Innodb_row_lock_time_avg | 22 |
    | Innodb_row_lock_time_max | 43 |
    | Innodb_row_lock_waits | 2 |
    | Innodb_rows_deleted | 1697 |
    | Innodb_rows_inserted | 21608 |
    | Innodb_rows_read | 289694146 |
    | Innodb_rows_updated | 31722 |
    | Innodb_truncated_status_writes | 0 |
    | Key_blocks_not_flushed | 0 |
    | Key_blocks_unused | 4331 |
    | Key_blocks_used | 6698 |
    | Key_read_requests | 725100457 |
    | Key_reads | 403034 |
    | Key_write_requests | 82486923 |
    | Key_writes | 795903 |
    | Last_query_cost | 0.000000 |
    | Max_used_connections | 30 |
    | Not_flushed_delayed_rows | 0 |
    | Open_files | 796 |
    | Open_streams | 0 |
    | Open_table_definitions | 400 |
    | Open_tables | 400 |
    | Opened_files | 2041056 |
    | Opened_table_definitions | 1115785 |
    | Opened_tables | 1153904 |
    | Performance_schema_cond_classes_lost | 0 |
    | Performance_schema_cond_instances_lost | 0 |
    | Performance_schema_file_classes_lost | 0 |
    | Performance_schema_file_handles_lost | 0 |
    | Performance_schema_file_instances_lost | 0 |
    | Performance_schema_locker_lost | 0 |
    | Performance_schema_mutex_classes_lost | 0 |
    | Performance_schema_mutex_instances_lost | 0 |
    | Performance_schema_rwlock_classes_lost | 0 |
    | Performance_schema_rwlock_instances_lost | 0 |
    | Performance_schema_table_handles_lost | 0 |
    | Performance_schema_table_instances_lost | 0 |
    | Performance_schema_thread_classes_lost | 0 |
    | Performance_schema_thread_instances_lost | 0 |
    | Prepared_stmt_count | 0 |
    | Qcache_free_blocks | 2174 |
    | Qcache_free_memory | 7788344 |
    | Qcache_hits | 1133734 |
    | Qcache_inserts | 184819 |
    | Qcache_lowmem_prunes | 74895 |
    | Qcache_not_cached | 38855 |
    | Qcache_queries_in_cache | 14026 |
    | Qcache_total_blocks | 31517 |
    | Queries | 1921600 |
    | Questions | 1779698 |
    | Rpl_status | AUTH_MASTER |
    | Select_full_join | 305 |
    | Select_full_range_join | 16 |
    | Select_range | 30613 |
    | Select_range_check | 2 |
    | Select_scan | 44995 |
    | Slave_heartbeat_period | 0.000 |
    | Slave_open_temp_tables | 0 |
    | Slave_received_heartbeats | 0 |
    | Slave_retried_transactions | 0 |
    | Slave_running | OFF |
    | Slow_launch_threads | 0 |
    | Slow_queries | 4 |
    | Sort_merge_passes | 38 |
    | Sort_range | 15118 |
    | Sort_rows | 6338444 |
    | Sort_scan | 53376 |
    | 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 | 585459 |
    | Table_locks_waited | 2354 |
    | Tc_log_max_pages_used | 0 |
    | Tc_log_page_size | 0 |
    | Tc_log_page_waits | 0 |
    | Threads_cached | 0 |
    | Threads_connected | 7 |
    | Threads_created | 38825 |
    | Threads_running | 2 |
    | Uptime | 28367 |
    | Uptime_since_flush_status | 28367 |
    +------------------------------------------+-------------+
    +-------+---------------+-----------------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +-------+---------------+-----------------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
    | 3 | eximstats | localhost | eximstats | Sleep | 54 | | |
    | 4 | tortix | localhost:60205 | tortix | Sleep | 49 | | |
    | 1144 | root | localhost | | Sleep | 481 | | |
    | 34788 | leechprotect | localhost | leechprotect | Sleep | 2722 | | |
    | 34868 | DELAYED | localhost | eximstats | Delayed insert | 54 | Waiting for INSERT | |
    | 38490 | thatsoci_cg11 | localhost | thatsoci_ssg | Sleep | 256 | | |
    | 38883 | tortix | localhost:39664 | tortix | Query | 0 | Writing to net | SELECT rule_id,SUM(total) AS rcount FROM aslw_stat_ip WHERE rule_id BETWEEN 300000 AND 399999 AND dt |
    | 38886 | root | localhost | | Query | 0 | | show processlist |
    +-------+---------------+-----------------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
    
    ------------------------------------
    INNODB Buffer Pool Stats
    ------------------------------------
    *************************** 1. row ***************************
                             POOL_ID: 0
                           POOL_SIZE: 8192
                        FREE_BUFFERS: 0
                      DATABASE_PAGES: 8074
                  OLD_DATABASE_PAGES: 2960
             MODIFIED_DATABASE_PAGES: 0
                  PENDING_DECOMPRESS: 0
                       PENDING_READS: 0
                   PENDING_FLUSH_LRU: 0
                  PENDING_FLUSH_LIST: 0
                    PAGES_MADE_YOUNG: 1119698
                PAGES_NOT_MADE_YOUNG: 0
               PAGES_MADE_YOUNG_RATE: 183.390436222357
           PAGES_MADE_NOT_YOUNG_RATE: 0
                   NUMBER_PAGES_READ: 1128137
                NUMBER_PAGES_CREATED: 8419
                NUMBER_PAGES_WRITTEN: 97569
                     PAGES_READ_RATE: 183.96419730824087
                   PAGES_CREATE_RATE: 0.34425665153030277
                  PAGES_WRITTEN_RATE: 4.770413599777053
                    NUMBER_PAGES_GET: 548751235
                            HIT_RATE: 995
        YOUNG_MAKE_PER_THOUSAND_GETS: 5
    NOT_YOUNG_MAKE_PER_THOUSAND_GETS: 0
             NUMBER_PAGES_READ_AHEAD: 17721
           NUMBER_READ_AHEAD_EVICTED: 6858
                     READ_AHEAD_RATE: 3.131096211537516
             READ_AHEAD_EVICTED_RATE: 1.9180013442402584
                        LRU_IO_TOTAL: 11268
                      LRU_IO_CURRENT: 1
                    UNCOMPRESS_TOTAL: 0
                  UNCOMPRESS_CURRENT: 0
    
    ----------------------------
    INNODB Status
    ----------------------------
    *************************** 1. row ***************************
      Type: InnoDB
      Name: 
    Status: 
    =====================================
    140524 21:52:06 INNODB MONITOR OUTPUT
    =====================================
    Per second averages calculated from the last 61 seconds
    -----------------
    BACKGROUND THREAD
    -----------------
    srv_master_thread loops: 21809 1_second, 21807 sleeps, 2016 10_second, 1863 background, 1863 flush
    srv_master_thread log flush and writes: 22506
    ----------
    SEMAPHORES
    ----------
    OS WAIT ARRAY INFO: reservation count 3458, signal count 5602
    Mutex spin waits 13567, rounds 53921, OS waits 433
    RW-shared spins 4854, rounds 110065, OS waits 2480
    RW-excl spins 1059, rounds 32025, OS waits 303
    Spin rounds per wait: 3.97 mutex, 22.68 RW-shared, 30.24 RW-excl
    ------------
    TRANSACTIONS
    ------------
    Trx id counter AD2195
    Purge done for trx's n:o < AD2180 undo n:o < 0
    History list length 1351
    LIST OF TRANSACTIONS FOR EACH SESSION:
    ---TRANSACTION 0, not started
    MySQL thread id 38888, OS thread handle 0x2f833e19700, query id 1921611 localhost root
    show engine innodb status
    ---TRANSACTION AD1C09, not started
    MySQL thread id 38490, OS thread handle 0x2f894a1c700, query id 1908191 localhost thatsoci_cg11
    ---TRANSACTION AD204E, not started
    MySQL thread id 4, OS thread handle 0x2f8a452c700, query id 1918576 localhost 127.0.0.1 tortix
    ---TRANSACTION AD2194, ACTIVE 0 sec
    mysql tables in use 1, locked 0
    MySQL thread id 38883, OS thread handle 0x2f833cf4700, query id 1921606 localhost 127.0.0.1 tortix Copying to tmp table
    SELECT code,SUM(total) AS tcount FROM aslw_stat_geo WHERE dt>=DATE_SUB(NOW(),INTERVAL 1 MONTH) GROUP BY code ORDER BY tcount DESC LIMIT 5
    Trx read view will not see trx with id >= AD2195, sees < AD2195
    --------
    FILE I/O
    --------
    I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
    I/O thread 1 state: waiting for completed aio requests (log thread)
    I/O thread 2 state: waiting for completed aio requests (read thread)
    I/O thread 3 state: waiting for completed aio requests (read thread)
    I/O thread 4 state: waiting for completed aio requests (read thread)
    I/O thread 5 state: waiting for completed aio requests (read thread)
    I/O thread 6 state: waiting for completed aio requests (write thread)
    I/O thread 7 state: waiting for completed aio requests (write thread)
    I/O thread 8 state: waiting for completed aio requests (write thread)
    I/O thread 9 state: waiting for completed aio requests (write thread)
    Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
     ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
    Pending flushes (fsync) log: 0; buffer pool: 0
    1131625 OS file reads, 123091 OS file writes, 38091 OS fsyncs
    184.21 reads/s, 16384 avg bytes/read, 6.03 writes/s, 1.69 fsyncs/s
    -------------------------------------
    INSERT BUFFER AND ADAPTIVE HASH INDEX
    -------------------------------------
    Ibuf: size 1, free list len 365, seg size 367, 7071 merges
    merged operations:
     insert 12566, delete mark 31, delete 0
    discarded operations:
     insert 0, delete mark 0, delete 0
    Hash table size 276707, node heap has 122 buffer(s)
    10583.53 hash searches/s, 165.57 non-hash searches/s
    ---
    LOG
    ---
    Log sequence number 4102504119
    Log flushed up to   4102504119
    Last checkpoint at  4102504119
    0 pending log writes, 0 pending chkp writes
    15967 log i/o's done, 0.79 log i/o's/second
    ----------------------
    BUFFER POOL AND MEMORY
    ----------------------
    Total memory allocated 137363456; in additional pool allocated 0
    Dictionary memory allocated 12677171
    Buffer pool size   8192
    Free buffers       0
    Database pages     8070
    Old database pages 2958
    Modified db pages  0
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 1119713, not young 0
    15000.00 youngs/s, 0.00 non-youngs/s
    Pages read 1128152, created 8419, written 97569
    15000.00 reads/s, 0.00 creates/s, 0.00 writes/s
    Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 8070, unzip_LRU len: 0
    I/O sum[11268]:cur[16], unzip sum[0]:cur[0]
    --------------
    ROW OPERATIONS
    --------------
    0 queries inside InnoDB, 0 queries in queue
    2 read views open inside InnoDB
    Main thread process no. 4573, id 3266629908224, state: sleeping
    Number of rows inserted 21608, updated 31722, deleted 1697, read 289696676
    0.31 inserts/s, 0.15 updates/s, 0.23 deletes/s, 11752.63 reads/s
    ----------------------------
    END OF INNODB MONITOR OUTPUT
    ============================
    
    
    ----------------------------
    MySQL Error Log
    ----------------------------
    
    140524 21:18:47 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:22:05 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:23:11 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:24:30 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:31:54 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:33:15 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:33:19 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:33:19 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:34:40 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:35:06 [Warning] Access denied for user 'spiry'@'localhost' (using password: YES)
    140524 21:38:08 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:39:36 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:41:50 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:44:16 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    140524 21:44:58 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
    
    Report Complete:
    Sat May 24 21:52:06 EDT 2014
    ----------------------------
    
    I guess what I am asking for is based on there two reports -- what should my MY.CNF look like.

    Thanks again and Thanks for the reply:)
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,724
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    To clarify, are you simply asking for suggested entries in the /etc/my.cnf file? For instance, are you asking how "query_cache_size (> 32M)" should look in /etc/my.cnf, or did you already add the entry before running the tuner for the second time?

    Thank you.
     
  5. cfhoagland

    cfhoagland Registered

    Joined:
    May 23, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    Exactly -- I am looking for what my.cnf should look like. What I should add etc. I have done nothing to the my.cnf since install and such. I'd like to know a suggested my.cnf file for my server based on the results above. I'm far from an admin, and am lost as to what my.cnf should look like. I am almost sure this is causing problems as my server ( and its a powerful system with a lot of RAM and HD ) keeps locking up, at random times. I do not know why and we have tested multiple times the actual hardware. So its got to be something here. All of a sudden at random times the load just sky rockets and locks. Plus I know the my.cnf file is the generic one.

    So YES PLEASE. Any idea what a my.cnf file should look like based on the outputs I posted earlier.

    Thanks so much!
     
Loading...

Share This Page