last pid: 16384;  load averages: 78.58, 77.64, 76.12                                                                                                                                up 2+18:35:12  21:39:50
60 processes:  4 running, 56 sleeping
CPU: 99.1% user,  0.0% nice,  0.9% system,  0.0% interrupt,  0.0% idle
Mem: 5086M Active, 7529M Inact, 2018M Wired, 1876M Buf, 1146M Free
Swap: 4096M Total, 4096M Free

  PID USERNAME    THR PRI NICE   SIZE    RES STATE   C   TIME   WCPU COMMAND
 9476 mysql       117  22    0  9427M  5304M RUN     1  67.4H 151.12% mysqld
 1940 www           1  20    0   290M 44172K accept  0   1:25  0.49% httpd
15522 www           1  42    0   290M 38540K accept  1   1:37  0.00% httpd
15543 www           1  35    0   290M 44996K accept  0   1:33  0.00% httpd
…

MySQL on localhost (5.5.38-log)                                                                                                                                                     up 1+13:48:17 [21:46:12]
 Queries: 44.9M  qps:  346 Slow:    3.1k         Se/In/Up/De(%):    60/00/19/00 

 Cache Hits: 3.5M  Hits/s: 26.6 Hits now:   0.0  Ratio: 12.9% Ratio now:  0.0% 
 Key Efficiency: 100.0%  Bps in/out: 68.5k/138.0k   

    Id      User         Host/IP         DB      Time    Cmd Query or State                                                                                                                                 
    --      ----         -------         --      ----    --- ----------                                                                                                                                     
...

[mysqld]
datadir=/var/db/mysql
socket=/tmp/mysql.sock
max_connections=100
innodb_buffer_pool_size=8G
innodb_use_sys_malloc=0
innodb_file_per_table=1

max_heap_table_size=128M
innodb_flush_log_at_trx_commit = 0

wait_timeout = 5
interactive_timeout =   30

log-slow-queries = /var/log/mysqld/mysql-slow.log
long_query_time = 5
key_buffer_size = 16M
query_cache_size = 128M
query_cache_limit = 32M
table_cache = 500
thread_cache_size=4
sort_buffer_size = 16M
myisam_sort_buffer_size = 16M
join_buffer_size = 16M
ft_min_word_len = 2
tmp_table_size = 128M
max_tmp_tables = 64
tmpdir = /tmp/mysqltemp

[client]
default-character-set=cp1251

[mysql.server]
user=mysql
basedir=/var/db/mysql

[OK] Currently running supported MySQL version 5.5.38-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +CSV +InnoDB +MRG_MYISAM 
[--] Data in InnoDB tables: 2G (Tables: 64)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 17

-------- Security Recommendations  -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 1d 13h 55m 1s (47M q [346.190 qps], 280K conn, TX: 19B, RX: 9B)
[--] Reads / Writes: 72% / 28%
[--] Total buffers: 8.3G global + 32.6M per thread (100 max threads)
[OK] Maximum possible memory usage: 11.5G (72% of installed RAM)
[OK] Slow queries: 0% (3K/47M)
[!!] Highest connection usage: 100%  (101/100)
[OK] Key buffer size / total MyISAM indexes: 16.0M/95.0K
[OK] Key buffer hit rate: 100.0% (257M cached / 16 reads)
[!!] Query cache efficiency: 12.9% (3M cached / 28M selects)
[!!] Query cache prunes per day: 4107
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 332K sorts)
[!!] Temporary tables created on disk: 48% (246K on disk / 510K total)
[OK] Thread cache hit rate: 97% (8K created / 280K connections)
[!!] Table cache hit rate: 3% (500 open / 14K opened)
[OK] Open file limit used: 0% (1/11K)
[OK] Table locks acquired immediately: 99% (75M immediate / 75M locks)
[!!] Connections aborted: 6%
[OK] InnoDB buffer pool / data size: 8.0G/2.2G
[OK] InnoDB log waits: 0

mysql> show global status like '%qcache%';
+-------------------------+-----------+
| Variable_name           | Value     |
+-------------------------+-----------+
| Qcache_free_blocks      | 651       |
| Qcache_free_memory      | 116680592 |
| Qcache_hits             | 3637010   |
| Qcache_inserts          | 16896324  |
| Qcache_lowmem_prunes    | 6490      |
| Qcache_not_cached       | 7627513   |
| Qcache_queries_in_cache | 3252      |
| Qcache_total_blocks     | 7409      |
+-------------------------+-----------+

mysql> show global status like '%open%';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| Com_ha_open              | 0      |
| Com_show_open_tables     | 0      |
| Open_files               | 49     |
| Open_streams             | 0      |
| Open_table_definitions   | 105    |
| Open_tables              | 500    |
| Opened_files             | 988862 |
| Opened_table_definitions | 213    |
| Opened_tables            | 14348  |
| Slave_open_temp_tables   | 0      |
+--------------------------+--------+

mysql> show global variables like '%cache%';
+------------------------------+----------------------+
| Variable_name                | Value                |
+------------------------------+----------------------+
| binlog_cache_size            | 32768                |
| binlog_stmt_cache_size       | 32768                |
| have_query_cache             | YES                  |
| key_cache_age_threshold      | 300                  |
| key_cache_block_size         | 1024                 |
| key_cache_division_limit     | 100                  |
| max_binlog_cache_size        | 18446744073709547520 |
| max_binlog_stmt_cache_size   | 18446744073709547520 |
| metadata_locks_cache_size    | 1024                 |
| query_cache_limit            | 33554432             |
| query_cache_min_res_unit     | 4096                 |
| query_cache_size             | 134217728            |
| query_cache_type             | ON                   |
| query_cache_wlock_invalidate | OFF                  |
| stored_program_cache         | 256                  |
| table_definition_cache       | 400                  |
| table_open_cache             | 500                  |
| thread_cache_size            | 4                    |
+------------------------------+----------------------+