powered by Jive Software

High load CPU Openfire 3.8.2 on Mysql

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/