PHP

From MySQL5.6, a new parameter innodb_page_size can be set to 8 K and 4 K for Innodb data pages. The default value is 16 K. This parameter must be added to my. cnf at the beginning of initialization. If a table has been created, modify it, From

MySQL master-slave Architecture and Data replication based on ssl I: Mysql master-slave architecture topology diagram: II: MySQL master-slave architecture knowledge point in MySQL master-slave architecture, there are three key threads: dumpthread:

MYSQL database automatic local remote dual-Backup MYSQL Incremental Backup [Build millions of access to e-commerce websites] Source: jimmyli.blog.51cto.com I stood on the shoulders of giants JimmyLi Author: JimmyLi MYSQL database automatic

Redundancy and duplicate index redundancy and duplicate index concept: MySQL allows you to create multiple indexes on the same column, whether there is .. Redundancy and duplicate index redundancy and duplicate index concept: MySQL allows you to

I would like to explain the importance of manual experiments. Sometimes a person may have a lot of ideas, or you may have an idea when you see others' articles, or, if you want to verify others' opinions, you need to manually perform experiments to

Is it true that Select * does not go through the index? The index indicates that the execution plan of the SQL statement uses 1. Clustered index search 2. index search, And the where clause must be included in the query statement based on the filter

It is best to use row_number for sorting. It ranks in sequence and does not show the same rank, for example, 1, 2, 3, 4, or 5 rank, and skips the same rank number to the next, for example: 1, 1, 3, 4, 5, dense_rank appear in the same ranking, do not

In the materialized view test manual, the view is an SQL statement that requires two-way data synchronization when data changes are small and data needs to be used twice, the execution plan must be re-generated and re-executed for each query. In the

Whether intentionally or unintentionally, if the transaction remains open in the database, it will block other processes from performing operations on the modified data. Similarly, backing up transaction logs will only truncate the transaction logs

Preface complex data statistics are often executed in practical applications and data from multiple tables needs to be displayed. Therefore, we must pay great attention to the complex select statement! 1-important functions of Data grouping: max,

Today, I will introduce this tool. This experiment is based on this article: The test content in this article is SQLserv. How can I use procmon.exe to monitor SQLSERVER's logwrite size? Today I will also introduce this tool. This experiment is

[MySQLbinlog] thoroughly parses the binary log in the Mixed log format [MySQL binlog] thoroughly parses the binlog in the Mixed log format Mysql binlog3 formats, row, mixed, statement. Parsing Mysqlbinlog -- base64-output = DECODE-ROWS-v

Environment: AIX5.3 + 10.2.0.5RAC situation description: When RAC is restarted after it is disabled, one node cannot be started, and the other node can start troubleshooting normally: 1. Try to start c of Node 1 Environment: AIX5.3 + 10.2.0.5 RAC

DataGuard environment: Operating System: RedHat5.6Primary Database: IP Address: 192.168.48.131 database SID: orclDB_UNIQUE_NAME: orcl_pdStandb Data Guard environment: Operating System: RedHat 5.6 Primary database: IP Address: 192.168.48.131 database

Error message: ORA-20211: Activejobrecordexists, cannotcreatenewjobrecord when this error occurs, it is difficult to find a reasonable solution online Error message: ORA-20211: Active job record exists, cannot create new job record when this error

Several reasons why Oracle Database shutdownimmediate is hang Several reasons why Oracle Database shutdown immediate is hang Lab environment: Operating System: Red Hat Enterprise Linux ES release 4 (Nahant Update 6) Database: Oracle Database

Problems and Solutions for installing Oracle11g in CentOS6.4 Problems and Solutions for installing Oracle 11g in CentOS 6.4 1. OUI-10182 The valid tive user ID does not match the owner of the file .......... Solution: Use the root account to

Returns the character functions 1, CHR (n) [n is a positive integer. If ngt; 256, MOD (n, 256)] selectCHR (65) a1, CHR (67) | CHR (65) | CHR (84) a2FR Returns the character functions 1, CHR (n) [n is a positive integer. If ngt; 256, MOD (n, 256)]

Error in installing oracle10gr2clusterware in rhel5.8 Rhel 5.8 installation of oracle 10g r2 clusterware Error This error is different from most of the answers on the Internet. The error is not a 32-bit rpm package. If it is a previous error,

First, let's look at Example 1: selectltrim ( First, let's look at Example 1: select ltrim ( First look at the example Example 1: select ltrim ('caolingxiong ', 'cao') from dual; ------ The returned result is ---------- Lingxiong This