Announcement

Collapse
No announcement yet.

data_bin table goes corrupt after 1GB

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

  • 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?

  • #2
    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

    Comment


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

      Comment


      • #4
        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.2320

        Comment


        • #5
          :-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


          • #6
            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


            • #7
              Thanks, will try that next time.

              Comment

              Working...
              X