Hi

We will use a Java application which uses Hibernate for DB calls. The vendor didn't made recommendations howto configure MySQL. The application is not yet in production.
MySQL is new to me, I previously used Oracle DB. The vendor provided a guide howto configure Oracle.

This is our my.conf

Code:
$ cat /etc/my.cnf
[mysqld]
datadir=/opt/pprd/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
max_allowed_packet=10M
query_cache_size = 8388608
table_open_cache=256
tmp_table_size=67108864
log_bin             = /opt/pprd/log/mysql-bin.log
log_bin_index       = /opt/pprd/log/mysql-bin.index
expire_logs_days    = 5
max_binlog_size     = 100M
binlog_format       = row
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Code:
$ rpm -qa mysql
mysql-5.1.66-1.el6_3.x86_64
Code:
$ free -m
             total       used       free     shared    buffers     cached
Mem:         32241      31610        630          0        240      27209
-/+ buffers/cache:       4161      28080
Swap:         2047         74       1973
Code:
$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.1 (Santiago)
did we miss an inportant option? What config options do you use?

the DDL is provided by vendor and we are not allowed to change it (for example indexes).
I personly like if the MySQL behaves like a out-of-tbe-box Oracle 11g db.