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
$ 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
$ rpm -qa mysql
mysql-5.1.66-1.el6_3.x86_64
$ free -m
total used free shared buffers cached
Mem: 32241 31610 630 0 240 27209
-/+ buffers/cache: 4161 28080
Swap: 2047 74 1973
$ 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.
