forum.lissyara.su

Код: Выделить всё

HOSTING# mysqladmin -u avgur -p processlist
Enter password:
+--------+---------+-----------+---------+----------------+------+--------------------+------------------+
| Id     | User    | Host      | db      | Command        | Time | State              | Info             |
+--------+---------+-----------+---------+----------------+------+--------------------+------------------+
| 63452  | ppeople | localhost | ppeople | Sleep          | 7217 |                    |                  |
| 63453  | ppeople | localhost | ppeople | Sleep          | 7217 |                    |                  |
| 72579  | ppeople | localhost | ppeople | Sleep          | 5842 |                    |                  |
| 73459  | ppeople | localhost | ppeople | Sleep          | 5718 |                    |                  |
| 74425  | ppeople | localhost | ppeople | Sleep          | 5575 |                    |                  |
| 86620  | ppeople | localhost | ppeople | Sleep          | 3708 |                    |                  |
| 86708  | ppeople | localhost | ppeople | Sleep          | 3695 |                    |                  |
| 87181  | ppeople | localhost | ppeople | Sleep          | 3630 |                    |                  |
| 87193  | ppeople | localhost | ppeople | Sleep          | 3628 |                    |                  |
| 87194  | ppeople | localhost | ppeople | Sleep          | 3628 |                    |                  |
| 87195  | ppeople | localhost | ppeople | Sleep          | 3628 |                    |                  |
| 87196  | ppeople | localhost | ppeople | Sleep          | 3628 |                    |                  |
| 89492  | ppeople | localhost | ppeople | Sleep          | 3240 |                    |                  |
| 89978  | ppeople | localhost | ppeople | Sleep          | 3166 |                    |                  |
| 91454  | ppeople | localhost | ppeople | Sleep          | 2915 |                    |                  |
| 92217  | ppeople | localhost | ppeople | Sleep          | 2756 |                    |                  |
| 92440  | ppeople | localhost | ppeople | Sleep          | 2719 |                    |                  |
| 92449  | ppeople | localhost | ppeople | Sleep          | 2718 |                    |                  |
| 96485  | ppeople | localhost | ppeople | Sleep          | 304  |                    |                  |
| 99949  | ppeople | localhost | ppeople | Sleep          | 1529 |                    |                  |
...
| 109365 | avgur   | localhost |         | Query          | 0    |                    | show processlist |
+--------+---------+-----------+---------+----------------+------+--------------------+------------------+

Код: Выделить всё

## Fro MySQL
        SQLLogFile              /var/log/proftpd_sql.log
        SQLConnectInfo          ppeople@localhost:3306 логин пароль
        SQLBackend              mysql
        SQLEngine       log
        SQLLog          RETR,STOR               log_story_transfer
        SQLNamedQuery   log_story_transfer      FREEFORM "INSERT DELAYED INTO ftplog(hostname, filename, ftpdate, amount) VALUES ('%h', '%F', FROM_UNIXTIME(UNIX_TIMESTAMP()), '%b')"
## End

Код: Выделить всё

sockstat | grep proftp 

Код: Выделить всё

anonymousproftpd    32108 5  stream -> /tmp/mysql.sock
anonymousproftpd    32108 14 tcp4   192.168.11.14:50704   78.26.128.249:1776
anonymousproftpd    32108 15 tcp4   192.168.11.14:50704   78.26.128.249:1776
anonymousproftpd    32107 0  tcp4   192.168.11.14:21      78.26.128.249:1773
anonymousproftpd    32107 1  tcp4   192.168.11.14:21      78.26.128.249:1773
anonymousproftpd    32107 5  stream -> /tmp/mysql.sock
anonymousproftpd    32107 14 tcp4   192.168.11.14:50536   78.26.128.249:1777
anonymousproftpd    32107 15 tcp4   192.168.11.14:50536   78.26.128.249:1777
nobody   proftpd    32090 0  tcp4   *:21                  *:*

Код: Выделить всё

[client]
#password       = your_password
port            = 3306
socket          = /tmp/mysql.sock


[mysqld]
port            = 3306
bind-address    = 127.0.0.1
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 512M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
skip-networking
thread_concurrency=4
##skip-innodb
skip-bdb
#server-id       = 1
log            = /var/log/mysql.log
log-slow-queries=/var/log/mysql_slow.log

[mysqldump]
quick
max_allowed_packet = 16M

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

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout