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 bo...@wustl.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 > ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.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@lists.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users