Re: [Bacula-users] MySQL slowness when initializing new disk volume

[Alan B. <aj...@ms...>]

On 21/04/14 15:25, Lloyd Brown wrote:

> Definitely more than I expected.  Although, I have to say, RAM usage on
> this host isn't really much of a concern.  At the moment, the mysqld
> process is only using just over 1GB of RAM, and this host has 128G.
> Possibly I need to tune MySQL to keep more of the tables' contents in RAM.

One of the main problems with using mysql at large sizes is the need for 
large amounts of tuning.

I resisted moving to Postgres for a long time.

I'm still kicking myself that I held off doing so for so long.

(bonus: It's much faster than MySQL for batch inserts)