API tools faq
paste
Advertisement
Guest User

zabbix partitioning RR

a guest
May 23rd, 2018
82
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 10.83 KB | None | 0 0
raw download clone embed print report
  1. -- 23.05.2018
  2. ALTER TABLE zabbix_gu_1.history DROP PARTITION p2017_12;
  3. ALTER TABLE zabbix_gu_1.history DROP PARTITION p2018_01;
  4. ALTER TABLE zabbix_gu_1.history_log DROP PARTITION p2017_12;
  5. ALTER TABLE zabbix_gu_1.history_log DROP PARTITION p2018_01;
  6. ALTER TABLE zabbix_gu_1.history_uint DROP PARTITION p2017_12;
  7. ALTER TABLE zabbix_gu_1.history_uint DROP PARTITION p2018_01;
  8.  
  9. -- 2-2019
  10. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2019_02 VALUES LESS THAN (UNIX_TIMESTAMP("2019-02-28 23:59:59")) ENGINE = InnoDB);
  11. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2019_02 VALUES LESS THAN (UNIX_TIMESTAMP("2019-02-28 23:59:59")) ENGINE = InnoDB);
  12. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2019_02 VALUES LESS THAN (UNIX_TIMESTAMP("2019-02-28 23:59:59")) ENGINE = InnoDB);
  13. -- 3-2019
  14. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2019_03 VALUES LESS THAN (UNIX_TIMESTAMP("2019-03-31 23:59:59")) ENGINE = InnoDB);
  15. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2019_03 VALUES LESS THAN (UNIX_TIMESTAMP("2019-03-31 23:59:59")) ENGINE = InnoDB);
  16. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2019_03 VALUES LESS THAN (UNIX_TIMESTAMP("2019-03-31 23:59:59")) ENGINE = InnoDB);
  17. -- 4-2019
  18. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2019_04 VALUES LESS THAN (UNIX_TIMESTAMP("2019-04-30 23:59:59")) ENGINE = InnoDB);
  19. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2019_04 VALUES LESS THAN (UNIX_TIMESTAMP("2019-04-30 23:59:59")) ENGINE = InnoDB);
  20. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2019_04 VALUES LESS THAN (UNIX_TIMESTAMP("2019-04-30 23:59:59")) ENGINE = InnoDB);
  21. -- 5-2019
  22. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2019_05 VALUES LESS THAN (UNIX_TIMESTAMP("2019-05-31 23:59:59")) ENGINE = InnoDB);
  23. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2019_05 VALUES LESS THAN (UNIX_TIMESTAMP("2019-05-31 23:59:59")) ENGINE = InnoDB);
  24. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2019_05 VALUES LESS THAN (UNIX_TIMESTAMP("2019-05-31 23:59:59")) ENGINE = InnoDB);
  25. -- 6-2019
  26. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2019_06 VALUES LESS THAN (UNIX_TIMESTAMP("2019-06-30 23:59:59")) ENGINE = InnoDB);
  27. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2019_06 VALUES LESS THAN (UNIX_TIMESTAMP("2019-06-30 23:59:59")) ENGINE = InnoDB);
  28. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2019_06 VALUES LESS THAN (UNIX_TIMESTAMP("2019-06-30 23:59:59")) ENGINE = InnoDB);
  29. -- 7-2019
  30. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2019_07 VALUES LESS THAN (UNIX_TIMESTAMP("2019-07-31 23:59:59")) ENGINE = InnoDB);
  31. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2019_07 VALUES LESS THAN (UNIX_TIMESTAMP("2019-07-31 23:59:59")) ENGINE = InnoDB);
  32. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2019_07 VALUES LESS THAN (UNIX_TIMESTAMP("2019-07-31 23:59:59")) ENGINE = InnoDB);
  33. -- 8-2019
  34. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2019_08 VALUES LESS THAN (UNIX_TIMESTAMP("2019-08-31 23:59:59")) ENGINE = InnoDB);
  35. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2019_08 VALUES LESS THAN (UNIX_TIMESTAMP("2019-08-31 23:59:59")) ENGINE = InnoDB);
  36. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2019_08 VALUES LESS THAN (UNIX_TIMESTAMP("2019-08-31 23:59:59")) ENGINE = InnoDB);
  37. -- 9-2019
  38. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2019_09 VALUES LESS THAN (UNIX_TIMESTAMP("2019-09-30 23:59:59")) ENGINE = InnoDB);
  39. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2019_09 VALUES LESS THAN (UNIX_TIMESTAMP("2019-09-30 23:59:59")) ENGINE = InnoDB);
  40. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2019_09 VALUES LESS THAN (UNIX_TIMESTAMP("2019-09-30 23:59:59")) ENGINE = InnoDB);
  41. -- 10-2019
  42. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2019_10 VALUES LESS THAN (UNIX_TIMESTAMP("2019-10-31 23:59:59")) ENGINE = InnoDB);
  43. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2019_10 VALUES LESS THAN (UNIX_TIMESTAMP("2019-10-31 23:59:59")) ENGINE = InnoDB);
  44. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2019_10 VALUES LESS THAN (UNIX_TIMESTAMP("2019-10-31 23:59:59")) ENGINE = InnoDB);
  45. -- 11-2019
  46. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2019_11 VALUES LESS THAN (UNIX_TIMESTAMP("2019-11-30 23:59:59")) ENGINE = InnoDB);
  47. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2019_11 VALUES LESS THAN (UNIX_TIMESTAMP("2019-11-30 23:59:59")) ENGINE = InnoDB);
  48. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2019_11 VALUES LESS THAN (UNIX_TIMESTAMP("2019-11-30 23:59:59")) ENGINE = InnoDB);
  49. -- 12-2019
  50. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2019_12 VALUES LESS THAN (UNIX_TIMESTAMP("2019-12-31 23:59:59")) ENGINE = InnoDB);
  51. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2019_12 VALUES LESS THAN (UNIX_TIMESTAMP("2019-12-31 23:59:59")) ENGINE = InnoDB);
  52. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2019_12 VALUES LESS THAN (UNIX_TIMESTAMP("2019-12-31 23:59:59")) ENGINE = InnoDB);
  53. -- 1-2020
  54. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_01 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-31 23:59:59")) ENGINE = InnoDB);
  55. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_01 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-31 23:59:59")) ENGINE = InnoDB);
  56. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_01 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-31 23:59:59")) ENGINE = InnoDB);
  57. -- 2-2020
  58. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_02 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-29 23:59:59")) ENGINE = InnoDB);
  59. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_02 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-29 23:59:59")) ENGINE = InnoDB);
  60. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_02 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-29 23:59:59")) ENGINE = InnoDB);
  61. -- 3-2020
  62. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_03 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-31 23:59:59")) ENGINE = InnoDB);
  63. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_03 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-31 23:59:59")) ENGINE = InnoDB);
  64. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_03 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-31 23:59:59")) ENGINE = InnoDB);
  65. -- 4-2020
  66. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_04 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-30 23:59:59")) ENGINE = InnoDB);
  67. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_04 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-30 23:59:59")) ENGINE = InnoDB);
  68. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_04 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-30 23:59:59")) ENGINE = InnoDB);
  69. -- 5-2020
  70. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-31 23:59:59")) ENGINE = InnoDB);
  71. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-31 23:59:59")) ENGINE = InnoDB);
  72. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-31 23:59:59")) ENGINE = InnoDB);
  73. -- 6-2020
  74. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_06 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-30 23:59:59")) ENGINE = InnoDB);
  75. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_06 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-30 23:59:59")) ENGINE = InnoDB);
  76. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_06 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-30 23:59:59")) ENGINE = InnoDB);
  77. -- 7-2020
  78. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_07 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-31 23:59:59")) ENGINE = InnoDB);
  79. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_07 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-31 23:59:59")) ENGINE = InnoDB);
  80. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_07 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-31 23:59:59")) ENGINE = InnoDB);
  81. -- 8-2020
  82. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_08 VALUES LESS THAN (UNIX_TIMESTAMP("2020-08-31 23:59:59")) ENGINE = InnoDB);
  83. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_08 VALUES LESS THAN (UNIX_TIMESTAMP("2020-08-31 23:59:59")) ENGINE = InnoDB);
  84. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_08 VALUES LESS THAN (UNIX_TIMESTAMP("2020-08-31 23:59:59")) ENGINE = InnoDB);
  85. -- 9-2020
  86. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_09 VALUES LESS THAN (UNIX_TIMESTAMP("2020-09-30 23:59:59")) ENGINE = InnoDB);
  87. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_09 VALUES LESS THAN (UNIX_TIMESTAMP("2020-09-30 23:59:59")) ENGINE = InnoDB);
  88. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_09 VALUES LESS THAN (UNIX_TIMESTAMP("2020-09-30 23:59:59")) ENGINE = InnoDB);
  89. -- 10-2020
  90. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_10 VALUES LESS THAN (UNIX_TIMESTAMP("2020-10-31 23:59:59")) ENGINE = InnoDB);
  91. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_10 VALUES LESS THAN (UNIX_TIMESTAMP("2020-10-31 23:59:59")) ENGINE = InnoDB);
  92. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_10 VALUES LESS THAN (UNIX_TIMESTAMP("2020-10-31 23:59:59")) ENGINE = InnoDB);
  93. -- 11-2020
  94. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_11 VALUES LESS THAN (UNIX_TIMESTAMP("2020-11-30 23:59:59")) ENGINE = InnoDB);
  95. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_11 VALUES LESS THAN (UNIX_TIMESTAMP("2020-11-30 23:59:59")) ENGINE = InnoDB);
  96. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_11 VALUES LESS THAN (UNIX_TIMESTAMP("2020-11-30 23:59:59")) ENGINE = InnoDB);
  97. -- 12-2020
  98. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2020_12 VALUES LESS THAN (UNIX_TIMESTAMP("2020-12-31 23:59:59")) ENGINE = InnoDB);
  99. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2020_12 VALUES LESS THAN (UNIX_TIMESTAMP("2020-12-31 23:59:59")) ENGINE = InnoDB);
  100. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2020_12 VALUES LESS THAN (UNIX_TIMESTAMP("2020-12-31 23:59:59")) ENGINE = InnoDB);
  101. -- 1-2021
  102. ALTER TABLE zabbix_gu_1.history_uint ADD PARTITION (PARTITION p2021_01 VALUES LESS THAN (UNIX_TIMESTAMP("2021-01-31 23:59:59")) ENGINE = InnoDB);
  103. ALTER TABLE zabbix_gu_1.history ADD PARTITION (PARTITION p2021_01 VALUES LESS THAN (UNIX_TIMESTAMP("2021-01-31 23:59:59")) ENGINE = InnoDB);
  104. ALTER TABLE zabbix_gu_1.history_log ADD PARTITION (PARTITION p2021_01 VALUES LESS THAN (UNIX_TIMESTAMP("2021-01-31 23:59:59")) ENGINE = InnoDB);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!