Hi, I am running Dbmail 3.1.17 with authlog enabled. Database is PgSQL.
Server has lots of processing power (2 sixcore processors, > 128 GB RAM, fast SAS disks, RAID-6) The server has 50 simultaneous connections. DB size is 300 GB. I have noticed a huge performance issue when authlog is enabled. I am monitoring slow statements in DB size and almost all UPDATE queries in dbmail_authlog take 2 seconds or more. Tried to delete all records in this table and still no luck with any performance improvement. In this scenario the CPU processing is between in the range of 80-95%. < 2015-02-23 16:39:18.401 BRT >LOG: duration: 2009.685 ms execute 34345: UPDATE dbmail_authlog SET logout_time=NOW(), status=$1, bytes_rx=$2, bytes_tx=$3 WHERE id=$4 If I disable authlog, CPU processing goes to 20%. Considering authlog is important for auditing purposes, is it possible to tweak its performance? There is a huge gap in performance when using authlog feature. >From my understanding, it should be nice to have a separate database for just >authlog processing. Sincerely. Rogerio
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
