Help with optimizing MySQL - already ran MySQlTuner

cfhoagland

Registered
May 23, 2014
3
0
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!
 

gopkris2005

Well-Known Member
Jan 9, 2007
64
0
156
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)


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!
 

cfhoagland

Registered
May 23, 2014
3
0
1
cPanel Access Level
DataCenter Provider
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)

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 <[email protected]>
 >>  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:)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,237
463
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.
 

cfhoagland

Registered
May 23, 2014
3
0
1
cPanel Access Level
DataCenter Provider
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.
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!