Openfire 3.8.2 on Windows 2008R2 x64
Mysql (Ver 14.14 Distrib 5.1.69, for debian-linux-gnu (x86_64) using readline 6.1) on Ubuntu 10.04 x64 (2.6.32-48-server)
Openfire 3.8.2:
Java Memory 434,14 MB of 989,88 MB (43,9%) used
Active Client Sessions: 307
Total Users: 772
Plugins:
Kraken IM Gateway 1.1.3
Load Statistic 1.1.0
Monitoring Service 1.3.2-beta1
MotD (Message of the Day) 1.0.4
SASL Mechanisms (JT) 0.3
Search 1.5.1
Subscription 1.2.2
User Import Export 2.3.1
**Load CPU 90-100% on Mysql **after reinstall Monitoring Plugin
my.cnf:
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
character-set-server=utf8
init-connect=‘SET NAMES utf8’
collation-server=utf8_general_ci
skip-name-resolve
connect_timeout=1
user = mysql
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-external-locking
bind-address = 0.0.0.0
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
query_cache_limit = 8M
query_cache_size = 64M
open-files-limit = 4096
tmp_table_size = 512M
table_open_cache = 512
key_buffer_size = 256M
table_cache = 50K
general_log_file = /var/log/mysql/mysql.log
general_log = 0
log_error = /var/log/mysql/error.log
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 20
expire_logs_days = 10
max_binlog_size = 100M
innodb_file_per_table=1
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
!includedir /etc/mysql/conf.d/