[Baruwa] baruwa2.db

[Jan Agermose]

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: baruwa-bounces at lists.baruwa.org [mailto:baruwa-bounces at lists.baruwa.org] 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" <ja at conviator.com> 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: baruwa-bounces at lists.baruwa.org [mailto:baruwa-bounces at lists.baruwa.org] 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: baruwa-bounces at lists.baruwa.org
> [mailto:baruwa-bounces at lists.baruwa.org] 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: baruwa-bounces at lists.baruwa.org
> [mailto:baruwa-bounces at lists.baruwa.org] 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" <ja at conviator.com> 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: baruwa-bounces at lists.baruwa.org
> [mailto:baruwa-bounces at lists.baruwa.org] 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
>> Baruwa at lists.baruwa.org
>> http://lists.baruwa.org/mailman/listinfo/baruwa
>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056
>> 
>> _______________________________________________
>> Baruwa mailing list
>> Baruwa at lists.baruwa.org
>> http://lists.baruwa.org/mailman/listinfo/baruwa
>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056
>> 
> _______________________________________________
> Baruwa mailing list
> Baruwa at lists.baruwa.org
> http://lists.baruwa.org/mailman/listinfo/baruwa
> Keep Baruwa FREE - http://pledgie.com/campaigns/12056
> 
> _______________________________________________
> Baruwa mailing list
> Baruwa at lists.baruwa.org
> http://lists.baruwa.org/mailman/listinfo/baruwa
> Keep Baruwa FREE - http://pledgie.com/campaigns/12056
> 
> 
> _______________________________________________
> Baruwa mailing list
> Baruwa at lists.baruwa.org
> http://lists.baruwa.org/mailman/listinfo/baruwa
> Keep Baruwa FREE - http://pledgie.com/campaigns/12056
> 
_______________________________________________
Baruwa mailing list
Baruwa at lists.baruwa.org
http://lists.baruwa.org/mailman/listinfo/baruwa
Keep Baruwa FREE - http://pledgie.com/campaigns/12056