Alan,
I understand. I've been meaning to get started with learning Postgres
for several years, but there always seems to be something more urgent
that takes my attention away. At the moment, it's storage system
failures, which is kinda a big deal, so for now I'll have to be content
with the tuning's I've applied on MySQL.
So far I've basically converted all the bacula tables to InnoDB, and
increased the innodb_buffer_pool_size to 64GB, which should hold all of
the tables total so far. And while it's not necessarily tuned
perfectly, it's already noticeably faster. I won't know for sure for a
couple more weeks, when our next big batch of Fulls get started, but so
far it looks promising.
Thanks for all the suggestions. It certainly pointed me in the right
direction. I couldn't have managed this without the community's help.
Lloyd Brown
Systems Administrator
Fulton Supercomputing Lab
Brigham Young University
http://marylou.byu.edu
On 04/23/2014 09:35 AM, Alan Brown wrote:
> 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
>
------------------------------------------------------------------------------
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
|
