09.Partitioning of Oracle tables

oracle basic system learning directory 01.CentOS7 silently install oracle11g 02.Oracle startup process 03. Start with simple sql 04.Oracle’s architecture 05.Oracle database objects 06.Oracle data backup and recovery 07.User and permission management 08.Oracle tables 09.Partitioning of Oracle tables 10.Oracle synonyms and sequences 11.Oracle’s view 12.Oracle index 13.Oracle connects to Java through JDBC 14.Transactions in Oracle 15.Oracle11g […]

IsolarAB exports arxml to Matlab/Simulink to generate the model and configure the memory partition

This article uses a simple example to illustrate how to import the SWC arxml designed by Isolar into simulink to generate a model, and specify that the code generated by simulink has memory partition information. The SWC created in this article is called ECAS_Sensor_SWC. Its main function is to process sensor signals and pass them […]

Operation of partition table and bucket table in Hive

Table of Contents Partition Table First level partition table Knowledge points Example multi-level partitioning Knowledge points Example Partition table operations Example hadoop_hive documentation Bucket table Important parameters Basic bucket table Knowledge points Example Bucket table sorting Knowledge points Example Bucketing principle The difference between partition table and bucket table Partition table Partitioned table features/benefits: It […]

Disk partitioning, formatting, verification and mounting —- fdisk, mkfs, mount

Disk partitioning, formatting, verification and mounting Disk management is very important. When we want to add a new disk to the system, we should perform the following steps: Divide the disk to create usable hard disk partitions (fdisk/gdisk) Format the hard drive partition to create a system-usable file system (mkfs) Check the newly created file […]

Partition table locks and how to add partitions

Create partition #Create partition partition table postgres=# create table t_partition (p timestamp,v1 varchar(2),v2 text) partition by range (p); CREATE TABLE #Create three partitions postgres=# create table p0 partition of t_partition for values from (‘2022-3-13’) to (‘2022-3-14’); CREATE TABLE postgres=# create table p1 partition of t_partition for values from (‘2022-3-14’) to (‘2022-3-15’); CREATE TABLE postgres=# create […]

Use PTONLNE to change MYSQL partition table

Original link: Code snippet_Use PTONLNE to change the MYSQL partition table tags: Preface: This article is compiled by the editor of Xiaojianshi.com (cha138.com). It mainly introduces the knowledge related to using PTONLNE to change the MYSQL partition table. I hope it will be of certain reference value to you. In the previous article, ALTER was […]

Kafka – 3.x partition allocation strategy and rebalancing incomplete guide

Article directory Production experience – partition allocation strategy and rebalancing Range and rebalancing of producer partition allocation Range partitioning strategy principle Range partition allocation strategy and rebalancing case RoundRobin strategy and rebalancing of producer partition allocation RoundRobin partition strategy principle RoundRobin partition allocation strategy and rebalancing case Sticky and rebalancing of producer partition allocation Sticky […]