Tag:data file

  • Identify tablespace (non extended) usage and automatically generate scripts to add data files

    Time:2021-9-5

    ruleYou can adjust the script to suit your use according to the following rules. Identify that the utilization rate of table space (non extended) is > = 90%, and the remaining available space is < = 100000m;Identify the part before \ or / in the data file name as the data file path (distinguish between […]

  • MySQL cold backup process

    Time:2021-7-20

    MySQL cold backup process Package and compress the data file of MySQL, and copy the corresponding file to cover when you want to recover. Cold backup is actually the simplest backup method (well, I almost crashed the database the first time). However, due to the requirement of stopping MySQL service for backup and recovery, and […]

  • Export postgre data to a file

    Time:2021-7-18

    During data migration, you need to export and input data through files, and then import new databases. The specific operation is divided into the following three steps: 1. Log in to the server side of the database PSQL – H 1.1.1.1 (IP) – P (port) – D (Library name) — user name = user name […]

  • CentOS solution to jam during installation of Yum

    Time:2021-6-28

    Yum is a package manager based on RPM YUM is an RPM-based package manager Supplementary notes Supplementary note Yum is a software package manager based on RPM in Fedora, RedHat and SUSE. It enables system administrators to update and manage RPM packages interactively and automatically. It can download and install RPM packages from specified servers […]

  • Docker storage, time zone, image acceleration and other configuration problems (RedHat)

    Time:2021-6-24

    Configure storage, accelerate vim /etc/docker/daemon.json { “registry-mirrors”: [“https://90sc1jac.mirror.aliyuncs.com”], “storage-driver”: “overlay” } Modify the default storage location of data files $ systemclt stop docker.service $ mv /var/lib/docker /data/docker $ ln -s /data/docker /var/lib/docker $ systemctl start docker.service Time zone issues Dockerfile #Time zone problem RUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \ && echo “Asia/shanghai” > /etc/timezone Mount host […]

  • Oracle create database and user, table space, manage table space and data file

    Time:2021-5-7

    introduce A table space is a logical part of a database Physically: the database data is stored in the data file Logically, the database is stored in the table space A table space consists of one or more data files   Logical structure of database Introduction: Logical structure in Oracle includes table space, segment, zone, […]

  • Redis and Memcache

    Time:2021-4-21

    1. The difference between redis and Memcache Redis supports complex data structures Redis supports native cluster mode Redis only uses a single core, while Memcache can use multiple cores. So on average, the efficiency of storing small data on each core is higher than that of Memcache. For data storage above 100k, Memcache is more […]

  • Installing Oracle database with docker under virtual machine (alicloud source)

    Time:2021-4-13

    Environmental preparation Docker environment Install docker Create a new virtual machine without installing the docker environment. Execute the following command to install it:yum install docker -yyum updateUpgrade the machine to the latest version~Execute after installationdocker –versionTo see the docker installation versionDocker version 1.13.1, build cccb291/1.13.1 Start docker rootThe user executes the command:systemctl start docker.servicesystemctl enable […]

  • Introduction to Apache Hudi

    Time:2021-4-11

    Introduction to Apache Hudi [TOC] Real time data processing and real time data processing Real time is divided into processing real-time and data real-timeAd hoc analysis requires real-time data processing, and the corresponding results should be obtained immediatelyFlink and spark streaming are used for real-time processing of real-time dataThe scene where the data is not […]

  • Deep dry goods | how to achieve rapid recovery of Oracle backup with cloud native?

    Time:2021-4-2

    Introduction:DBS Oracle backup product is a cloud backup product developed by Alibaba cloud itself, combined with years of Oracle database production experience of Alibaba group. It not only provides the Oracle backup capability provided by traditional backup, but also realizes the intrusion free streaming backup capability. At the same time, it deeply combines with cloud […]

  • MySQL — 1 — general structure and execution process

    Time:2021-3-26

    Introduction of MySQL structure Simplified version of MySQL structure diagram: MySQL logic architecture is divided into three layers 1. Client: not unique to MySQL, such as connection processing, authorization authentication, security and other functions are processed in this layer 2. Core services: including query parsing, analysis, optimization, caching, built-in functions (such as time, mathematics, encryption, […]

  • Oracle table space expansion

    Time:2021-3-21

    1. Table space capacity index query SELECT TABLESPACE_ Name “table space,”, To_char(Round(BYTES / 1024, 2), ‘99990.00’) ||It’s true, To_char(Round(FREE / 1024, 2), ‘99990.00’) ||’g’ “existing,”, To_char(Round(( BYTES – FREE ) / 1024, 2), ‘99990.00’) ||’g’ “use”, To_char(Round(10000 * USED / BYTES) / 100, ‘99990.00’) ||’%’ “proportion” FROM (SELECT A.TABLESPACE_NAME TABLESPACE_NAME, Floor(A.BYTES / ( 1024 * […]