On Mon, Apr 21, 2014 at 08:25:50AM -0600, Lloyd Brown wrote:

> At the moment:
> 
> > mysql> select count(*) from File;
> > +-----------+
> > | count(*)  |
> > +-----------+
> > | 287794478 |
> > +-----------+
> > 1 row in set (0.00 sec)
> 
> 
> 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.

If you want to retain MySQL as the db backend I'd strongly suggest
switching to InnoDB on a MariaDB server. 

We have a catalog of similar size (about 400,000,000 entries in the
file table, DB size around 100GB) with 64GB of RAM and the system hums
along just fine (about 35GB RAM allocated to the innodb buffer pool).

Cheers, Uwe

-- 
NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA



------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.  Get 
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users