MySQL5.7.11 mysqlpump multithreaded logical backup tool

On March 14, 2016, in order to experience the new experience brought by version 5.7.11, I can't wait to test the new features and features. What I've been thinking about these days is the 5.7.11 fixed version of mysqlpump. Before MySQL 5.7.11

2022-06-01 Database 我要分享

Index defragmentation-rebuild index, merge index, shrink index

Indexes can also be fragmented over time, and oracle provides us with three ways to deal with this problem: rebuild the index, merge the index, and shrink the index. Each has its own characteristics. I'll learn to take notes here today. First: rebuild the index:

2022-06-01 Database 我要分享

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 我要分享

Analysis of New characteristics of PostgreSQL

This article mainly introduces "Analysis of New characteristics of PostgreSQL". In daily operation, I believe many people have doubts about the analysis of new features of PostgreSQL. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods, hoping to answer "Postgre" to everyone.

2022-05-31 Database 我要分享

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 我要分享

Analyze the pgAdmin situation of PostgreSQL DBA

This article introduces the relevant knowledge of "analyzing the pgAdmin situation of PostgreSQL DBA". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you will read it carefully.

2022-05-31 Database 我要分享

What are the effects of different data types on query performance in PostgreSQL

This article focuses on "what is the impact of different data types on query performance in PostgreSQL". 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 the different data types in PostgreSQL.

2022-05-31 Database 我要分享

Check all partioned tables & Indexes

SQL > set linesize 150set pagesize 10000column table_name format a30column tablespace_name format A20

2022-06-01 Database 我要分享

How to expand and contract using DataGridView

This article introduces you how to use DataGridView to expand and contract, the content is very detailed, interested friends can refer to, hope to be helpful to you. A lot of data has a parent node and a child node. We want to expand the children under the parent node when we click the parent node.

2022-06-02 Development 我要分享

A test on the long_query_time parameter

Create a test table with the following statement: mysql > show create table test1;+-+-

2022-06-01 Database 我要分享

How to use Gridview controls to design forms in the development of .net language Smobiler

This article mainly introduces how to use Gridview controls to design forms in the development of .net language Smobiler. It is very detailed and has certain reference value. Friends who are interested must finish reading it. The first words: Smobiler is a VS environment

2022-06-03 Development 我要分享

An example Analysis of the return value of the number of mysqli_affected_rows Action rows in PHP

This article mainly introduces "the case analysis of the return value of the number of mysqli_affected_rows action lines in PHP". In the daily operation, it is believed that many people save the case analysis of the return value of mysqli_affected_rows action lines in PHP.

2022-06-03 Development 我要分享

The function of calculating the number of rows affected by sql statements in mysql

It is often possible to use LIMIT to limit the number of rows returned in a SELECT statement. Sometimes you may want to know how many rows would be returned without LIMIT, but you don't want to execute the same statement again. Then, include the SQL_CALC_FOUND_ROWS selection in the SELECT query

2022-06-01 Database 我要分享

Oracle optimization-table optimization (temporary table)

First, create temporary tables and regular tables SQL > CREATE GLOBAL TEMPORARY TABLE TMP_TEST ON COMMIT PRESERVE ROWS AS SELECT * FROM emp

2022-06-01 Database 我要分享

How to calculate rows in MySQL explain

This article mainly explains "how to calculate rows in MySQL explain". The content of the explanation in this article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn ro in MySQL explain.

2022-06-02 Internet Technology 我要分享

Sqluldr2 usage

Corresponding to 32, 64-bit win and Linux platform installation step 1. Need to install oracle_client2. Copy sqluldr2_linux32_10204.bin (sqluldr2_linux64_ for 64-bit systems

2022-06-01 Database 我要分享

How to realize batch picture stitching on C++

This article mainly introduces C++ how to achieve batch picture stitching related knowledge, the content is detailed and easy to understand, simple and fast operation, has a certain reference value, I believe that after reading this C++ article on how to achieve batch picture stitching will have something to gain, let's take a look. The specific code is as follows /

2022-05-31 Internet Technology 我要分享

Improvement of cost calculation of PostgreSQL JOIN limit Optimizer-mergejoin startup cost Optimization

Background the cost estimation of PostgreSQL limit N is obtained by calculating the total cost An and the estimated total number of records B: (Nbig B) * A roughly means percentage calculation, which is usually suitable for single-table queries, but if the number

2022-06-01 Database 我要分享

MyCat sub-database sub-table-actual combat 09 muri-by single month hour

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 implement a Minesweeper Program in C language

This article introduces the relevant knowledge of "how to implement a minesweeping program in C language". 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! The whole game design

2022-06-01 Development 我要分享