MySQL partitioning Help

[LukeAB93UK]

Hello,

I have inherited a Zabbix Server with MySQL and partitioning enabled with zero documentation on how it was set up and when its going to start purging data.

Does anyone know how I can check how it was set up so I know when its going to start getting rid of data.

Starting fresh is not an option as this is a production server running 6.4.15 and the database is 570gb.

This is what my database structure looks like

acknowledges.ibd               history_log#p#p2024_06_01.ibd  history#p#p2024_06_18.ibd       history_text#p#p2024_05_10.ibd  history_uint#p#p2024_05_27.ibd  lld_override_optag.ibd          timeperiods.ibd
actions.ibd                    history_log#p#p2024_06_02.ibd  history#p#p2024_06_19.ibd       history_text#p#p2024_05_11.ibd  history_uint#p#p2024_05_28.ibd  lld_override_optemplate.ibd     token.ibd
alerts.ibd                     history_log#p#p2024_06_03.ibd  history#p#p2024_06_20.ibd       history_text#p#p2024_05_12.ibd  history_uint#p#p2024_05_29.ibd  lld_override_optrends.ibd       trends#p#p2023_05.ibd
auditlog.ibd                   history_log#p#p2024_06_04.ibd  history#p#p2024_06_21.ibd       history_text#p#p2024_05_13.ibd  history_uint#p#p2024_05_30.ibd  maintenances_groups.ibd         trends#p#p2023_06.ibd
autoreg_host.ibd               history_log#p#p2024_06_05.ibd  history#p#p2024_06_22.ibd       history_text#p#p2024_05_14.ibd  history_uint#p#p2024_05_31.ibd  maintenances_hosts.ibd          trends#p#p2023_07.ibd
changelog.ibd                  history_log#p#p2024_06_06.ibd  history#p#p2024_06_23.ibd       history_text#p#p2024_05_15.ibd  history_uint#p#p2024_06_01.ibd  maintenances.ibd                trends#p#p2023_08.ibd
conditions.ibd                 history_log#p#p2024_06_07.ibd  history#p#p2024_06_24.ibd       history_text#p#p2024_05_16.ibd  history_uint#p#p2024_06_02.ibd  maintenances_windows.ibd        trends#p#p2023_09.ibd
config_autoreg_tls.ibd         history_log#p#p2024_06_08.ibd  history#p#p2024_06_25.ibd       history_text#p#p2024_05_17.ibd  history_uint#p#p2024_06_03.ibd  maintenance_tag.ibd             trends#p#p2023_10.ibd
config.ibd                     history_log#p#p2024_06_09.ibd  history#p#p2024_06_26.ibd       history_text#p#p2024_05_18.ibd  history_uint#p#p2024_06_04.ibd  media.ibd                       trends#p#p2023_11.ibd
connector.ibd                  history_log#p#p2024_06_10.ibd  history#p#p2024_06_27.ibd       history_text#p#p2024_05_19.ibd  history_uint#p#p2024_06_05.ibd  media_type.ibd                  trends#p#p2023_12.ibd
connector_tag.ibd              history_log#p#p2024_06_11.ibd  history_str#p#p2024_05_03.ibd   history_text#p#p2024_05_20.ibd  history_uint#p#p2024_06_06.ibd  media_type_message.ibd          trends#p#p2024_01.ibd
corr_condition_group.ibd       history_log#p#p2024_06_12.ibd  history_str#p#p2024_05_04.ibd   history_text#p#p2024_05_21.ibd  history_uint#p#p2024_06_07.ibd  media_type_param.ibd            trends#p#p2024_02.ibd
corr_condition.ibd             history_log#p#p2024_06_13.ibd  history_str#p#p2024_05_05.ibd   history_text#p#p2024_05_22.ibd  history_uint#p#p2024_06_08.ibd  module.ibd                      trends#p#p2024_03.ibd
corr_condition_tag.ibd         history_log#p#p2024_06_14.ibd  history_str#p#p2024_05_06.ibd   history_text#p#p2024_05_23.ibd  history_uint#p#p2024_06_09.ibd  opcommand_grp.ibd               trends#p#p2024_04.ibd
corr_condition_tagpair.ibd     history_log#p#p2024_06_15.ibd  history_str#p#p2024_05_07.ibd   history_text#p#p2024_05_24.ibd  history_uint#p#p2024_06_10.ibd  opcommand_hst.ibd               trends#p#p2024_05.ibd
corr_condition_tagvalue.ibd    history_log#p#p2024_06_16.ibd  history_str#p#p2024_05_08.ibd   history_text#p#p2024_05_25.ibd  history_uint#p#p2024_06_11.ibd  opcommand.ibd                   trends#p#p2024_06.ibd
correlation.ibd                history_log#p#p2024_06_17.ibd  history_str#p#p2024_05_09.ibd   history_text#p#p2024_05_26.ibd  history_uint#p#p2024_06_12.ibd  opconditions.ibd                trends#p#p2024_07.ibd
corr_operation.ibd             history_log#p#p2024_06_18.ibd  history_str#p#p2024_05_10.ibd   history_text#p#p2024_05_27.ibd  history_uint#p#p2024_06_13.ibd  operations.ibd                  trends#p#p2024_08.ibd
dashboard.ibd                  history_log#p#p2024_06_19.ibd  history_str#p#p2024_05_11.ibd   history_text#p#p2024_05_28.ibd  history_uint#p#p2024_06_14.ibd  opgroup.ibd                     trends#p#p2024_09.ibd
dashboard_page.ibd             history_log#p#p2024_06_20.ibd  history_str#p#p2024_05_12.ibd   history_text#p#p2024_05_29.ibd  history_uint#p#p2024_06_15.ibd  opinventory.ibd                 trends#p#p2024_10.ibd
dashboard_user.ibd             history_log#p#p2024_06_21.ibd  history_str#p#p2024_05_13.ibd   history_text#p#p2024_05_30.ibd  history_uint#p#p2024_06_16.ibd  opmessage_grp.ibd               trends#p#p2024_11.ibd
dashboard_usrgrp.ibd           history_log#p#p2024_06_22.ibd  history_str#p#p2024_05_14.ibd   history_text#p#p2024_05_31.ibd  history_uint#p#p2024_06_17.ibd  opmessage.ibd                   trends#p#p2024_12.ibd
dbversion.ibd                  history_log#p#p2024_06_23.ibd  history_str#p#p2024_05_15.ibd   history_text#p#p2024_06_01.ibd  history_uint#p#p2024_06_18.ibd  opmessage_usr.ibd               trends#p#p2025_01.ibd
dchecks.ibd                    history_log#p#p2024_06_24.ibd  history_str#p#p2024_05_16.ibd   history_text#p#p2024_06_02.ibd  history_uint#p#p2024_06_19.ibd  optemplate.ibd                  trends#p#p2025_02.ibd
dhosts.ibd                     history_log#p#p2024_06_25.ibd  history_str#p#p2024_05_17.ibd   history_text#p#p2024_06_03.ibd  history_uint#p#p2024_06_20.ibd  problem.ibd                     trends#p#p2025_03.ibd
drules.ibd                     history_log#p#p2024_06_26.ibd  history_str#p#p2024_05_18.ibd   history_text#p#p2024_06_04.ibd  history_uint#p#p2024_06_21.ibd  problem_tag.ibd                 trends#p#p2025_04.ibd
dservices.ibd                  history_log#p#p2024_06_27.ibd  history_str#p#p2024_05_19.ibd   history_text#p#p2024_06_05.ibd  history_uint#p#p2024_06_22.ibd  profiles.ibd                    trends_uint#p#p2023_05.ibd
escalations.ibd                history#p#p2024_05_03.ibd      history_str#p#p2024_05_20.ibd   history_text#p#p2024_06_06.ibd  history_uint#p#p2024_06_23.ibd  proxy_autoreg_host.ibd          trends_uint#p#p2023_06.ibd
event_recovery.ibd             history#p#p2024_05_04.ibd      history_str#p#p2024_05_21.ibd   history_text#p#p2024_06_07.ibd  history_uint#p#p2024_06_24.ibd  proxy_dhistory.ibd              trends_uint#p#p2023_07.ibd
events.ibd                     history#p#p2024_05_05.ibd      history_str#p#p2024_05_22.ibd   history_text#p#p2024_06_08.ibd  history_uint#p#p2024_06_25.ibd  proxy_history.ibd               trends_uint#p#p2023_08.ibd
event_suppress.ibd             history#p#p2024_05_06.ibd      history_str#p#p2024_05_23.ibd   history_text#p#p2024_06_09.ibd  history_uint#p#p2024_06_26.ibd  regexps.ibd                     trends_uint#p#p2023_09.ibd
event_symptom.ibd              history#p#p2024_05_07.ibd      history_str#p#p2024_05_24.ibd   history_text#p#p2024_06_10.ibd  history_uint#p#p2024_06_27.ibd  report.ibd                      trends_uint#p#p2023_10.ibd
event_tag.ibd                  history#p#p2024_05_08.ibd      history_str#p#p2024_05_25.ibd   history_text#p#p2024_06_11.ibd  host_discovery.ibd              report_param.ibd                trends_uint#p#p2023_11.ibd
expressions.ibd                history#p#p2024_05_09.ibd      history_str#p#p2024_05_26.ibd   history_text#p#p2024_06_12.ibd  host_inventory.ibd              report_user.ibd                 trends_uint#p#p2023_12.ibd
functions.ibd                  history#p#p2024_05_10.ibd      history_str#p#p2024_05_27.ibd   history_text#p#p2024_06_13.ibd  hostmacro.ibd                   report_usrgrp.ibd               trends_uint#p#p2024_01.ibd
globalmacro.ibd                history#p#p2024_05_11.ibd      history_str#p#p2024_05_28.ibd   history_text#p#p2024_06_14.ibd  host_rtdata.ibd                 rights.ibd                      trends_uint#p#p2024_02.ibd
globalvars.ibd                 history#p#p2024_05_12.ibd      history_str#p#p2024_05_29.ibd   history_text#p#p2024_06_15.ibd  hosts_groups.ibd                role.ibd                        trends_uint#p#p2024_03.ibd
graph_discovery.ibd            history#p#p2024_05_13.ibd      history_str#p#p2024_05_30.ibd   history_text#p#p2024_06_16.ibd  hosts.ibd                       role_rule.ibd                   trends_uint#p#p2024_04.ibd
graphs.ibd                     history#p#p2024_05_14.ibd      history_str#p#p2024_05_31.ibd   history_text#p#p2024_06_17.ibd  hosts_templates.ibd             scim_group.ibd                  trends_uint#p#p2024_05.ibd
graphs_items.ibd               history#p#p2024_05_15.ibd      history_str#p#p2024_06_01.ibd   history_text#p#p2024_06_18.ibd  host_tag.ibd                    script_param.ibd                trends_uint#p#p2024_06.ibd
graph_theme.ibd                history#p#p2024_05_16.ibd      history_str#p#p2024_06_02.ibd   history_text#p#p2024_06_19.ibd  housekeeper.ibd                 scripts.ibd                     trends_uint#p#p2024_07.ibd
group_discovery.ibd            history#p#p2024_05_17.ibd      history_str#p#p2024_06_03.ibd   history_text#p#p2024_06_20.ibd  hstgrp.ibd                      service_alarms.ibd              trends_uint#p#p2024_08.ibd
group_prototype.ibd            history#p#p2024_05_18.ibd      history_str#p#p2024_06_04.ibd   history_text#p#p2024_06_21.ibd  httpstep_field.ibd              service_problem.ibd             trends_uint#p#p2024_09.ibd
ha_node.ibd                    history#p#p2024_05_19.ibd      history_str#p#p2024_06_05.ibd   history_text#p#p2024_06_22.ibd  httpstep.ibd                    service_problem_tag.ibd         trends_uint#p#p2024_10.ibd
history_log#p#p2024_05_03.ibd  history#p#p2024_05_20.ibd      history_str#p#p2024_06_06.ibd   history_text#p#p2024_06_23.ibd  httpstepitem.ibd                services.ibd                    trends_uint#p#p2024_11.ibd
history_log#p#p2024_05_04.ibd  history#p#p2024_05_21.ibd      history_str#p#p2024_06_07.ibd   history_text#p#p2024_06_24.ibd  httptest_field.ibd              services_links.ibd              trends_uint#p#p2024_12.ibd
history_log#p#p2024_05_05.ibd  history#p#p2024_05_22.ibd      history_str#p#p2024_06_08.ibd   history_text#p#p2024_06_25.ibd  httptest.ibd                    service_status_rule.ibd         trends_uint#p#p2025_01.ibd
history_log#p#p2024_05_06.ibd  history#p#p2024_05_23.ibd      history_str#p#p2024_06_09.ibd   history_text#p#p2024_06_26.ibd  httptestitem.ibd                service_tag.ibd                 trends_uint#p#p2025_02.ibd
history_log#p#p2024_05_07.ibd  history#p#p2024_05_24.ibd      history_str#p#p2024_06_10.ibd   history_text#p#p2024_06_27.ibd  httptest_tag.ibd                sessions.ibd                    trends_uint#p#p2025_03.ibd
history_log#p#p2024_05_08.ibd  history#p#p2024_05_25.ibd      history_str#p#p2024_06_11.ibd   history_uint#p#p2024_05_03.ibd  icon_map.ibd                    sla_excluded_downtime.ibd       trends_uint#p#p2025_04.ibd
history_log#p#p2024_05_09.ibd  history#p#p2024_05_26.ibd      history_str#p#p2024_06_12.ibd   history_uint#p#p2024_05_04.ibd  icon_mapping.ibd                sla.ibd                         trigger_depends.ibd
history_log#p#p2024_05_10.ibd  history#p#p2024_05_27.ibd      history_str#p#p2024_06_13.ibd   history_uint#p#p2024_05_05.ibd  ids.ibd                         sla_schedule.ibd                trigger_discovery.ibd
history_log#p#p2024_05_11.ibd  history#p#p2024_05_28.ibd      history_str#p#p2024_06_14.ibd   history_uint#p#p2024_05_06.ibd  images.ibd                      sla_service_tag.ibd             trigger_queue.ibd
history_log#p#p2024_05_12.ibd  history#p#p2024_05_29.ibd      history_str#p#p2024_06_15.ibd   history_uint#p#p2024_05_07.ibd  interface_discovery.ibd         sysmap_element_trigger.ibd      triggers.ibd
history_log#p#p2024_05_13.ibd  history#p#p2024_05_30.ibd      history_str#p#p2024_06_16.ibd   history_uint#p#p2024_05_08.ibd  interface.ibd                   sysmap_element_url.ibd          trigger_tag.ibd
history_log#p#p2024_05_14.ibd  history#p#p2024_05_31.ibd      history_str#p#p2024_06_17.ibd   history_uint#p#p2024_05_09.ibd  interface_snmp.ibd              sysmaps_elements.ibd            userdirectory.ibd
history_log#p#p2024_05_15.ibd  history#p#p2024_06_01.ibd      history_str#p#p2024_06_18.ibd   history_uint#p#p2024_05_10.ibd  item_condition.ibd              sysmaps_element_tag.ibd         userdirectory_idpgroup.ibd
history_log#p#p2024_05_16.ibd  history#p#p2024_06_02.ibd      history_str#p#p2024_06_19.ibd   history_uint#p#p2024_05_11.ibd  item_discovery.ibd              sysmap_shape.ibd                userdirectory_ldap.ibd
history_log#p#p2024_05_17.ibd  history#p#p2024_06_03.ibd      history_str#p#p2024_06_20.ibd   history_uint#p#p2024_05_12.ibd  item_parameter.ibd              sysmaps.ibd                     userdirectory_media.ibd
history_log#p#p2024_05_18.ibd  history#p#p2024_06_04.ibd      history_str#p#p2024_06_21.ibd   history_uint#p#p2024_05_13.ibd  item_preproc.ibd                sysmaps_links.ibd               userdirectory_saml.ibd
history_log#p#p2024_05_19.ibd  history#p#p2024_06_05.ibd      history_str#p#p2024_06_22.ibd   history_uint#p#p2024_05_14.ibd  item_rtdata.ibd                 sysmaps_link_triggers.ibd       userdirectory_usrgrp.ibd
history_log#p#p2024_05_20.ibd  history#p#p2024_06_06.ibd      history_str#p#p2024_06_23.ibd   history_uint#p#p2024_05_15.ibd  items.ibd                       sysmap_url.ibd                  user_scim_group.ibd
history_log#p#p2024_05_21.ibd  history#p#p2024_06_07.ibd      history_str#p#p2024_06_24.ibd   history_uint#p#p2024_05_16.ibd  item_tag.ibd                    sysmap_user.ibd                 users_groups.ibd
history_log#p#p2024_05_22.ibd  history#p#p2024_06_08.ibd      history_str#p#p2024_06_25.ibd   history_uint#p#p2024_05_17.ibd  lld_macro_path.ibd              sysmap_usrgrp.ibd               users.ibd
history_log#p#p2024_05_23.ibd  history#p#p2024_06_09.ibd      history_str#p#p2024_06_26.ibd   history_uint#p#p2024_05_18.ibd  lld_override_condition.ibd      tag_filter.ibd                  usrgrp.ibd
history_log#p#p2024_05_24.ibd  history#p#p2024_06_10.ibd      history_str#p#p2024_06_27.ibd   history_uint#p#p2024_05_19.ibd  lld_override.ibd                task_acknowledge.ibd            valuemap.ibd
history_log#p#p2024_05_25.ibd  history#p#p2024_06_11.ibd      history_text#p#p2024_05_03.ibd  history_uint#p#p2024_05_20.ibd  lld_override_opdiscover.ibd     task_check_now.ibd              valuemap_mapping.ibd
history_log#p#p2024_05_26.ibd  history#p#p2024_06_12.ibd      history_text#p#p2024_05_04.ibd  history_uint#p#p2024_05_21.ibd  lld_override_operation.ibd      task_close_problem.ibd          widget_field.ibd
history_log#p#p2024_05_27.ibd  history#p#p2024_06_13.ibd      history_text#p#p2024_05_05.ibd  history_uint#p#p2024_05_22.ibd  lld_override_ophistory.ibd      task_data.ibd                   widget.ibd
history_log#p#p2024_05_28.ibd  history#p#p2024_06_14.ibd      history_text#p#p2024_05_06.ibd  history_uint#p#p2024_05_23.ibd  lld_override_opinventory.ibd    task.ibd
history_log#p#p2024_05_29.ibd  history#p#p2024_06_15.ibd      history_text#p#p2024_05_07.ibd  history_uint#p#p2024_05_24.ibd  lld_override_opperiod.ibd       task_remote_command.ibd
history_log#p#p2024_05_30.ibd  history#p#p2024_06_16.ibd      history_text#p#p2024_05_08.ibd  history_uint#p#p2024_05_25.ibd  lld_override_opseverity.ibd     task_remote_command_result.ibd
history_log#p#p2024_05_31.ibd  history#p#p2024_06_17.ibd      history_text#p#p2024_05_09.ibd  history_uint#p#p2024_05_26.ibd  lld_override_opstatus.ibd       task_result.ibd

But I am unable to dertermine when its going to start throwing data out

Thanks

[markosa]

I would start searching from cron some scripts which would do partitioning or from db if there's stored procedures for partitioning and event scheduler running those.

[Markku]

or from db if there's stored procedures for partitioning and event scheduler running those.

Some ideas for reference:

In mysql client: show events\G

In shell: sudo mysqldump --single-transaction --routines --events --no-data --no-create-info zabbix (will dump out the event and procedure configurations)

Markku