Skip to main content

Help with optimizing MySQL - already ran MySQlTuner

cfhoagland
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. [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 [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!

Comments

4 comments

Date Votes
  • gopkris2005
    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) [quote="cfhoagland, post: 1651121">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. [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 [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!
    0
  • cfhoagland
    [quote="gopkris2005, post: 1651392">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 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 >> 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: ------------------------------------------------------------- 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 # # # #* 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 StartServers 5 MinSpareServers 5 MaxSpareServers 10 MinSpareServers 5 MaxSpareServers 10 ServerLimit 2048 MaxClients 150 MaxRequestsPerChild 10000 ---------------------------- 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:)
    0
  • cPanelMichael
    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.
    0
  • cfhoagland
    [quote="cPanelMichael, post: 1651711">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!
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post