List:General Discussion« Previous MessageNext Message »
From:Lukas Lehner Date:February 12 2014 9:08am
Subject:DBA: please review my.cnf [for Java Hibernate application] and give suggestions
View as plain text  
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.

Thread
DBA: please review my.cnf [for Java Hibernate application] and give suggestionsLukas Lehner12 Feb 2014
  • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsAntonio Fernández Pérez12 Feb 2014
    • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsAdarsh Sharma12 Feb 2014
      • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsLukas Lehner12 Feb 2014
    • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsLukas Lehner12 Feb 2014
      • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsAntonio Fernández Pérez12 Feb 2014
      • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsManuel Arostegui12 Feb 2014