[opencms-dev] My.cnf

[fsanmartin at 9th.com]

I have changed the my.cnf and now I’m having performance issues, I have only the demo install in an off-line Tomcat server w/ OpenCMS 10.5.2
Can you check my configuration and suggest the default settings? Thank you

#Jelastic autoconfiguration mark.
[mysqld]
datadir=/var/lib/mysql
innodb_buffer_pool_size = 512M
innodb_use_native_aio = 0
key_buffer_size = 384M
max_allowed_packet = 32M
myisam_sort_buffer_size = 64M
net_buffer_length = 2K
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=0
read_buffer_size = 2M
read_rnd_buffer_size = 32M
server-id       = 1
skip-external-locking
skip-name-resolve
socket=/var/lib/mysql/mysql.sock
sort_buffer_size = 32M
table_open_cache = 512
thread_stack = 240K
user=mysql


# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysql/mysqld.log
pid-file=/var/lib/mysql/mysqld.pid