Re: [Bacula-users] Big log....
On 04/01/10 10:53, Matija Nalis wrote: > On Thu, Apr 01, 2010 at 10:56:03AM -0300, Gilberto Nunes wrote: >> But now that I see... the Log.MYD is in bacula directory locate on >> /var/lib/mysql... >> Then, i thing that this Log.MYD is onwer but bacula or not??? > > Yeah, I think Phil is wrong, you're not talking about same thing. Correct, yes, I mentally conflated the two. My error. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, Free Stater It's not the years, it's the mileage. -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Big log....
From: Gilberto Nunes > But now that I see... the Log.MYD is in bacula directory locate on http://www.bacula.org/manuals/en/install/install/Messages_Resource.html#MessagesChapter "destination = catalog Send the message to the Catalog database. The message will be written to the table named Log and a timestamp field will also be added. This permits Job Reports and other messages to be recorded in the Catalog so that they can be accessed by reporting software. Bacula will prune the Log records associated with a Job when the Job records are pruned. Otherwise, Bacula never uses these records internally, so this destination is only used for special purpose programs (e.g. bweb)." Maybe you want 'append' to log to a file... JD -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Big log....
On Thu, Apr 01, 2010 at 10:56:03AM -0300, Gilberto Nunes wrote: > But now that I see... the Log.MYD is in bacula directory locate on > /var/lib/mysql... > Then, i thing that this Log.MYD is onwer but bacula or not??? Yeah, I think Phil is wrong, you're not talking about same thing. /var/lib/mysql/bacula/Log.MYD / MYI is bacula table, which contains logged output for jobs (any errors etc., the stuff you get with "list joblog" bacula command), and not the MySQL SQL log. See it's contents for yourself with something like: mysql bacula -e 'select * from Log limit 30' It should be purged automatically when the jobs themselves are purged. I do not know what would happen if you decided to purge it manually from SQL (maybe nothing, but...). So if should probably shrink by itself after some time if you reduce your "Job Retention". Or maybe it is so big because some of your jobs had a ton of messages - that should also expire by itself with such jobs. Alternatively, I think you could modify your "catalog" line in "Messages" resources in config files, in order to log less (or even nothing). -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Big log....
Sorry But now that I see... the Log.MYD is in bacula directory locate on /var/lib/mysql... Then, i thing that this Log.MYD is onwer but bacula or not??? Thanks Phil Stracchino escreveu: > On 04/01/10 07:50, Gilberto Nunes wrote: > >> Hi buddies... >> >> I have bacula install here, and I see that file Log.MYD from Mysql is >> very big, about 1.5 GB! >> What the purpose of this Log.MYD??? >> Can I empty the contents of this file??? >> > > Gilberto, > As a general rule, unless you have specific auditing requirements, you > should probably only have transaction logging enabled on MySQL when > debugging. For routine operation, you should log only errors, precisely > *because* logging all transactions will generate vast quantities of log > data. > > > -- Gilberto Nunes Ferreira *Suporte T.I.* *Selbetti Gestão de Documentos* *(47) 3441-6004 / (47) 8861-6672* *Fax (47) 3441-6021* /*gilberto.nu...@selbetti.com.br*/ -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Big log....
Hi Phil... Thanks for your reply I will fix this... Phil Stracchino escreveu: On 04/01/10 07:50, Gilberto Nunes wrote: Hi buddies... I have bacula install here, and I see that file Log.MYD from Mysql is very big, about 1.5 GB! What the purpose of this Log.MYD??? Can I empty the contents of this file??? Gilberto, As a general rule, unless you have specific auditing requirements, you should probably only have transaction logging enabled on MySQL when debugging. For routine operation, you should log only errors, precisely *because* logging all transactions will generate vast quantities of log data. -- Gilberto Nunes Ferreira Suporte T.I. Selbetti Gestão de Documentos (47) 3441-6004 / (47) 8861-6672 Fax (47) 3441-6021 gilberto.nu...@selbetti.com.br -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Big log....
On 04/01/10 07:50, Gilberto Nunes wrote: > Hi buddies... > > I have bacula install here, and I see that file Log.MYD from Mysql is > very big, about 1.5 GB! > What the purpose of this Log.MYD??? > Can I empty the contents of this file??? Gilberto, As a general rule, unless you have specific auditing requirements, you should probably only have transaction logging enabled on MySQL when debugging. For routine operation, you should log only errors, precisely *because* logging all transactions will generate vast quantities of log data. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, Free Stater It's not the years, it's the mileage. -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users