>The mysql(5.1.61) is located on the server itself
An nice system design!? If assp requests some hundreds of MySQL records
and some other threads are doing regexes at the same time - and the MySQl
server uses multiple threads to process the request, ASSP and MySQL are
fighting against each other for system resources.
Yes, such a setup could work for some configurations. but if not - use a
separate system for the DB. An bad designed regular expression could cause
the same issue.
I use such a setup on a low load system (2000 mails a day) with 6GB RAM
and 4 CPU cores.
>Question: what other version could be considered to be "stable"?
All my systems are running the latest dev version (2.1.2) every time -
never saw a major problem .
>I think it has something to do with the fact that ASSP goes from 1Gb to
>4Gb(all of the servers memory) memory consumption in less than 3 days.
An ASSP system should never swap memory!
1GB at startup - this is only normal (if DB: is used for all main lists
and hashes) for a setup of 8-10 SMTP workers on a 64 Bit Perl.
4Gb(all of the servers memory) - looks like the rebuild task uses no
database for the internal hashes!?
Thomas
Von: "Pontus Karlsson" <pon...@scandinavianhosting.se>
An: <assp-test@lists.sourceforge.net>
Datum: 02.04.2012 13:53
Betreff: [Assp-test] Stable versions?
Hi!
I run ASSP version 2.1.2(12064) mostly due to read "recommendations" on
this
list, but during a test period of 4 days it sometimes flip and I get loads
of:
"warning: got database error Database select statement failed: MySQL
server
has gone away at sub main::checkDBCon line 27 thread 6 on table
delaywhitedb - try to reconnect"
Then it all go ballistic... (And I get nuked with error reports 800+ in
the
assp log it escalates with loads of mysql errors)
I think it has something to do with the fact that ASSP goes from 1Gb to
4Gb(all of the servers memory) memory consumption in less than 3 days.
The mysql(5.1.61) is located on the server itself and is using localhost
when connecting so I am confused to find there would be a problem to
connect
to it.
I would think ASSP steals all the memory and there is no left to create
mysqlconnections.
I run all this on Debian Squeeze(6.0.4).
Question: what other version could be considered to be "stable"? (I guess
one would say/think the latest... is it?)
Regards,
Pontus
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally
privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no
known virus in this email!
*******************************************************
------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
