I will if/when the installation gets larger again (at which point we may move
to the Commercial version finally); I'm down under 1 TB of Base backups now,
from a height of around 8TB. Honestly, Bacula's been so darn lightweight and
efficient for me the past 7+ years I never needed to bother - the only times
I've had any issue with it is when we had a machine with about 2TB of storage,
made up of up tens of millions of little JPGs.
At any rate; an 'optimize table File' fixed both the Restore issue and the
Incremental issue; it's back down to 'instantaneous' speed.
Mark Bober
Manager of Computational Services
Engineering IT - School of Engineering
Washington University in St. Louis
bober AT wustl DOT edu
314-935-5095
On Nov 21, 2011, at 8:47 PM, Phil Stracchino wrote:
> On 11/21/11 14:41, Mark Bober wrote:
>> This is MySQL 5.1.52 on Scientific Linux 6.1, 64 bit. I'm using the
>> my-huge.cnf in MySQL.
>
> Evewn "my-huge" isn't really for very big servers these days. Do
> yourself a favor: pick up a copy of O'Reilly High Performance MySQL and
> learn how to tune the DB properly. Tuning MySQL is less about how much
> hardware you have than what your data load is, how it's stored, and what
> your usage patterns are.
>
> (Example: I've seen servers with 10GB of MyISAM indexes, a 512MB MyISAM
> key buffer, and a 100% key buffer hit rate. Sure, only one twentieth of
> their indexes would fit in the cache ... but *those were the 1/20th
> they were actively USING*.
>
>
> --
> 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.
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|