|
Re: [Bacula-users] MySQL slowness when initializing new disk volume
2014-04-21 08:39:40
Hello,
If the optimizations of MySQL do not work out, my experience with
*very* large Bacula databases agrees with what Alan wrote below.
You have to be careful though, PostgreSQL out of the box is
*horribly* tuned for Bacula so you *must* change about 7 of the
parameters. I think Eric made a presentation on what is needed at
the last Bacula Conference. See his slides at:
http://www.baculaconference.org/conference-presentations/
Best regards,
Kern
On 04/20/2014 05:10 AM, Alan Brown wrote:
On 18/04/14 23:49, Lloyd Brown wrote:
Are the tables in MyISAM or InnoDB format?
At the moment, MyISAM. I'd wondered if I could safely convert to
InnoDB, since that's generally going to have better locking
characteristics, etc.
It's easy enough to change, but....
How large are the tables? In particular how many entries do you
have in the file table?
MySQL is good, but it doesn't scale to large tables very well
(even with Inno) so at some point there's a lot of benefit
(reduced ram use) in switching to Postgres.
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
------------------------------------------------------------------------------
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
|
|
|
