2014-02-12 12:32 GMT+01:00 Lukas Lehner :
> 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 MySQL).
If it is goin
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
Hi
it's also a Tomcat application server. Not dedicated MySQL instance.
On Wed, Feb 12, 2014 at 11:28 AM, Adarsh Sharma wrote:
> 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 )
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 param
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 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 optimal.
