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
