All,
I believe I'm having mysql database issues since upgrading to 7.2 (from 7.0.2). I run mysql innodb with 900Gb database that's largely the File table. Since upgrading, I lose a few jobs a night due to database locking timeouts, which I have set to 3600. I also log slow queries. It appears that typically during a months I have about 90-100 queries that take longer than 15 minutes to run. Already this month (upgraded earlier this week), I have 32 queries that take longer than 15 minutes. At this rate (after 2 days) that will up my regular average of 90-100 to 480! Something is wrong and the coincidence is pretty strong that it's related to the upgrade. Ideas? thanks, Stephen On 09/25/2015 09:02 AM, Stephen Thompson wrote: > > > So far so good. Minor snafu on my part when updating database, but I'm > running 7.2 now. Looking good so far. Will find out more when hundreds > of jobs run tonight. > > Stephen > > > > On 09/24/2015 08:40 AM, Stephen Thompson wrote: >> >> All, >> >> I typically patch bacula pretty frequently, but I saw the somewhat >> unusual notice on the latest release notes that warns it may not be >> ready for use in production. How stable is it? I don't really have the >> resources to test this out, but rather would have to go straight to >> production with it. I could always roll back, but that might entail the >> recovery from dump of a 900GB database. Opinions? >> >> thanks, >> Stephen >> > -- Stephen Thompson Berkeley Seismological Laboratory step...@seismo.berkeley.edu 215 McCone Hall # 4760 Office: 510.664.9177 University of California, Berkeley Remote: 510.214.6506 (Tue,Wed) Berkeley, CA 94720-4760 ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
