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
$
Hi Lukas,
What is your default engine? In MySQL there are a lot of parameters that
configure the engine behaviour. Depends on the engine, I suggest you to add
some parameters or others.
Also it's important to know the size of your data. Your configuration is
minimal and by default is not
Is it a standalone DB server or Application is also hosted on top of it.
You can give 50-70% of RAM to memory parameters like
Innodb_buffer_pool_size ( Innodb ) and key_cache ( Myisam ) for mysql
tables.
Below link : http://mysql.rjweb.org/doc.php/memory will give you a brief
idea.
Thanks
Hi Antonio
all tables use InnoDB. The size is 27 GB (not yet in prod). I guess in prod
it will be fast 80GB.
thanks
On Wed, Feb 12, 2014 at 10:28 AM, Antonio Fernández Pérez
antoniofernan...@fabergames.com wrote:
Hi Lukas,
What is your default engine? In MySQL there are a lot of
Hi
it's also a Tomcat application server. Not dedicated MySQL instance.
On Wed, Feb 12, 2014 at 11:28 AM, Adarsh Sharma eddy.ada...@gmail.comwrote:
Is it a standalone DB server or Application is also hosted on top of it.
You can give 50-70% of RAM to memory parameters like
Hi Lukas,
In that case, such as Adarsh has said, you can configure until 70% of your
RAM for innodb_buffer_pool_size.
In your case, with 3GB RAM, I suggest you to configure until 2GB for MySQL:
Minimal for MyISAM (Maybe 32MB), and the rest for InnoDB. Your problem will
be loading data. Maybe your
2014-02-12 12:32 GMT+01:00 Lukas Lehner webleh...@gmail.com:
Hi Antonio
all tables use InnoDB. The size is 27 GB (not yet in prod). I guess in prod
it will be fast 80GB.
Depending on how your application is going to use MySQL resources you will
need to tweak some things (and not only