mysql> SHOW FULL PROCESSLIST\G
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    758726
Current database: *** NONE ***

*************************** 1. row ***************************
     Id: 758695
   User: admin_domain
   Host: localhost
     db: admin_domain
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 2. row ***************************
     Id: 758697
   User: admin_domain
   Host: localhost
     db: admin_domain
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 3. row ***************************
     Id: 758704
   User: admin_domain
   Host: localhost
     db: admin_domain
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 4. row ***************************
     Id: 758706
   User: admin_domain
   Host: localhost
     db: admin_domain
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 5. row ***************************
     Id: 758711
   User: admin_domain
   Host: localhost
     db: admin_domain
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 6. row ***************************
     Id: 758712
   User: admin_domain
   Host: localhost
     db: admin_domain
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 7. row ***************************
     Id: 758713
   User: admin_domain
   Host: localhost
     db: admin_domain
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 8. row ***************************
     Id: 758714
   User: admin_domain
   Host: localhost
     db: admin_domain
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 9. row ***************************
     Id: 758722
   User: admin_domain
   Host: localhost
     db: admin_domain
Command: Sleep
   Time: 0
  State:
   Info: NULL
*************************** 10. row ***************************
     Id: 758726
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: SHOW FULL PROCESSLIST
10 rows in set (0.01 sec)

[root@server ~]# ./mysqltuner.pl

 >>  MySQLTuner 1.0.1 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.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.0.51a-community-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 3G (Tables: 258)
[--] Data in InnoDB tables: 14G (Tables: 146)
[--] Data in MEMORY tables: 14M (Tables: 32)
[!!] Total fragmented tables: 27

-------- Performance Metrics -------------------------------------------------
[--] Up for: 3h 4m 34s (7M q [690.153 qps], 723K conn, TX: 167B, RX: 3B)
[--] Reads / Writes: 76% / 24%
[--] Total buffers: 8.8G global + 6.1M per thread (1024 max threads)
[OK] Maximum possible memory usage: 15.0G (47% of installed RAM)
[OK] Slow queries: 0% (536/7M)
[OK] Highest usage of available connections: 33% (340/1024)
[OK] Key buffer size / total MyISAM indexes: 512.0M/3.2G
[OK] Key buffer hit rate: 97.7% (56M cached / 1M reads)
[OK] Query cache efficiency: 37.6% (1M cached / 4M selects)
[!!] Query cache prunes per day: 16234235
[OK] Sorts requiring temporary tables: 0% (314 temp sorts / 629K sorts)
[!!] Joins performed without indexes: 493
[OK] Temporary tables created on disk: 2% (3K on disk / 120K total)
[OK] Thread cache hit rate: 96% (22K created / 723K connections)
[!!] Table cache hit rate: 0% (64 open / 1M opened)
[OK] Open file limit used: 0% (32/5K)
[OK] Table locks acquired immediately: 97% (7M immediate / 7M locks)
[!!] InnoDB data size / buffer pool: 14.8G/8.0G

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Adjust your join queries to always utilize indexes
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
    query_cache_size (> 1M)
    join_buffer_size (> 1020.0K, or always use indexes with joins)
    table_cache (> 64)
    innodb_buffer_pool_size (>= 14G)

[root@server ~]# mysql -e "show full processlist\G" | awk -F ": " '/Command/ { print $(NF-2) }' | sort | uniq -c | sort -rn
    186 Command: Query
     15 Command: Sleep

pool:                 domain
process manager:      static
accepted conn:        6139
listen queue len:     0
max listen queue len: -1
idle processes:       1
active processes:     255
total processes:      256
max children reached: 0

[root@server ~]# mysql -e "show full processlist\G" | awk -F ": " '/User/ { print $2 }' | sort | uniq -c | sort -rn
    145 admin_db
      1 Lan_nana A new account by the name of [URL=http://www.domain.com/member.php?u=196398]Hân_nana[/URL] has been registered. The new account has been moved to the Prevention Usergroup.\r\n\r\nOther recognized logins for this user are
      1 da_admin

A new message or response with subject:

The service 'dovecot' on server server.domain.com is currently down

has arrived for you to view.
Follow this link to view it:

 http://domain.com:2222/CMD_TICKET?action=view&number=000014857&type=ticket


======================================================
Automatically generated email produced by DirectAdmin 1.38.3

mysql> show global variables like '%timeout';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| connect_timeout            | 60    |
| delayed_insert_timeout     | 300   |
| innodb_lock_wait_timeout   | 50    |
| innodb_rollback_on_timeout | OFF   |
| interactive_timeout        | 120   |
| net_read_timeout           | 30    |
| net_write_timeout          | 60    |
| slave_net_timeout          | 3600  |
| table_lock_wait_timeout    | 50    |
| wait_timeout               | 60    |
+----------------------------+-------+
10 rows in set (0.00 sec)

mysql> show global variables like '%connections';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| max_connections      | 1024  |
| max_user_connections | 0     |
+----------------------+-------+
2 rows in set (0.00 sec)

[mysqld]
back_log                        = 100
open-files-limit                = 2048
open-files                      = 256
#max_connect_errors = 100000

skip-external-locking
skip-name-resolve
log_error                       = mysql-error.err
log_slow_queries                = mysql-slow.log

## Per-Thread Buffers * (max_connections) = total per-thread mem usage
thread_stack                    = 64K     #default: 32bit: 192K, 64bit: 256K
sort_buffer_size                = 2M      #default: 2M, larger may cause perf issues
read_buffer_size                = 1M      #default: 128K, change in increments of 4K
read_rnd_buffer_size            = 2M      #default: 256K
join_buffer_size                = 1M      #default: 128K
#binlog_cache_size              = 64K     #default: 32K, size of buffer to hold TX queries
#table_definition_cache = 10000
#table_open_cache = 10000
thread_cache_size = 1024
## total per-thread buffer memory usage: 8832000K = 8.625GB

## Query Cache
#query_cache_type               = 1
query_cache_size                = 1M    #global buffer
query_cache_limit               = 128M  #max query result size to put in cache

## Table and TMP settings
max_heap_table_size             = 256M  #recommend same size as tmp_table_size
bulk_insert_buffer_size         = 256M  #recommend same size as tmp_table_size
tmp_table_size                  = 256M    #recommend 1G min
#net_buffer_length = 16384
## Table cache settings
table_cache                     = 1000  #5.0.x <default: 64>

## Thread settings
thread_concurrency              = 8  #recommend 2x CPU cores
thread_cache_size               = 10  #recommend 5% of max_connections

#Query cache
#query_cache_size = 52428800;
query_cache_type = 1

local-infile=0
socket=/var/lib/mysql/mysql.sock
skip-locking
#skip-innodb
#query_cache_type=1
#query_cache_limit=32M
#query_cache_size=512M
max_connections=1024
interactive_timeout=120
wait_timeout=15
connect_timeout=60

key_buffer= 1M
record_buffer=1M

myisam_sort_buffer_size=256M
myisam_max_sort_file_size       = 2048M


#innodb_read_ahead = none
innodb_file_per_table = 1
innodb_open_files = 1000
#innodb_data_home_dir = /var/lib/mysql/ibdatadir
innodb_data_file_path= ibdata1:4G:autoextend
innodb_buffer_pool_size = 8G
innodb_additional_mem_pool_size = 64M

#innodb_log_group_home_dir = /var/lib/mysql/ibdlogdir
innodb_log_files_in_group = 2
innodb_log_file_size = 128M
innodb_log_buffer_size = 256M
innodb_flush_log_at_trx_commit = 2
#innodb_thread_concurrency = 0
#innodb_lock_wait_timeout=50
#innodb_flush_method = O_DIRECT
innodb_support_xa=0

# 200 * # DISKS
# plugin only
#innodb_io_capacity = 400
#innodb_read_io_threads = 4
#innodb_write_io_threads = 4

max_allowed_packet=128M
max_heap_table_size=32M
key_buffer_size = 512M
#low_priority_updates=1
#concurrent_insert=2
server-id=1

[safe_mysqld]
err-log=/var/log/mysqld.log
nice = -5
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=256M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=2048M
sort_buffer=2048M
read_buffer=512M
write_buffer=512M

[myisamchk]
key_buffer=2048M
sort_buffer=2048M
read_buffer=512M
write_buffer=512M

[mysqlhotcopy]
interactive-timeout

[abc]

listen = /tmp/php-fpm.sock

listen.backlog = -1


listen.allowed_clients = 127.0.0.1


listen.owner = nobody
listen.group = nobody
listen.mode = 0666


user = nobody
group = nobody


pm = static

pm.max_children = 128

pm.start_servers = 128

pm.min_spare_servers = 30

pm.max_spare_servers = 80

pm.max_requests = 500


pm.status_path = /php-fpm-status/status.php

ping.path = /php-fpm-ping/ping.php

ping.response = pong

worker_processes        16;

events {
        use                     epoll;
        worker_connections      1024;
}

http {
        # php-fpm backend
        upstream php {
                server          unix:/tmp/php-fpm.sock;
        }

        # general proxying rules
        proxy_set_header        X-Real-IP       $remote_addr;
        proxy_set_header        X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header        Host            $host;
        proxy_buffer_size       32k;
        proxy_buffers           16      32k;
        proxy_wwwect          off;

        # fastcgi configuration
        fastcgi_connect_timeout 60;
        fastcgi_send_timeout    180;
        fastcgi_read_timeout    180;
        fastcgi_buffer_size     128k;
        fastcgi_buffers         32      32k;
        fastcgi_busy_buffers_size       256k;
        fastcgi_temp_file_write_size    256k;
        fastcgi_intercept_errors        on;

#       access_log              on;
#       error_log               off;
        include                 mime.types;
        default_type            application/octet-stream;

        keepalive_timeout       0;

        gzip                    on;
        gzip_types              text/css text/xml application/x-javascript application/atom+xml application/rss+xml text/plain text/javascript;

        server_tokens           off;

        sendfile                on;
        tcp_nopush              on;
        tcp_nodelay             on;

        client_max_body_size    32M;

server {
                listen          xxx.xxx.xxx.xxx:80;
                server_name     domain.comt;

                root            /home/admin/domains/domain.com/public_html;

                location / {
                        index           index.html      index.php;
#               access_log              on;

               }


                location /clear.gif {
                        empty_gif;
        access_log              off;
                }


                location ~ \.(png|gif|jpg|jpeg|swf|css|js|ico)$ {
                        expires         90d;
        access_log              off;
                }

                location ~ ^/php-fpm-(status|ping)$ {
                        include         fastcgi_params;
                        fastcgi_pass    php;
                        fastcgi_param   SCRIPT_FILENAME $fastcgi_script_name;
                }


                location /archive/index.php {
                        include         fastcgi_params;
                        fastcgi_pass    php;
                        fastcgi_param   SCRIPT_FILENAME $document_root/archive/index.php;
        access_log              off;
                }

                location ~ \.php$ {
#        access_log              on;
                        if ($remote_addr = 0) {
                                rewrite ^(.*)$  http://lol.com/$1       break;
                        }

                        include         fastcgi_params;
                        if ($uri !~ "^/customavatars/"){
                                fastcgi_pass    php;
                        }
#                       fastcgi_param   SCRIPT_FILENAME $fastcgi_script_name;
                }

        error_page  502              /502.html;
        location = /502.html {
            root   /usr/local/nginx/html;
        }




        }
}

2013/04/04 16:57:49 [error] 28414#0: *10337 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:49 [error] 28414#0: *10166 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:49 [error] 28414#0: *10335 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:49 [error] 28414#0: *10341 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:49 [error] 28414#0: *10005 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:49 [error] 28414#0: *10345 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:49 [error] 28414#0: *10344 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:50 [error] 28414#0: *10350 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:50 [error] 28414#0: *10353 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:50 [error] 28414#0: *10362 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:50 [error] 28414#0: *10360 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:50 [error] 28414#0: *10366 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:50 [error] 28414#0: *10367 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:50 [error] 28414#0: *10370 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:50 [error] 28414#0: *10371 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client:
2013/04/04 16:57:50 [error] 28414#0: *10374 connect() to unix:/tmp/php-fpm.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client: