Tweet
data_bin table goes corrupt after 1GB
After my ODS/data_bin table grew above 1GB, it keeps getting corrupt. I have to run repair table data_bin to get it to graph again, which loses some data. Any ideas why this table would keep getting corrupt?
-
-
1GBytes !!! It's time to think Oracle, no ?
Intel(R) Xeon(TM) CPU 3.4GHz - MemTotal : 1034476 kB
Centreon 2.4.1 - Nagios 3.2.1 - Nagios Plugins 1.4.15 - Manubulon Plugins tuné
Fedora Core 5 - 2.6.20-1.2320 -
Does Centreon support an Oracle db? I thought it only supported MySQL/PostgreSQL?Comment
-
It was a joke
Intel(R) Xeon(TM) CPU 3.4GHz - MemTotal : 1034476 kB
Centreon 2.4.1 - Nagios 3.2.1 - Nagios Plugins 1.4.15 - Manubulon Plugins tuné
Fedora Core 5 - 2.6.20-1.2320Comment
-
:-P
Turns out it wasn't the data_bin table that was growing out of control, it was the log table. I've changed my log retention to 2 days instead of 31 now, let's see how that goes.Comment
-
you can aslo optimize your table.
(OPTIMIZE TABLE data_bin)Guigui
> PAS DE SUPPORT VIA MP <
"Ce n'est qu'en essayant continuellement que l'on finit par réussir. En d'autres termes, plus ça rate et plus on a de chances que ça marche !!" (Shadoks)Comment
-
Thanks, will try that next time.Comment
Comment