-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Am 08.06.2015 um 15:44 schrieb Alan Brown:

>>> The MySQL-Machine writes more or less constant 450KB/sec. to 
>>> disk (mysql process). top shows about 20% wait and 76% idle.
> That looks like an out-of-memory condition (waits are bad news).

> Either you don't have enough memory allocated to the DB and it's 
> using temporary files or you don't have enough memory in the 
> machine and it's swapping.

No swapping. Maximum possible memory usage for MySQL is: 3.5G (51% of
installed RAM).

I assume the waits are caused by mdadm.

>>> So it shouldn't slow down things that much.
> It does though. Writing to the database can take quite a while if 
> there are a large number of files in the backup.

> MySQL is small and fast but it becomes a memory hog very quickly.

> You should consider converting to Postgresql if MySQL has grown 
> past about 6-10Gb footprint.

Database is about 2.5Gb. Is there an easy way to convert my Catalog to
use Postgres?

Regards.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQIcBAEBCAAGBQJVdfKHAAoJELB26T3daKAJ0/oP/i9u3l7EPCIeOpa7BfEFjzUk
a0AHLMwON9/iuT2k+2lbo4Iggox8GTSapXlNv6PqphbnzBO0lkucg1IwFNNX9KPU
vbRdMkdKJoPEIPPWkXg5i0h7Oug4N3YMfno9vIEvam9v/2BaHrWWbUOigB+Z9TJh
m3LGaIb8Xw5wvWjOr2nLnbv3zPegkviZ+0JkPtJv2c8H3GM3NzJLmUfUABqZTfny
ZJG/hTbX4fIC+PVjhzpHXGBSqUDeNNWOLF6hgfkdYIz2irdK6bJasCLBAKUzDVJo
Rk9kPXtq3MF261p5NJmDnc2ELHDSO7BrjCS3GOCrtvrfuMmLrY27kBIrszUW/hRm
nqFrRWn0oQdgJBBZ5rB8G+qUYl/uItjWS1pt5Eo+IEkDReEdyi4tpNPEND2zm1SE
LBOpPzOPP+gCFhGYKBTKtDZrWpUFVr69z1kxWKm2fnK5uLxZ4uRIIZloQnD4gI7+
5tw9BTBy4Zxv5bnQDBjEfYcl3GKBJafAY97Hln4NVqy19c9bXgKLEU/g+2+ihvjR
YntARq2GIvd+Gs62IcKZPwwxtuje1qIF+QWfbjPqbkSL+wHelGPGvTYRF0gxby7q
eC2YSuSYGpPdxSJILdenhikH6jVbaR4P2O8A4mGBKPzghvEnhPrE09R910SDzGQb
p+qyBVEyMmXkGK6JfKNf
=IMIj
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users