-----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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
