Announcement

Collapse
No announcement yet.

data_bin table goes corrupt after 1GB

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SeanFromIT
    replied
    Thanks, will try that next time.

    Leave a comment:


  • Guigui2607
    replied
    you can aslo optimize your table.
    (OPTIMIZE TABLE data_bin)

    Leave a comment:


  • SeanFromIT
    replied
    :-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.

    Leave a comment:


  • DonKiShoot
    replied
    It was a joke

    Leave a comment:


  • SeanFromIT
    replied
    Does Centreon support an Oracle db? I thought it only supported MySQL/PostgreSQL?

    Leave a comment:


  • DonKiShoot
    replied
    1GBytes !!! It's time to think Oracle, no ?

    Leave a comment:


  • SeanFromIT
    started a topic data_bin table goes corrupt after 1GB

    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?
Working...
X