Bacula-users

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

2014-04-23 11:38:21
Subject: Re: [Bacula-users] MySQL slowness when initializing new disk volume
From: Alan Brown <ajb2 AT mssl.ucl.ac DOT uk>
To: bacula-users AT lists.sourceforge DOT net
Date: Wed, 23 Apr 2014 16:35:02 +0100
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)





------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users