MySQL

Isolation properties of InnoDB InnoDB's transaction supports 4 isolation mechanisms, namely READ UNCOMMITTED, read COMMITTED, Repeatable read, and SERIALIZABLE. The default is repeatable READ. The following is a detailed analysis of the 4 types of

Create test dataFully-prepared databasemysqldump --single-transaction --flush-logs --master-data=2 --all-databases --triggers --routines --events --set-gtid-purged=off> backup.sqlAdditional test dataDelete all data in a tableConfirm binary Log save

1, need Mysql-linux installation packageThis time use mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz to install2. Upload this installation package to a Linux serverThe upload path is:/usr/local3. Unzip MySQLinput command:tar zxvf mysql-5.7.17-linux-glibc2

The database uses locks to support better concurrency, providing data integrity and consistency. InnoDB is a storage engine that supports row locks with the following types: Shared Lock (S), exclusive lock (X), Intent Share (IS), intent Exclusive

Part of the content is transferred from: https://www.cnblogs.com/wupeiqi/articles/5713323.html★ View1, somewhat similar to the temporary table from the individual name, and then saved in the database, the next time can be accessed directly through

1.MOF right to liftSimply put, MOF is a program within the system, and every time the system is executed with root authority, we replace it and execute our attack code. This is referred to as the MOF right.Here's the script:1#pragmanamespace("\\\\.\\

After installing Mysql-server, you will be prompted to run mysql_secure_installation. Running Mysql_secure_installation will perform several settings:A) set a password for the root userb) Delete Anonymous accountc) Remove the root user from remote

#!/bin/bash#system:centos7#mysql.tar.gz is glibc#download URL https://dev.mysql.com/downloads/mysql/#Example Download #https://cdn.mysql.com//downloads/mysql-5.6/mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz#sh mysql_ install.sh

Green version of MySQL. After the system is reinstalled, start MySQL. Blog type: MySQL Green version of MySQL. After the system is reinstalled, start MySQL. 1. Install the MySQL ServiceEnter the directory F: \ MS-DOS \ bin

Recently, when I was tuning MySQL, I felt that the query cache of MySQL was not as big as possible, Because the cache actually fails when the data table changes as follows: Including insert, update, delete, truncate, alter table, drop table,

Summary of Permissions 1. Create an accountGrant all privileges on *. * To Z1 @ localhost;*. * Indicates that you have permissions on all the local databases and tables. You can change the permission to on test. user, and you have permissions on

1. If your data executes a large number of insert or update operations, InnoDB tables should be used for performance considerations.If you execute a large number of select statements, MyISAM is a better choice. 2. I need to use transaction

(Linux parameters) Open the/etc/My. CNF file and modify the following settings. If not, add it manually. When adjusting the settings, please do your best, which depends on the configuration of your server, especially the memory size. The following

1. Full table Scan If you want to find a highly selective record, you can use an index. However, if you find a large amount of data, such as more than 20%, The optimizer does not use indexes, but scans the entire table. 2. Sequential read: it

Let's take a look at the concept of MySQL asynchronous replication: Asynchronous replication: MySQL supports one-way and asynchronous replication. Asynchronous replication means that there is a latency when copying data from one machine to

Introduction: InnoDB provides MySQL with a transaction security (acid-compatible) storage engine with the capabilities of commit, rollback, and crash recovery. InnoDB locks row-level and also provides an oracle-style non-locked read in the SELECT

Build a Linux + aphche + Java + MySQL Environment 1. Download JDKJdk-7u17-linux-i586.gz2. Install JDKInstallation Directory:/usr/Java/jdk1_7 3. Configure the environmentGedit/root/. bash_profile--------------------------------------------------------

I recently used a VC to connect to MySQL on the web. I found a lot of information on the Internet, which is not very detailed.So today, I will write down how I connect to MySQL step by step and write statements.First, we hope to help our friends who

Use the so-called next-key locking in the InnoDB row lock. This means that in addition to index records, InnoDB can also lock the front "gap" (& apos; Gap & apos;) of the index records ;) to block the direct insertion of other users in front of the

Fenng of DBA notes has published an article about choosing a more suitable hardware for MySQL. I picked it and commented on it based on my usage habits. in the following section, the red font is my words. --------------------------------------------