Hi all,
I think I have some problem with my MySQL configuration.
If someone could give me his opinion I am taking all the criticism !
My my.cnf (shame on me...)
./mysqltuner.pl
./mysqlmymonlite.sh run
Thanks in advance !
I think I have some problem with my MySQL configuration.
If someone could give me his opinion I am taking all the criticism !
My my.cnf (shame on me...)
Code:
[mysqld]
innodb_file_per_table=1
open_files_limit=50000./mysqltuner.pl
Code:
[18:44:41] root@* [~]# ./mysqltuner.pl
>> MySQLTuner 1.2.1 mod - Major Hayden <[email protected]>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Modified by George Liu (eva2000) at http://vbtechsupport.com/
>> Run with '--help' for additional options and output filtering
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.35-cll
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 6G (Tables: 36616)
[--] Data in InnoDB tables: 2G (Tables: 17990)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 1M (Tables: 141)
[!!] Total fragmented tables: 1136
-------- Security Recommendations -------------------------------------------
[!!] User 'spa**_preau@**.**.**.**' has no password set.
[!!] User 'spa**_preau@**.**.**.**' has no password set.
[!!] User 'spa**_preau@***.fr' has no password set.
[!!] User 'spa**_preau@***.fr' has no password set.
[!!] User 'spa**_preau@localhost' has no password set.
-------- Performance Metrics -------------------------------------------------
[--] Up for: 2d 18h 35m 57s (66M q [277.076 qps], 1M conn, TX: 637B, RX: 9B)
[--] Reads / Writes: 92% / 8%
[--] Total buffers: 168.0M global + 2.8M per thread (151 max threads)
[OK] Maximum possible memory usage: 583.2M (1% of installed RAM)
[OK] Slow queries: 0% (936/66M)
[OK] Highest usage of available connections: 53% (81/151)
[OK] Key buffer size / total MyISAM indexes: 8.0M/2.0G
[OK] Key buffer hit rate: 99.8% (4B cached / 9M reads)
[!!] Query cache is disabled. In certain usage cases you may want to leave Query cache disabled i.e. InnoDB table usage
[OK] Sorts requiring temporary tables: 0% (8K temp sorts / 9M sorts)
[!!] Joins performed without indexes: 36654
[OK] Temporary tables created on disk: 22% (912K on disk / 4M total)
[!!] Thread cache is disabled
[!!] Table cache hit rate: 0% (400 open / 90M opened)
[OK] Open file limit used: 1% (576/50K)
[OK] Table locks acquired immediately: 99% (71M immediate / 71M locks)
[!!] Connections aborted: 14%
[!!] InnoDB data size / buffer pool: 2.2G/128.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Enable the slow query log to troubleshoot bad queries.
Do not forget to disable slow query logging after troubleshooting
- For MySQL 5.0 http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
- For MySQL 5.1 http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
- For MySQL 5.5 http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html
- For MySQL 5.6 http://dev.mysql.com/doc/refman/5.6/en/slow-query-log.html
Adjust your join queries to always utilize indexes
Set thread_cache_size to 4 as a starting value
Increase table_cache gradually to avoid file descriptor limits
Your applications are not closing MySQL connections properly
Variables to adjust:
query_cache_size (>= 8M)
join_buffer_size (> 128.0K, or always use indexes with joins)
thread_cache_size (start at 4)
table_cache (> 400, table_open_cache hit rate <20%)
innodb_buffer_pool_size (>= 2G, innodb data size is larger than innodb_buffer_size, set innodb_buffer_pool_size appropriately)./mysqlmymonlite.sh run
Code:
[19:07:56] root@*** [~/tools]# ./mysqlmymonlite.sh run
-------------------------------------------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - 0.5.0 WHM mysqlmymon.com
compiled by George Liu (eva2000) vbtechsupport.com
-------------------------------------------------------------
Report Generated:
Sat Feb 1 19:07:59 CET 2014
----------------------------
MySQL Uptime:
----------------------------
MySQL server was started 2014-01-30 00:08:55
Uptime: 2 days 18 hours 59 min 4 sec
Uptime 241144
Uptime_since_flush_status 241144
Max Used Connections: 81/151 (53.64%)
Key Buffer Used: 6.54M/8.00M (81.76%)
Current Key Buffer Usage: 6.19M (77.37%)
InnoDB Buffer Pool: 128.00M/128.00M (100.00%)
Table Locks Waited: 26.27k Rate: 0.1/s (0.04%)
--------------------
Query Cache Limit (bytes): 1048576
Query Cache Min Unit (bytes): 4096
Query Cache Size (bytes): 0
Query Cache Free Mem (bytes): 0
Query Cache Used Mem (bytes): 0
Queries in Query Cache: 1
Query Cache Avg Size (bytes): 0
----------------------------
Hardware Info:
----------------------------
Processors physical = 1, cores = 4, virtual = 4, hyperthreading = no
4 3400.201
4 Intel(R) Xeon(R) CPU E3-1245 V2 @ 3.40GHz
4 8192 KB
----------------------------
TOP stats
----------------------------
Linux 2.6.32-042stab083.2 ((yourserverhostname)) 02/01/14 _x86_64_(8 CPU)
19:07:59 CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
19:08:01 all 1.01 56.46 39.37 0.13 0.00 0.00 0.25 0.00 2.78
19:08:01 0 0.90 58.11 38.29 0.00 0.00 0.00 0.90 0.00 1.80
19:08:01 1 0.00 57.67 38.10 0.00 0.00 0.00 0.53 0.00 3.70
19:08:01 2 3.03 55.56 38.89 0.00 0.00 0.00 0.00 0.00 2.53
19:08:01 3 0.00 54.35 42.39 0.00 0.00 0.00 0.00 0.00 3.26
19:08:01 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
19:08:01 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
19:08:01 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
19:08:01 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
19:08:01 CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
19:08:03 all 0.00 59.26 36.55 0.00 0.00 0.00 0.13 0.00 4.06
19:08:03 0 0.00 63.10 32.62 0.00 0.00 0.00 0.00 0.00 4.28
19:08:03 1 0.00 59.72 37.44 0.00 0.00 0.00 0.00 0.00 2.84
19:08:03 2 0.00 63.04 30.98 0.00 0.00 0.00 0.00 0.00 5.98
19:08:03 3 0.00 52.74 44.28 0.00 0.00 0.00 0.00 0.00 2.99
19:08:03 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
19:08:03 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
19:08:03 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
19:08:03 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Average: CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
Average: all 0.51 57.86 37.96 0.06 0.00 0.00 0.19 0.00 3.42
Average: 0 0.49 60.39 35.70 0.00 0.00 0.00 0.49 0.00 2.93
Average: 1 0.00 58.75 37.75 0.00 0.00 0.00 0.25 0.00 3.25
Average: 2 1.57 59.16 35.08 0.00 0.00 0.00 0.00 0.00 4.19
Average: 3 0.00 53.51 43.38 0.00 0.00 0.00 0.00 0.00 3.12
Average: 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Average: 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Average: 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Average: 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
top - 19:08:03 up 74 days, 7:26, 1 user, load average: 2.31, 2.78, 3.07
Tasks: 133 total, 3 running, 123 sleeping, 1 stopped, 6 zombie
Cpu(s): 0.0%us, 0.6%sy, 2.0%ni, 12.4%id, 85.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 31457280k total, 21736440k used, 9720840k free, 0k buffers
Swap: 31457280k total, 404000k used, 31053280k free, 15573028k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
27115 user1 24 4 219m 32m 8172 S 23.8 0.1 0:00.76 php
27093 user1 24 4 0 0 0 Z 11.9 0.0 0:00.42 php <defunct>
27185 user2 24 4 203m 15m 7884 R 7.9 0.0 0:00.04 php
13342 nobody 24 4 1331m 74m 11m S 4.0 0.2 0:05.96 httpd
22288 nobody 24 4 1331m 64m 2504 S 4.0 0.2 0:02.03 httpd
3183 mysql 26 6 2569m 400m 5924 S 2.0 1.3 1184:02 mysqld
22583 mailman 28 8 194m 10m 3584 S 2.0 0.0 0:01.80 python
26094 nobody 24 4 1331m 62m 2420 S 2.0 0.2 0:00.38 httpd
27180 user3 24 4 0 0 0 Z 2.0 0.0 0:00.01 php <defunct>
27182 user4 24 4 200m 12m 7220 S 2.0 0.0 0:00.01 php
27183 user3 24 4 0 0 0 Z 2.0 0.0 0:00.01 php <defunct>
27190 user5 24 4 201m 12m 7228 R 2.0 0.0 0:00.01 php
1 root 20 0 19232 492 356 S 0.0 0.0 0:23.04 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd/121
3 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khelper/121
481 user6 30 10 214m 7008 6964 S 0.0 0.0 0:53.32 php
592 user7 30 10 136m 1164 724 S 0.0 0.0 0:06.51 pure-ftpd
593 root 30 10 135m 364 216 S 0.0 0.0 0:00.00 pure-ftpd
789 user8 30 10 202m 5936 5932 S 0.0 0.0 0:59.47 php
1177 user7 30 10 136m 1016 660 S 0.0 0.0 0:06.41 pure-ftpd
1178 root 30 10 135m 364 216 S 0.0 0.0 0:00.00 pure-ftpd
1309 root 20 0 64308 200 196 S 0.0 0.0 0:00.00 saslauthd
1342 root 20 0 64308 24 20 S 0.0 0.0 0:00.00 saslauthd
1436 root 30 10 132m 152 92 S 0.0 0.0 1:08.34 pure-uploadscri
1565 nobody 24 4 171m 55m 868 S 0.0 0.2 0:00.05 httpd
1566 root 28 8 80200 10m 2952 S 0.0 0.0 0:00.05 leechprotect
1703 root 20 0 21456 216 192 S 0.0 0.0 0:00.05 atd
2266 nobody 24 4 1317m 74m 11m S 0.0 0.2 0:04.94 httpd
2808 user9 20 0 23388 2848 2184 S 0.0 0.0 0:00.01 imap
2813 user10 20 0 23292 2444 2036 S 0.0 0.0 0:00.00 imap
2924 root 16 -4 10644 188 184 S 0.0 0.0 0:00.00 udevd
3064 root 20 0 11308 1228 1224 S 0.0 0.0 0:00.00 mysqld_safe
5009 root 20 0 66608 500 408 S 0.0 0.0 0:00.03 sshd
5218 root 20 0 237m 5092 836 S 0.0 0.0 2:47.37 rsyslogd
5530 root 30 10 135m 716 624 S 0.0 0.0 0:03.77 pure-ftpd
5535 root 28 8 133m 988 944 S 0.0 0.0 0:03.08 pure-authd
5619 nobody 24 4 1333m 75m 11m S 0.0 0.2 0:06.18 httpd
5976 user8 30 10 202m 5940 5936 S 0.0 0.0 0:59.45 php
6700 user6 30 10 214m 7008 6964 S 0.0 0.0 0:52.83 php
6782 user8 30 10 202m 6888 5936 S 0.0 0.0 0:59.86 php
6862 nobody 24 4 1259m 72m 10m S 0.0 0.2 0:03.02 httpd
8306 user11 30 10 135m 864 636 S 0.0 0.0 0:00.00 pure-ftpd
8307 root 30 10 135m 364 216 S 0.0 0.0 0:00.00 pure-ftpd
9351 user6 30 10 214m 7012 6968 S 0.0 0.0 0:53.00 php
9355 user8 30 10 202m 5936 5932 S 0.0 0.0 0:59.47 php
9619 user6 30 10 212m 7008 6964 S 0.0 0.0 0:39.34 php
10031 user12 30 10 136m 892 664 S 0.0 0.0 0:00.10 pure-ftpd
10032 root 30 10 135m 364 216 S 0.0 0.0 0:00.00 pure-ftpd
10189 user13 20 0 23300 2648 2024 S 0.0 0.0 0:00.00 imap
11421 nobody 24 4 1331m 64m 2480 S 0.0 0.2 0:00.87 httpd
11584 user12 30 10 135m 932 696 S 0.0 0.0 0:00.11 pure-ftpd
11585 root 30 10 135m 364 216 S 0.0 0.0 0:00.00 pure-ftpd
11724 cpanelro 20 0 100m 17m 2920 S 0.0 0.1 0:00.02 cpsrvd-ssl
13087 root 20 0 100m 20m 5804 S 0.0 0.1 1:06.60 cpsrvd-ssl
13219 nobody 24 4 1291m 73m 11m S 0.0 0.2 0:02.72 httpd
13543 root 20 0 15612 1372 824 T 0.0 0.0 0:02.66 find
14959 nobody 24 4 1179m 64m 3420 S 0.0 0.2 0:01.56 httpd
16480 named 20 0 477m 63m 1980 S 0.0 0.2 11:42.62 named
17600 nobody 24 4 1235m 71m 10m S 0.0 0.2 0:01.09 httpd
19078 root 20 0 98300 4096 3096 S 0.0 0.0 0:00.02 sshd
19149 root 20 0 57808 2324 1620 S 0.0 0.0 0:00.00 sftp-server
19198 root 28 8 141m 4080 1320 S 0.0 0.0 2:53.85 /usr/local/cpan
19374 nobody 24 4 1243m 63m 2492 S 0.0 0.2 0:01.38 httpd
19448 root 20 0 98300 4396 3420 S 0.0 0.0 0:00.01 sshd
19462 nobody 24 4 1283m 65m 2520 S 0.0 0.2 0:03.18 httpd
19555 root 20 0 19600 1152 836 S 0.0 0.0 0:00.66 dovecot
19590 dovenull 20 0 42464 3556 2692 S 0.0 0.0 0:00.05 pop3-login
19591 dovenull 20 0 42468 3672 2700 S 0.0 0.0 0:00.32 imap-login
19592 dovecot 20 0 13304 1128 936 S 0.0 0.0 0:00.21 anvil
19593 root 20 0 13436 1316 976 S 0.0 0.0 0:00.36 log
19595 dovenull 20 0 42464 3624 2692 S 0.0 0.0 0:00.21 pop3-login
19596 root 20 0 16392 2144 1128 S 0.0 0.0 0:00.64 config
19597 dovenull 20 0 42840 3960 2748 S 0.0 0.0 0:00.77 imap-login
19598 dovecot 20 0 29432 1992 1432 S 0.0 0.0 0:01.08 auth
19640 user6 30 10 214m 7008 6964 S 0.0 0.0 0:52.83 php
19645 user6 30 10 214m 7008 6964 S 0.0 0.0 0:53.17 php
19700 root 20 0 11444 1820 1416 S 0.0 0.0 0:00.00 bash
19740 root 28 8 188m 76m 3300 S 0.0 0.2 0:09.03 spamd child
20436 nobody 24 4 1267m 65m 2500 S 0.0 0.2 0:01.81 httpd
20492 user6 30 10 214m 7008 6964 S 0.0 0.0 0:53.36 php
20733 user8 30 10 200m 5936 5932 S 0.0 0.0 0:59.41 php
21451 nobody 24 4 1331m 73m 10m S 0.0 0.2 0:02.33 httpd
22382 user14 30 10 136m 964 696 S 0.0 0.0 0:00.04 pure-ftpd
22383 root 30 10 135m 364 216 S 0.0 0.0 0:00.00 pure-ftpd
22410 root 20 0 36280 3532 1428 S 0.0 0.0 0:01.05 queueprocd - wa
22490 root 20 0 114m 3248 1136 S 0.0 0.0 0:02.96 dnsadmin - serv
22543 cpanelro 20 0 100m 17m 2920 S 0.0 0.1 0:00.01 cpsrvd-ssl
22569 mailman 28 8 199m 8692 860 S 0.0 0.0 0:00.00 mailmanctl
22571 root 20 0 81536 9.8m 1620 S 0.0 0.0 0:30.02 tailwatchd
22577 mailman 28 8 194m 10m 3584 S 0.0 0.0 0:01.76 python
22578 mailman 28 8 195m 10m 3584 S 0.0 0.0 0:01.94 python
22579 mailman 28 8 194m 10m 3584 S 0.0 0.0 0:01.88 python
22580 mailman 28 8 195m 10m 3584 S 0.0 0.0 0:01.75 python
22581 mailman 28 8 195m 10m 3584 S 0.0 0.0 0:01.79 python
22582 mailman 28 8 195m 11m 3584 S 0.0 0.0 0:01.94 python
22584 mailman 28 8 194m 10m 3584 S 0.0 0.0 0:00.05 python
22617 root 20 0 71716 3208 2848 S 0.0 0.0 0:08.20 cPhulkd - proce
22662 root 20 0 23528 2148 1428 S 0.0 0.0 0:26.84 cpdavd-dormant
22717 root 24 4 171m 66m 11m S 0.0 0.2 0:04.30 httpd
22743 root 38 18 27252 2520 1164 S 0.0 0.0 0:00.23 cpanellogd - sl
22996 root 20 0 11444 724 316 S 0.0 0.0 0:00.00 bash
22997 root 20 0 4076 560 472 S 0.0 0.0 0:00.00 tee
22998 root 20 0 4064 660 564 S 0.0 0.0 0:00.00 logger
23177 root 28 8 429m 237m 5688 S 0.0 0.8 2:05.58 clamd
23195 mailnull 28 8 71536 2976 704 S 0.0 0.0 0:00.11 exim
23238 root 28 8 161m 49m 3296 S 0.0 0.2 0:02.86 /usr/local/cpan
23535 user6 30 10 214m 7008 6964 S 0.0 0.0 0:53.19 php
24386 user6 30 10 214m 7004 6960 S 0.0 0.0 0:52.66 php
25211 root 20 0 19408 1528 1180 S 0.0 0.0 0:00.00 ssl-params
25741 user6 30 10 214m 7004 6960 S 0.0 0.0 0:53.41 php
25762 cpanelro 20 0 100m 17m 2920 S 0.0 0.1 0:00.01 cpsrvd-ssl
25821 user6 30 10 214m 7004 6960 S 0.0 0.0 0:52.50 php
25962 root 28 8 148m 6264 1424 S 0.0 0.0 1:55.08 lfd - sleeping
26690 user2 24 4 0 0 0 Z 0.0 0.0 0:00.13 php <defunct>
26696 user2 24 4 0 0 0 Z 0.0 0.0 0:00.11 php <defunct>
26698 user2 24 4 0 0 0 Z 0.0 0.0 0:00.14 php <defunct>
26730 root 20 0 11444 728 316 S 0.0 0.0 0:00.00 bash
26732 root 20 0 4076 560 472 S 0.0 0.0 0:00.00 tee
26733 root 20 0 4064 656 564 S 0.0 0.0 0:00.00 logger
26775 root 20 0 9692 1896 1148 S 0.0 0.0 0:00.00 mysqlmymonlite.
27173 root 20 0 15028 1188 880 R 0.0 0.0 0:00.00 top
27355 nobody 24 4 1299m 65m 3120 S 0.0 0.2 0:04.58 httpd
28192 cpanelro 28 8 100m 18m 2920 S 0.0 0.1 0:00.02 cpsrvd-ssl
28298 user15 30 10 135m 888 664 S 0.0 0.0 0:00.01 pure-ftpd
28299 root 30 10 135m 364 216 S 0.0 0.0 0:00.00 pure-ftpd
28337 cpanelro 28 8 100m 18m 2920 S 0.0 0.1 0:00.02 cpsrvd-ssl
28916 root 20 0 114m 1128 644 S 0.0 0.0 0:05.76 crond
30407 user8 30 10 202m 5940 5936 S 0.0 0.0 0:59.55 php
31393 root 20 0 98300 4112 3096 S 0.0 0.0 0:00.05 sshd
31436 root 20 0 57816 2360 1620 S 0.0 0.0 0:00.76 sftp-server
31529 user15 30 10 135m 936 700 S 0.0 0.0 0:00.01 pure-ftpd
31530 root 30 10 135m 364 216 S 0.0 0.0 0:00.00 pure-ftpd
32525 user16 20 0 23304 2640 2036 S 0.0 0.0 0:00.00 imap
total used free shared buffers cached
Mem: 30720 21207 9512 0 0 15208
Low: 30720 21207 9512
High: 0 0 0
-/+ buffers/cache: 5999 24720
Swap: 30720 394 30325
MemTotal: 31457280 kB
MemFree: 9740852 kB
Cached: 15573044 kB
Buffers: 0 kB
Active: 10644780 kB
Inactive: 6177008 kB
Active(anon): 880144 kB
Inactive(anon): 368600 kB
Active(file): 9764636 kB
Inactive(file): 5808408 kB
Unevictable: 0 kB
Mlocked: 0 kB
SwapTotal: 31457280 kB
SwapFree: 31053280 kB
Dirty: 4700 kB
Writeback: 0 kB
AnonPages: 1248744 kB
Shmem: 15960 kB
Slab: 4894580 kB
SReclaimable: 4848548 kB
SUnreclaim: 46032 kB
Private + Shared = RAM usedProgram
4.0 KiB + 17.5 KiB = 21.5 KiBudevd
52.0 KiB + 56.0 KiB = 108.0 KiBpure-authd
56.0 KiB + 64.5 KiB = 120.5 KiBatd
64.0 KiB + 60.5 KiB = 124.5 KiBpure-uploadscript
8.0 KiB + 177.5 KiB = 185.5 KiBmysqld_safe
0.0 KiB + 192.0 KiB = 192.0 KiBsaslauthd (2)
176.0 KiB + 47.0 KiB = 223.0 KiBtee (2)
188.0 KiB + 37.0 KiB = 225.0 KiBlogger (2)
208.0 KiB + 47.0 KiB = 255.0 KiBanvil
240.0 KiB + 99.0 KiB = 339.0 KiBinit
356.0 KiB + 50.0 KiB = 406.0 KiBlog
360.0 KiB + 60.5 KiB = 420.5 KiBssl-params
376.0 KiB + 55.5 KiB = 431.5 KiBdovecot
528.0 KiB + 33.5 KiB = 561.5 KiBcrond
664.0 KiB + 29.0 KiB = 693.0 KiBfind
360.0 KiB + 350.5 KiB = 710.5 KiBcPhulkd - proce
804.0 KiB + 77.0 KiB = 881.0 KiBauth
756.0 KiB + 172.5 KiB = 928.5 KiBmysqlmymonlite.
844.0 KiB + 145.0 KiB = 989.0 KiBcpdavd-dormant
1.1 MiB + 56.0 KiB = 1.1 MiBconfig
684.0 KiB + 498.5 KiB = 1.2 MiBbash (3)
1.3 MiB + 113.5 KiB = 1.4 MiBcpanellogd - sl
1.4 MiB + 295.0 KiB = 1.7 MiBsftp-server (2)
1.8 MiB + 359.0 KiB = 2.1 MiBpop3-login (2)
2.1 MiB + 186.0 KiB = 2.2 MiBdnsadmin - serv
2.1 MiB + 132.0 KiB = 2.3 MiBqueueprocd - wa
2.4 MiB + 69.5 KiB = 2.5 MiBexim
2.1 MiB + 376.0 KiB = 2.5 MiBimap-login (2)
2.4 MiB + 1.2 MiB = 3.6 MiBimap (4)
2.6 MiB + 1.0 MiB = 3.6 MiBpure-ftpd (17)
4.4 MiB + 43.0 KiB = 4.4 MiBrsyslogd
3.1 MiB + 1.4 MiB = 4.5 MiBsshd (4)
4.7 MiB + 148.0 KiB = 4.9 MiBlfd - sleeping
7.7 MiB + 138.5 KiB = 7.8 MiBmailmanctl
7.6 MiB + 385.0 KiB = 8.0 MiBleechprotect
8.2 MiB + 250.5 KiB = 8.5 MiBtailwatchd
16.4 MiB + 14.7 MiB = 31.1 MiBcpsrvd-ssl (6)
27.8 MiB + 11.5 MiB = 39.4 MiB/usr/local/cpan (2)
33.1 MiB + 7.4 MiB = 40.4 MiBphp (18)
59.6 MiB + 2.4 MiB = 62.0 MiBpython (8)
62.2 MiB + 103.0 KiB = 62.3 MiBnamed
52.0 MiB + 11.3 MiB = 63.3 MiBspamd child
134.1 MiB + 66.1 MiB = 200.2 MiBhttpd (17)
236.8 MiB + 53.0 KiB = 236.9 MiBclamd
399.2 MiB + 191.5 KiB = 399.4 MiBmysqld
---------------------------------
1.2 GiB
=================================
Private + Shared = RAM usedProgram
----------------------------
Server Disk Usage
----------------------------
Filesystem Type Size Used Avail Use% Mounted on
/dev/simfs simfs 1.5T 975G 526G 65% /
none devtmpfs 15G 4.0K 15G 1% /dev
none tmpfs 15G 0 15G 0% /dev/shm
/dev/simfs simfs 1.5T 975G 526G 65% /home
----------------------------
MySQL datadir disk usage
----------------------------
/var/lib/mysql/ uses 18040220 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) 255461
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/3183/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 8388608 bytes
Max core file size 0 0 bytes
Max resident set unlimited unlimited bytes
Max processes 14335 14335 processes
Max open files 50000 50000 files
Max locked memory 65536 65536 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 255461 255461 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
----------------------------------
CPANEL WEB SERVER & PHP Info:
----------------------------------
WHM / Cpanel version: 11.42.0.1
WHM's PHP Handler config:
/usr/local/cpanel/bin/rebuild_phpconf --current
Available handlers: suphp cgi none
DEFAULT PHP: 5
PHP4 SAPI: none
PHP5 SAPI: suphp
SUEXEC: enabled
RUID2: not installed
PHP 5.4.23 (cli) (built: Dec 27 2013 14:01:04)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
with the ionCube PHP Loader v4.4.1, Copyright (c) 2002-2013, by ionCube Ltd., and
with Zend Guard Loader v3.3, Copyright (c) 1998-2013, by Zend Technologies
System => Linux yourserverhostname 2.6.32-042stab083.2 #1 SMP Fri Nov 8 18:08:40 MSK 2013 x86_64
Build Date => Dec 27 2013 13:59:35
Configure Command => './configure' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-zip' '--prefix=/usr/local' '--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-libexpat-dir=/usr' '--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-tidy=/opt/tidy/' '--with-xmlrpc' '--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 | 20100412
Zend Extension Build | API220100525,NTS
PHP Extension Build | API20100525,NTS
DOM/XML API Version | 20031129
Client API version | 5.5.35
Client API library version | 5.5.35
Client API header version | 5.5.34
API Extensions | pdo_mysql
Client API version | mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
Phar API version | 1.1.1
display_errors | Off | Off
error_log | error_log | error_log
extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20100525 | /usr/local/lib/php/extensions/no-debug-non-zts-20100525
file_uploads | On | On
log_errors | On | On
log_errors_max_len | 1024 | 1024
max_execution_time | 0 | 0
max_file_uploads | 20 | 20
memory_limit | 320M | 320M
open_basedir | /home:/usr:/tmp:/var/netenberg | /home:/usr:/tmp:/var/netenberg
post_max_size | 20M | 20M
realpath_cache_size | 16K | 16K
realpath_cache_ttl | 120 | 120
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
sql.safe_mode | Off | Off
upload_max_filesize | 20M | 20M
upload_tmp_dir | no value | no value
sqlite3.extension_dir | no value | no value
cURL support | enabled
cURL Information | 7.24.0
ZLib Version | 1.2.3
GD Support | enabled
GD Version | bundled (2.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
Server version: Apache/2.2.26 (Unix)
Server built: Dec 27 2013 13:55:28
Cpanel::Easy::Apache v3.22.25 rev9999
Server's Module Magic Number: 20051115:33
Server loaded: APR 1.4.8, APR-Util 1.5.2
Compiled using: APR 1.4.8, APR-Util 1.5.2
Architecture: 64-bit
Server MPM: Worker
threaded: yes (fixed thread count)
forked: yes (variable process count)
Server compiled with....
-D APACHE_MPM_DIR="server/mpm/worker"
-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_SCOREBOARD="logs/apache_runtime_status"
-D DEFAULT_ERRORLOG="logs/error_log"
-D AP_TYPES_CONFIG_FILE="conf/mime.types"
-D SERVER_CONFIG_FILE="conf/httpd.conf"
WARNING: MaxClients (500) is not an integer multiple
of ThreadsPerChild (15), lowering MaxClients to 495
for a maximum of 33 child processes,
Warning: DocumentRoot [/home/***/public_html/****/sub/interspire] does not exist
Warning: DocumentRoot [/home/***/public_html/****/sub/solecart] does not exist
Loaded Modules:
core_module (static)
authn_file_module (static)
authn_default_module (static)
authz_host_module (static)
authz_groupfile_module (static)
authz_user_module (static)
authz_default_module (static)
auth_basic_module (static)
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)
logio_module (static)
env_module (static)
expires_module (static)
headers_module (static)
unique_id_module (static)
setenvif_module (static)
version_module (static)
proxy_module (static)
proxy_connect_module (static)
proxy_ftp_module (static)
proxy_http_module (static)
proxy_scgi_module (static)
proxy_ajp_module (static)
proxy_balancer_module (static)
ssl_module (static)
mpm_worker_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)
cgid_module (static)
dav_fs_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)
bwlimited_module (shared)
suphp_module (shared)
security2_module (shared)
Syntax OK
Compiled in modules:
core.c
mod_authn_file.c
mod_authn_default.c
mod_authz_host.c
mod_authz_groupfile.c
mod_authz_user.c
mod_authz_default.c
mod_auth_basic.c
mod_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_logio.c
mod_env.c
mod_expires.c
mod_headers.c
mod_unique_id.c
mod_setenvif.c
mod_version.c
mod_proxy.c
mod_proxy_connect.c
mod_proxy_ftp.c
mod_proxy_http.c
mod_proxy_scgi.c
mod_proxy_ajp.c
mod_proxy_balancer.c
mod_ssl.c
worker.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_cgid.c
mod_dav_fs.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 500
MaxClients 500
MaxRequestsPerChild 10000
</IfModule>
----------------------------
mysqlreport output
----------------------------
MySQL 5.5.35-cll uptime 2 18:59:11 Sat Feb 1 19:08:06 2014
__ Key _________________________________________________________________
Buffer used 6.54M of 8.00M %Used: 81.76
Current 5.82M %Usage: 72.80
Write hit 99.67%
Read hit 99.77%
__ Questions ___________________________________________________________
Total 66.95M 277.6/s
DMS 59.70M 247.6/s %Total: 89.17
Com_ 7.66M 31.8/s 11.44
-Unknown 2.32M 9.6/s 3.47
COM_QUIT 1.92M 8.0/s 2.86
Slow 10 s 944 0.0/s 0.00 %DMS: 0.00 Log: OFF
DMS 59.70M 247.6/s 89.17
SELECT 55.37M 229.6/s 82.69 92.74
UPDATE 1.96M 8.1/s 2.92 3.28
DELETE 1.04M 4.3/s 1.56 1.75
INSERT 1.04M 4.3/s 1.55 1.74
REPLACE 300.13k 1.2/s 0.45 0.50
Com_ 7.66M 31.8/s 11.44
set_option 2.76M 11.4/s 4.12
change_db 1.70M 7.1/s 2.54
stmt_prepar 536.29k 2.2/s 0.80
__ Rows ________________________________________________________________
Rows 53.07G 220.1k/s
Using idx 23.48G 97.4k/s %Index: 44.25
Rows/question 792.61
__ SELECT and Sort _____________________________________________________
Scan 13.21M 54.8/s %SELECT: 23.85
Range 1.16M 4.8/s 2.09
Full join 35.72k 0.1/s 0.06
Range check 1.07k 0.0/s 0.00
Full rng join 355 0.0/s 0.00
Sort scan 7.20M 29.9/s
Sort range 2.45M 10.2/s
Sort mrg pass 8.61k 0.0/s
__ Table Locks _________________________________________________________
Waited 26.27k 0.1/s %Total: 0.04
Immediate 71.58M 296.8/s
__ Tables ______________________________________________________________
Open 400 of 400 %Cache: 100.00
Opened 91.13M 377.9/s
__ Connections _________________________________________________________
Max used 81 of 151 %Max: 53.64
Total 1.92M 8.0/s
__ Created Temp ________________________________________________________
Disk table 916.25k 3.8/s %Disk: 29.13
Table 3.14M 13.0/s Size: 16.0M
File 17.80k 0.1/s
__ Threads _____________________________________________________________
Running 2 of 5
Created 1.92M 8.0/s
Slow 0 0/s
Cached 0 of 0 %Hit: 0.02
__ Aborted _____________________________________________________________
Clients 848 0.0/s
Connects 274.25k 1.1/s
__ Bytes _______________________________________________________________
Sent 644.06G 2.7M/s
Received 9.11G 37.8k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 128.00M of 128.00M %Usage: 100.00
Read hit 95.59%
Pages
Free 0 %Total: 0.00
Data 8.14k 99.43 %Drty: 0.95
Misc 47 0.57
Latched 0 0.00
Reads 1.89G 7.8k/s
From disk 83.22M 345.1/s %Disk: 4.41
Ahead Rnd 0 0/s
Writes 25.65M 106.3/s
Wait Free 0 0/s %Wait: 0.00
Flushes 1.80M 7.5/s
__ InnoDB Lock _________________________________________________________
Waits 33514 0.1/s
Current 0
Time acquiring
Total 1776787 ms
Average 53 ms
Max 15274 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 83.34M 345.6/s
Writes 2.61M 10.8/s
fsync 951.84k 3.9/s
Pending
Reads 0
Writes 0
fsync 1
Pages
Created 116.10k 0.5/s
Read 83.33M 345.5/s
Written 1.80M 7.5/s
Rows
Deleted 79.56k 0.3/s
Inserted 719.16k 3.0/s
Read 2.01G 8.3k/s
Updated 8.80M 36.5/s
----------------------------
Total Server MyISAM and InnoDB Size
----------------------------
*************************** 1. row ***************************
innodb_tablespace_utilization_perc: 100
total_size_gb: 11.246537491679192
index_size_gb: 2.6045795269310474
data_size_gb: 8.641957964748144
innodb_total_size_gb: 2.8715667724609375
innodb_data_size_gb: 2.2258453369140625
innodb_index_size_gb: 0.645721435546875
myisam_total_size_gb: 8.372694794088602
myisam_data_size_gb: 6.415046516805887
myisam_index_size_gb: 1.9576482772827148
perc_index: 23.158945800
perc_data: 76.841054100
innodb_perc_index: 22.486728900
innodb_perc_data: 77.513271000
myisam_perc_index: 23.381340400
myisam_perc_data: 76.618659500
innodb_perc_total_index: 24.791772600
innodb_perc_total_data: 25.756262000
myisam_perc_total_index: 75.161777800
myisam_perc_total_data: 74.231401500
----------------------------
MySQL settings
----------------------------
[mysqld]
innodb_file_per_table=1
open_files_limit=50000
---
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
| 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/***.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 | YES |
| 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.35 |
| 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 | ON |
| lock_wait_timeout | 31536000 |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| log_error | /var/lib/mysql/yourserverhostname.err |
| log_output | FILE |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
| 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 | 50000 |
| 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 | 0 |
| 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/***-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 | CET |
| 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.35-cll |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| wait_timeout | 28800 |
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
+------------------------------------------+---------------+
| Variable_name | Value |
+------------------------------------------+---------------+
| Aborted_clients | 848 |
| Aborted_connects | 274284 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 9112285334 |
| Bytes_sent | 644073885974 |
| Com_admin_commands | 57241 |
| 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 | 719 |
| Com_alter_tablespace | 0 |
| Com_analyze | 0 |
| Com_begin | 476 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db | 1700600 |
| Com_change_master | 0 |
| Com_check | 55245 |
| Com_checksum | 0 |
| Com_commit | 1267 |
| Com_create_db | 13 |
| Com_create_event | 0 |
| Com_create_function | 0 |
| Com_create_index | 272 |
| Com_create_procedure | 1 |
| Com_create_server | 0 |
| Com_create_table | 8577 |
| Com_create_trigger | 0 |
| Com_create_udf | 0 |
| Com_create_user | 2 |
| Com_create_view | 0 |
| Com_dealloc_sql | 24 |
| Com_delete | 1041821 |
| Com_delete_multi | 110 |
| Com_do | 0 |
| Com_drop_db | 7 |
| Com_drop_event | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 111 |
| Com_drop_procedure | 2 |
| Com_drop_server | 0 |
| Com_drop_table | 173 |
| Com_drop_trigger | 0 |
| Com_drop_user | 5 |
| Com_drop_view | 0 |
| Com_empty_query | 0 |
| Com_execute_sql | 24 |
| Com_flush | 31 |
| Com_grant | 1713 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 1027314 |
| Com_insert_select | 10465 |
| Com_install_plugin | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_lock_tables | 9297 |
| Com_optimize | 60 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 24 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_release_savepoint | 520 |
| Com_rename_table | 0 |
| Com_rename_user | 0 |
| Com_repair | 2 |
| Com_replace | 300142 |
| Com_replace_select | 5 |
| Com_reset | 0 |
| Com_resignal | 0 |
| Com_revoke | 2 |
| Com_revoke_all | 2 |
| Com_rollback | 38 |
| Com_rollback_to_savepoint | 36 |
| Com_savepoint | 556 |
| Com_select | 55370001 |
| Com_set_option | 2756930 |
| Com_signal | 0 |
| Com_show_authors | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 168 |
| Com_show_charsets | 125 |
| Com_show_client_statistics | 0 |
| Com_show_collations | 0 |
| Com_show_contributors | 0 |
| Com_show_create_db | 2706 |
| Com_show_create_event | 0 |
| Com_show_create_func | 0 |
| Com_show_create_proc | 9 |
| Com_show_create_table | 163549 |
| Com_show_create_trigger | 39 |
| Com_show_databases | 376 |
| Com_show_engine_logs | 0 |
| Com_show_engine_mutex | 0 |
| Com_show_engine_status | 0 |
| Com_show_events | 125 |
| Com_show_errors | 0 |
| Com_show_fields | 325445 |
| Com_show_function_status | 3603 |
| Com_show_grants | 20175 |
| Com_show_index_statistics | 0 |
| Com_show_keys | 630 |
| Com_show_master_status | 60 |
| Com_show_open_tables | 0 |
| Com_show_plugins | 0 |
| Com_show_privileges | 0 |
| Com_show_procedure_status | 3603 |
| Com_show_processlist | 808 |
| Com_show_profile | 0 |
| Com_show_profiles | 0 |
| Com_show_relaylog_events | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 60 |
| Com_show_status | 7209 |
| Com_show_storage_engines | 5 |
| Com_show_table_statistics | 0 |
| Com_show_table_status | 314450 |
| Com_show_tables | 65950 |
| Com_show_thread_statistics | 0 |
| Com_show_triggers | 152773 |
| Com_show_user_statistics | 0 |
| Com_show_variables | 1281 |
| Com_show_warnings | 38 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 511380 |
| Com_stmt_execute | 536447 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 536447 |
| Com_stmt_reprepare | 483 |
| Com_stmt_reset | 405760 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 727 |
| Com_uninstall_plugin | 0 |
| Com_unlock_tables | 9849 |
| Com_update | 1937356 |
| Com_update_multi | 19028 |
| 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 | 1917781 |
| Created_tmp_disk_tables | 916284 |
| Created_tmp_files | 17805 |
| Created_tmp_tables | 3145027 |
| Delayed_errors | 4 |
| Delayed_insert_threads | 2 |
| Delayed_writes | 12457 |
| Flush_commands | 1 |
| Handler_commit | 11447522 |
| Handler_delete | 220433 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 5943012 |
| Handler_read_key | 1555787590 |
| Handler_read_last | 505473 |
| Handler_read_next | 21877776588 |
| Handler_read_prev | 45884273 |
| Handler_read_rnd | 603138368 |
| Handler_read_rnd_next | 28151090216 |
| Handler_rollback | 472 |
| Handler_savepoint | 533 |
| Handler_savepoint_rollback | 36 |
| Handler_update | 562447644 |
| Handler_write | 1491898789 |
| Innodb_buffer_pool_pages_data | 8190 |
| Innodb_buffer_pool_bytes_data | 134184960 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 1801346 |
| Innodb_buffer_pool_pages_free | 0 |
| Innodb_buffer_pool_pages_misc | 2 |
| Innodb_buffer_pool_pages_total | 8192 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 100076 |
| Innodb_buffer_pool_read_ahead_evicted | 5346 |
| Innodb_buffer_pool_read_requests | 1889058976 |
| Innodb_buffer_pool_reads | 83316715 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 25645521 |
| Innodb_data_fsyncs | 951910 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 1366852030464 |
| Innodb_data_reads | 83444349 |
| Innodb_data_writes | 2609383 |
| Innodb_data_written | 60924825088 |
| Innodb_dblwr_pages_written | 1801346 |
| Innodb_dblwr_writes | 39685 |
| Innodb_have_atomic_builtins | ON |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 3820768 |
| Innodb_log_writes | 676296 |
| Innodb_os_log_fsyncs | 702461 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 1888249344 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 116102 |
| Innodb_pages_read | 83425893 |
| Innodb_pages_written | 1801346 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 1776787 |
| Innodb_row_lock_time_avg | 53 |
| Innodb_row_lock_time_max | 15274 |
| Innodb_row_lock_waits | 33514 |
| Innodb_rows_deleted | 79558 |
| Innodb_rows_inserted | 719167 |
| Innodb_rows_read | 2012559367 |
| Innodb_rows_updated | 8802327 |
| Innodb_truncated_status_writes | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 5132 |
| Key_blocks_used | 6698 |
| Key_read_requests | 4253947575 |
| Key_reads | 9580482 |
| Key_write_requests | 402208587 |
| Key_writes | 1308539 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 81 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 303 |
| Open_streams | 0 |
| Open_table_definitions | 400 |
| Open_tables | 401 |
| Opened_files | 156867873 |
| Opened_table_definitions | 90390899 |
| Opened_tables | 91183606 |
| 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 | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Queries | 68410828 |
| Questions | 66957772 |
| Rpl_status | AUTH_MASTER |
| Select_full_join | 35719 |
| Select_full_range_join | 355 |
| Select_range | 1157875 |
| Select_range_check | 1072 |
| Select_scan | 13207366 |
| 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 | 945 |
| Sort_merge_passes | 8613 |
| Sort_range | 2448229 |
| Sort_rows | 838168307 |
| Sort_scan | 7198628 |
| 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 | 71586936 |
| Table_locks_waited | 26273 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 5 |
| Threads_created | 1917329 |
| Threads_running | 3 |
| Uptime | 241164 |
| Uptime_since_flush_status | 241164 |
+------------------------------------------+---------------+
+---------+--------------+-----------+----------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+--------------+-----------+----------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
| 11023 | eximstats | localhost | eximstats | Sleep | 24 | | |
| 1786924 | DELAYED | localhost | eximstats | Delayed insert | 24 | Waiting for INSERT | |
| 1877100 | leechprotect | localhost | leechprotect | Sleep | 3436 | | |
| 1917450 | DELAYED | localhost | **** | Delayed insert | 30 | Waiting for INSERT | |
| 1917777 | *** | localhost | **** | Query | 0 | Sorting result | SELECT artid, secid, title, autor, counter, publish FROM nuked_sections WHERE secid='15' AND publish |
| 1917779 | *** | localhost | **** | Query | 0 | Sorting result | SELECT artid, secid, title, autor, counter, publish FROM nuked_sections WHERE secid='15' AND publish |
| 1917780 | root | localhost | | Query | 0 | | show processlist |
+---------+--------------+-----------+----------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
------------------------------------
INNODB Buffer Pool Stats
------------------------------------
*************************** 1. row ***************************
POOL_ID: 0
POOL_SIZE: 8192
FREE_BUFFERS: 0
DATABASE_PAGES: 8190
OLD_DATABASE_PAGES: 3003
MODIFIED_DATABASE_PAGES: 0
PENDING_DECOMPRESS: 0
PENDING_READS: 0
PENDING_FLUSH_LRU: 0
PENDING_FLUSH_LIST: 0
PAGES_MADE_YOUNG: 83718903
PAGES_NOT_MADE_YOUNG: 0
PAGES_MADE_YOUNG_RATE: 1802.5213835467225
PAGES_MADE_NOT_YOUNG_RATE: 0
NUMBER_PAGES_READ: 83425893
NUMBER_PAGES_CREATED: 116102
NUMBER_PAGES_WRITTEN: 1801346
PAGES_READ_RATE: 1798.3607435581507
PAGES_CREATE_RATE: 1.714255102587454
PAGES_WRITTEN_RATE: 13.071195157229337
NUMBER_PAGES_GET: 1889058976
HIT_RATE: 850
YOUNG_MAKE_PER_THOUSAND_GETS: 150
NOT_YOUNG_MAKE_PER_THOUSAND_GETS: 0
NUMBER_PAGES_READ_AHEAD: 100076
NUMBER_READ_AHEAD_EVICTED: 5346
READ_AHEAD_RATE: 0
READ_AHEAD_EVICTED_RATE: 0.30356600774986164
LRU_IO_TOTAL: 101405
LRU_IO_CURRENT: 1
UNCOMPRESS_TOTAL: 0
UNCOMPRESS_CURRENT: 0
----------------------------
INNODB Status
----------------------------
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
140201 19:08:19 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 56 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 198104 1_second, 195527 sleeps, 19711 10_second, 1072 background, 1070 flush
srv_master_thread log flush and writes: 211882
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 159465, signal count 126131
Mutex spin waits 1195880, rounds 6382889, OS waits 72353
RW-shared spins 49196, rounds 1273446, OS waits 36953
RW-excl spins 32496, rounds 1514029, OS waits 47099
Spin rounds per wait: 5.34 mutex, 25.89 RW-shared, 46.59 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 43999565
Purge done for trx's n:o < 43999458 undo n:o < 0
History list length 4034
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 1917782, OS thread handle 0x7fd2b9fe0700, query id 68410835 localhost root
show engine innodb status
--------
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
83444349 OS file reads, 2609383 OS file writes, 951910 OS fsyncs
1798.36 reads/s, 16384 avg bytes/read, 16.48 writes/s, 5.04 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 6152, seg size 6154, 9468 merges
merged operations:
insert 30089, delete mark 3211, delete 59
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 2 buffer(s)
231.80 hash searches/s, 42.20 non-hash searches/s
---
LOG
---
Log sequence number 57133242733
Log flushed up to 57133242733
Last checkpoint at 57133228887
0 pending log writes, 0 pending chkp writes
696175 log i/o's done, 2.82 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 137363456; in additional pool allocated 0
Dictionary memory allocated 116628036
Buffer pool size 8192
Free buffers 0
Database pages 8190
Old database pages 3003
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 83718903, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 83425893, created 116102, written 1801346
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8190, unzip_LRU len: 0
I/O sum[101405]:cur[1], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 3183, id 140543080584960, state: sleeping
Number of rows inserted 719167, updated 8802327, deleted 79558, read 2012559367
0.29 inserts/s, 564.04 updates/s, 0.18 deletes/s, 8192.21 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
----------------------------
MySQL Error Log
----------------------------
140201 17:46:55 [Warning] Found invalid password for user:
140201 17:46:55 [Warning] Found invalid password for user:
140201 17:46:55 [Warning] Found invalid password for user:
140201 17:46:55 [Warning] Found invalid password for user:
140201 17:46:55 [Warning] Found invalid password for user:
140201 17:46:55 [Warning] Found invalid password for user:
Report Complete:
Sat Feb 1 19:08:19 CET 2014
----------------------------Thanks in advance !
