hi no, we are not running bayes in DB.
Yes, slow log is enabled but we have no slow querys so the only thing in the log is the time mark for when the server is restarted innodb - its installed using the scripts and descript on the webpage so table is "ENGINE=MyISAM DEFAULT CHARSET=latin1;" (taken from mysqldump at least) the question about waiting processes - its on the scanner correct? just to be sure (again) - since my baruwa2.db is beeing used - this is ONLY when it does not have time or possibility to deliver the insert to mysql? Its not logging to both? When will it try to move the inserts from the temp DB to mysql - only on restart or ? I just did a test of whats in the temp db: select * from temp_messages order by timestamp desc limit 1; and checked if the message ID of the displayed message is also searchable (therefore in mysql) in the web interface. It is - if this helps to pinpoint something. So its logging to temp DB but also or later logging to mysql - should it then not remove it from temp DB? dont even understand if its related to why its stopping logging sometimes... -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jason Ede Sent: 17. august 2011 09:18 To: Baruwa users list Subject: Re: [Baruwa] baruwa2.db Do you have MS using a bayes database stored on that mysql server? If so then what engine are you using for all your tables? Have you enabled the slow-query log for mysql as that can show a lot of information. Also run mysqltuner.pl from http://mysqltuner.pl to check on the memory config in mysql Look at the process list when there is a backlog to see what processes are waiting... Lastly what is the value of innodb_flush_log_at_trx_commit and are you using innodb_file_per_table ? Jason > -----Original Message----- > From: [email protected] [mailto:baruwa- > [email protected]] On Behalf Of Jeremy McSpadden > Sent: 16 August 2011 21:02 > To: Baruwa users list > Subject: Re: [Baruwa] baruwa2.db > > I would back track. Make sure you have a working MailScanner, then > insert baruwa into the stream. You can enable debug mode in MS via > MailScanner.conf > > -- > Jeremy McSpadden > Flux Labs, Inc > http://www.fluxlabs.net > Endless Solutions > Office : 850-588-4626 > Cell : 850-890-2543 > Fax : 850-254-2955 > ________________________________________ > From: [email protected] [baruwa- > [email protected]] On Behalf Of Jan Agermose [[email protected]] > Sent: Tuesday, August 16, 2011 2:56 PM > To: 'Baruwa users list' > Subject: Re: [Baruwa] baruwa2.db > > if I ssh to the server having problems and open a mysql connection to > the mysql server there are no problems. > > when the server "wakes" up after a reboot its also doing like 100.000 > inserts it seams without the mysql server reporting errors (if I > enable the sql logging of sql statements it seams all inserts are run > when the scanner is booted - have not countet... ) > > > then it stops later - dont know if its simply flushing all the inserts > and then in the mean time the scanner is finding it cannot log the new > messages so its appending to the temp db instead - dont know the code, > the setup of this temp db and so on... > > > > -----Original Message----- > From: [email protected] [mailto:baruwa- > [email protected]] On Behalf Of Jeremy McSpadden > Sent: 16. august 2011 21:49 > To: Baruwa users list > Subject: Re: [Baruwa] baruwa2.db > > Connection between them ? It sounds to me that you are having mysql > insert issues. > > -- > Jeremy McSpadden > Flux Labs, Inc > http://www.fluxlabs.net > Endless Solutions > Office : 850-588-4626 > Cell : 850-890-2543 > Fax : 850-254-2955 > > > On Aug 16, 2011, at 2:43 PM, "Jan Agermose" <[email protected]> wrote: > > > i added more RAM to all servers and rebooted all servers. non of > > them > where doing any swapping and its also handling A LOT less load than > our production setup based on older centos, older CPUs, older > mailscanner and a custom version of mailwatch where the DB does not > have more resources (same RAM actually sharing CPU with 10 other VM > where the new 3 VMs are running alone on two hosts) > > > > its running again - lets make a poll on how long :D > > > > ah, stopped logging already I see... > > > > > > -----Original Message----- > > From: [email protected] [mailto:baruwa- > [email protected]] On Behalf Of Jeremy McSpadden > > Sent: 16. august 2011 21:08 > > To: Baruwa users list > > Subject: Re: [Baruwa] baruwa2.db > > > > You may want to up the memory on your mysql server. Are they all 3 > running on the same server ? what is the connection between the 3 > servers if not ? > > > > -- > > Jeremy McSpadden > > Flux Labs, Inc > > http://www.fluxlabs.net > > Endless Solutions > > Office : 850-588-4626 > > Cell : 850-890-2543 > > Fax : 850-254-2955 > > > > > > > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]] On Behalf Of Jan Agermose > > Sent: Tuesday, August 16, 2011 2:10 PM > > To: 'Baruwa users list' > > Subject: Re: [Baruwa] baruwa2.db > > > > its not logging any errors > > > > the mysql/www is a VM with 2 CPU and 2GB RAM, the two scanners are > with 4GB RAM, 2CPU VM > > > > the hosts are 2x4c CPU, 32GB at the moment only running this :) so > > there > should be no content for the CPUs. Also all VMs show no load when > running TOP, no IO wait or anything. > > > > scanned mails per day around 30.000 mails > > > > > > > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]] On Behalf Of Jeremy > McSpadden > > Sent: 16. august 2011 21:06 > > To: Baruwa users list > > Subject: Re: [Baruwa] baruwa2.db > > > > Check your mysql logs. What are the servers specs? > > > > -- > > Jeremy McSpadden > > Flux Labs, Inc > > http://www.fluxlabs.net > > Endless Solutions > > Office : 850-588-4626 > > Cell : 850-890-2543 > > Fax : 850-254-2955 > > > > > > On Aug 16, 2011, at 2:04 PM, "Jan Agermose" <[email protected]> wrote: > > > >> ok, but how can we get to a solution - figure out what is going on. > >> > >> I rebooted the server this made it work again for lige 4 minutes :) > >> > >> > >> -----Original Message----- > >> From: [email protected] > > [mailto:[email protected]] On Behalf Of Andrew Colin > Kissa > >> Sent: 16. august 2011 21:03 > >> To: Baruwa users list > >> Subject: Re: [Baruwa] baruwa2.db > >> > >> > >> On 16 Aug 2011, at 8:49 PM, Jan Agermose wrote: > >> > >>> it looks strange that its starting the logger so often or? > >> > >> That seems to be caused the mailscanner children dying. > >> > >> -- > >> Baruwa - www.baruwa.org > >> > >> _______________________________________________ > >> Baruwa mailing list > >> [email protected] > >> http://lists.baruwa.org/mailman/listinfo/baruwa > >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > >> > >> _______________________________________________ > >> Baruwa mailing list > >> [email protected] > >> http://lists.baruwa.org/mailman/listinfo/baruwa > >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > >> > > _______________________________________________ > > Baruwa mailing list > > [email protected] > > http://lists.baruwa.org/mailman/listinfo/baruwa > > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > > > _______________________________________________ > > Baruwa mailing list > > [email protected] > > http://lists.baruwa.org/mailman/listinfo/baruwa > > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > > > > > _______________________________________________ > > Baruwa mailing list > > [email protected] > > http://lists.baruwa.org/mailman/listinfo/baruwa > > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > > _______________________________________________ > Baruwa mailing list > [email protected] > http://lists.baruwa.org/mailman/listinfo/baruwa > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > _______________________________________________ > Baruwa mailing list > [email protected] > http://lists.baruwa.org/mailman/listinfo/baruwa > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > _______________________________________________ > Baruwa mailing list > [email protected] > http://lists.baruwa.org/mailman/listinfo/baruwa > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Baruwa mailing list [email protected] http://lists.baruwa.org/mailman/listinfo/baruwa Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Baruwa mailing list [email protected] http://lists.baruwa.org/mailman/listinfo/baruwa Keep Baruwa FREE - http://pledgie.com/campaigns/12056
