Mining mysqlbinlog binary Log Files in mysql Database

Click (here) to collapse or open 1. Check whether the mysql database enables binary log _ bin. The value of log _ bin is ON and mysql > show variables like 'log_%';+- is enabled.

2022-06-01 Database 我要分享

The COMPRESSION parameter compression ratio of Oracle 11g version EXPDP is comparable to that of "gzip-9".

This compression ratio is comparable to that of the operating system "gzip-9" and may be more efficient than gzip in some special cases. Experience it for reference. Description of the COMPRESSION parameter secooler in the expdp help page in 1.Oracle 11g

2022-06-02 Servers 我要分享

[EXPDP] the COMPRESSION parameter compression ratio of 11g version EXPDP is comparable to that of "gzip-9"

This compression ratio is comparable to that of the operating system "gzip-9" and may be more efficient than gzip in some special cases. Experience it for reference. Description of the COMPRESSION parameter secooler in the expdp help page in 1.Oracle 11g

2022-06-02 Servers 我要分享

[EXPDP] estimated size when backing up data using EXPDP-- ESTIMATE parameter

When using EXPDP to complete the data export, you can use the ESTIMATE parameter to evaluate the size of the database object to be exported, which is briefly demonstrated for reference. 1. View help information about ESTIMATE parameters 1) View command line help information ora10g@secDB

2022-06-02 Servers 我要分享

Command iperf3 command to use the

Install: [root@bogon ~] # rpm-ivh iperf3-3.1.3-1.fc24.x86_64.rpm Preparing... # # #

2022-06-03 Internet Technology 我要分享

Restore part of the table on the slave slave computer

The following example demonstrates reinitializing individual tables on slave, such as test01 and test02.1, stopping slave replication and clicking (here) to collapse or open mysql > stop slave;Query OK, 0 rows affect

2022-06-01 Database 我要分享

How to improve backup efficiency by using PARALLEL and FILESIZE parameters in EXPDP

EXPDP how to use PARALLEL and FILESIZE parameters to improve backup efficiency, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something. EX

2022-06-01 Servers 我要分享

Iperf network detection tool

First, introduce that Iperf is a network performance testing tool. Iperf can test the bandwidth quality of TCP and UDP. Iperf can measure the maximum TCP bandwidth and has a variety of parameters and UDP characteristics. Iperf can report bandwidth, delay jitter and packet loss. Using Ip

2022-06-01 Network Security 我要分享

5. MySQL function

Function representation returns a value with a specific relationship to the value of the input parameter MySQL provides a large number of rich functions that will be often used in database management and data query and operation. Through the data processing database function can become more powerful and more flexible to meet different needs. Each

2022-06-01 Database 我要分享

How to use C language to realize timer

This article focuses on "how to use C language to achieve timer", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to use C language to implement timer". The idea of realization is a brief introduction to my idea of implementation: Ben

2022-06-02 Development 我要分享

The iperf3 command uses the

The iperf3 command installs iperf3 using 1m iperf3 download: https://iperf.fr/iperf-download.php#fedora[root@localhost home] # rpm-I

2022-06-03 Internet Technology 我要分享

Mysql No backup recovery creates independent tablespaces

This article focuses on "mysql no backup recovery to create independent tablespaces", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor to take you to learn "mysql no backup recovery to create independent tablespaces"! Click to create a recovery library (

2022-05-31 Database 我要分享

The use of SQL_MODE in MySQL

This article will explain in detail about the use of SQL_MODE in MySQL. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article. SQL_MODE is a system variable in MySQL (varia

2022-06-01 Database 我要分享

MySQL locks in RC and RR modes

InnoDB locking mechanism: the database is used to support better concurrency and provide data integrity and consistency. InnoDB is a storage engine that supports locks. The types of locks are: shared lock (S), exclusive lock (X), intended shared lock (IS), intentional exclusive lock (IX). For

2022-06-01 Database 我要分享

Experiments related to mariadb transaction isolation level

The SQL standard for isolation levels for SQL defines four types of isolation levels, as follows: 1. Read Uncommitted (read uncommitted) at this isolation level, all transactions can see the execution results of other uncommitted transactions. This isolation level is rarely used in practice.

2022-06-01 Database 我要分享

Simple exercise of MySQL-5.5 operation command

This article mainly gives you a brief introduction to the simple practice of MySQL-5.5 operation commands. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article can give you a simple practice of MySQL-5.5 operation commands.

2022-06-01 Database 我要分享

How to use the TRANSFORM option to remove tablespaces and storage clauses

This article is about how to use the TRANSFORM option to remove tablespaces and storage clauses. I think it is very practical, so I share it with you. I hope you can get something after reading this article. Let's take a look at it. Use IMPDP

2022-06-01 Servers 我要分享

What are the three commonly used functions in mysql

The following mainly brings you what three types of functions commonly used in mysql, I hope these contents can bring you practical use, which is also the main purpose of this article that I edit mysql which commonly used three types of functions. All right, don't talk too much nonsense, let's just read the following. First, string class. Note: my

2022-06-01 Database 我要分享

MyCat sub-database sub-table-actual combat 07 muri-by date and day

Project environment: 192.168.8.30 mycat192.168.8.31 node1192.168.8.32 node2192.168.8.33 node3 three nodes MySQL are all single instance 1. Create test library no

2022-06-01 Database 我要分享

How to realize the bandwidth Test of Gigabit Network Card under CentOS

This article introduces the relevant knowledge of "how to realize the bandwidth test of gigabit network card under CentOS". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

2022-06-01 Servers 我要分享