Menu
blog.headdesk.me
blog.headdesk.me

Tag: mysql

Partitioning MySQL

This is purely for the sake of partitioning. In this example, I’ll quickly partition the wordpress comments table into partitions. The hash partition ensures data are evenly distributed across partitions. mysql> alter table wp_comments partition by hash(comment_ID) partitions 3; Query OK, 13 rows affected (0.04 sec) Records: 13 Duplicates: 0 Warnings: 0 Now check that…

  • aws (8)
  • coffee (1)
  • headfi (1)
  • linux (7)
  • others (55)
  • security (2)
  • tech (36)
  • wordpress (2)

apache aws awscli azure backup cloud coffee coreos distributed filesystem docker ec2 EL8 elasticcache etckeeper featured heartbleed kernel linux mail meltdown mysql php pine python rdp rds Redhat Red Hat RHEL RHEL7 rpm Ryzen snapshot spectre SSL systemd tech terraform ubuntu ubuntu upgrade vector vpn wordpress xtreemfs yum

©2022 blog.headdesk.me | Powered by SuperbThemes & WordPress