polled_extras.ibd getting huge problem

This support forum board is for questions relating to Nagios Fusion.
jenstar13
Posts: 174
Joined: Wed May 11, 2016 7:48 am

Re: polled_extras.ibd getting huge problem

Post by jenstar13 »

Fusion version
Installed Version: 4.1.7

Query output
+-----------------+------------+
| Table | Size in MB |
+-----------------+------------+
| auth_tokens | 0.03 |
| commands | 0.02 |
| dashboards | 0.02 |
| dashlets | 0.02 |
| dashlets_params | 0.02 |
| log | 21.02 |
| meta | 0.05 |
| options | 0.02 |
| polled_averages | 0.03 |
| polled_data | 0.05 |
| polled_deltas | 0.03 |
| polled_extras | 216.08 |
| polling_lock | 0.02 |
| servers | 0.03 |
| sysstat | 0.03 |
| users | 0.03 |
| users_servers | 0.02 |
| views | 0.06 |
+-----------------+------------+
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: polled_extras.ibd getting huge problem

Post by ssax »

Looks good, only a couple MB difference.

Before:

Code: Select all

| polled_extras | 213.08 |
After:

Code: Select all

| polled_extras | 216.08 |
Should be good to go, just check it in a couple days, it should not go up fast.
jenstar13
Posts: 174
Joined: Wed May 11, 2016 7:48 am

Re: polled_extras.ibd getting huge problem

Post by jenstar13 »

checked again today, and it went down
polled_extras | 201.11

Thank you, you can close this ticket
Jen
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: polled_extras.ibd getting huge problem

Post by ssax »

Glad to hear it! Locking now!
Locked