Nagios Support Forum

benjaminsmith wrote:Hello @dlukinski,

The table sizes look much better. Are you still having the same issue with notifications? You can test this by submitting passive checks for a service to force a notification event.

passive-checks.png

That was DEV run, this is a PROD run from today

You have new mail in /var/spool/mail/root
[root@fikc-nagxiprod01 components]# echo "SELECT relname as Table, pg_size_pretty(pg_total_relation_size(relid)) As Size, pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as ExternalSize FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;" | psql nagiosxi nagiosxi
table | size | externalsize
---------------------+------------+--------------
xi_auth_tokens | 511 MB | 42 MB
xi_meta | 44 MB | 16 MB
xi_usermeta | 11 MB | 9048 kB
xi_events | 7760 kB | 7176 kB
xi_auditlog | 4608 kB | 3488 kB
xi_sessions | 176 kB | 168 kB
xi_users | 176 kB | 72 kB
xi_eventqueue | 136 kB | 96 kB
xi_sysstat | 128 kB | 72 kB
xi_options | 128 kB | 96 kB
xi_commands | 120 kB | 96 kB
xi_mibs | 72 kB | 64 kB
xi_cmp_trapdata | 24 kB | 24 kB
xi_cmp_trapdata_log | 16 kB | 16 kB
xi_incidents | 8192 bytes | 8192 bytes
(15 rows)

[root@fikc-nagxiprod01 components]#

Hello @dlukinski,

Did you run the vacuum on production? That looks normal. If you're still having the same issues, I'd like to view the database tables to make sure those settings are being written. This data is stored in the xi_users and xi_usermeta tables of the nagiosxi database.

Did you convert the nagiosxi database from postgres to MySql? Please let me know.