Skip to main content
Question

Centreon DB partitioning - tables not partitioned

  • May 20, 2025
  • 1 reply
  • 29 views

Forum|alt.badge.img+6

Hi,

One of our remote server centreon_storage tables are not partitioned properly. all tables below.


My question is, what is the best approach to fix the issue?

Should I try to use this on the docs? 
https://docs.centreon.com/docs/administration/database-partitioning/

Or Do I need to re-create the centreon_storage DB?

Also noticed that data_bin table is already partitioned​ into one.​​​​​​

-rw-rw---- 1 mysql mysql 479606079488 May 20 15:41 data_bin#P#pmax.ibd
 

Thank you in advance for the suggestions.

 

 

1 reply

lpinsivy
Centreonian
Forum|alt.badge.img+21
  • Centreonian
  • June 11, 2025

Hi ​@kimpoy0730, you can dump you DB and try procedure from our documentation.