Bacula-users

Re: [Bacula-users] Bacula database is getting too long

2012-01-11 15:33:43
Subject: Re: [Bacula-users] Bacula database is getting too long
From: Phil Stracchino <alaric AT metrocast DOT net>
To: bacula-users AT lists.sourceforge DOT net
Date: Wed, 11 Jan 2012 15:31:48 -0500
On 01/11/12 14:21, Honia A wrote:
> I'm backing up a handful number of Unix boxes, they all get backed up
> very quickly but we can't access them due to the BackupCatalog job being
> very slow. When I read online, I see people said it's because of the
> database size getting larger and larger.

200MB is NOTHING.  My company has customers with MySQl Dbs approachint 1TB.

Have you looked at your MySQL configuration?  I'm going to go out on a
limb here and take a wild guess that your MySQL instance was installed
long ago using a default configuration file, then never upgraded and
never tuned.  You don't want to know how many production websites I've
seen trying to run off MySQL instances with "small to medium server"
configuration files that were written back when a "large server" was one
that had more than 32MB of RAM.


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual 
desktops for less than the cost of PCs and save 60% on VDI infrastructure 
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users