> -----Original Message-----
> From: Uwe Schuerkamp [mailto:uwe.schuerk...@nionex.net]
> Sent: Tuesday, December 15, 2015 4:47 AM
> To: Lewis, Dave
> Cc: bacula-users@lists.sourceforge.net
> Subject: Re: [Bacula-users] Bacula backup speed
>
...
> Hi Dave,
>
> how large is your catalog database? How many entries do you have in
> your File table, for instance? Attribute despooling should be much
> faster than what you're seeing even on SATA disks.
Hi Uwe,
I don't know much about databases, but I'm learning.
We have 659,172 entries in the File table.
> I guess your mysql setup could do with some optimization w/r to buffer
> pool size (I hope you're using InnoDB as the backend db engine) and
> lock / write strategies.
The command
SHOW TABLE STATUS;
shows that we're using InnoDB.
> As your DB runs on the director machine, I'd assign at last 50% of the
> available RAM if your catalog has a similar size.
>
> A quick google search came up with the following query to determine
> your catalog db size:
>
> SELECT table_schema "DB Name",
> Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
> FROM information_schema.tables GROUP BY table_schema;
>
> All the best, Uwe
The above command gave
+--------------------+---------------+
| DB Name | DB Size in MB |
+--------------------+---------------+
| bacula | 216.6 |
| information_schema | 0.0 |
+--------------------+---------------+
To assign 50% of RAM (we have 16 GB total) I suppose I should add the line
innodb_buffer_pool_size = 8G
in /etc/mysql/my.cnf, then I assume restart MySQL. But maybe we don't need it
that big at this time, since the database is much smaller.
Our my.cnf doesn't currently have a line for innodb_buffer_pool_size; I don't
know what it uses by default.
Thanks,
Dave
IMPORTANT NOTICE: This e-mail is meant only for the use of the intended
recipient. It may contain confidential information which is legally privileged
or otherwise protected by law. If you received this e-mail in error or from
someone who is not authorized to send it to you, you are strictly prohibited
from reviewing, using, disseminating, distributing or copying the e-mail.
PLEASE NOTIFY US IMMEDIATELY OF THE ERROR BY RETURN E-MAIL AND DELETE THIS
MESSAGE FROM YOUR SYSTEM. Thank you for your cooperation.
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
