Ad Widget

Collapse

MySQL Partitioning question

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • LenR
    Senior Member
    • Sep 2009
    • 1005

    #1

    MySQL Partitioning question

    For documentation, since I'm retiring at the end of the year :-) What happens if you fail to run partition maintenance and mysql doesn't have the proper partition for new data?

    I'm pretty sure it's an error message, but I don't remember it.

    Thanks
  • Markku
    Senior Member
    Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
    • Sep 2018
    • 1781

    #2
    This: https://mariadb.com/kb/en/range-partitioning-type/ suggests that the insert error is "ERROR 1526 (HY000): Table has no partition for value" (in MariaDB)

    Markku

    Comment

    • Markku
      Senior Member
      Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
      • Sep 2018
      • 1781

      #3
      ... but how Zabbix reacts to it, I don't know

      Markku

      Comment

      Working...