read lock

Two CentOS7 system virtual hosts:are: master server 172.16.75.1, 172.16.75.2 from serverUsing the mariadb-5.5.56, which is the software version that comes with CentOSTo make the experimental results accurate, shut down the firewall and SELinux for

1,Database backup TypesAccording to the database size backup, there are four types, respectively applied to different occasions, the following brief introduction:1.1Full BackupThis is the way most people use it to back up the entire database,

This paper mainly discussesmysqldumpThe main ways of working, and compare andMk-parralel-dumpSome of the differences that provide more help for the choice of backup methods. First of all, look at the mysqldump of the main parameters of the actual

See also: http://www.2cto.com/database/201501/370191.htmlBasic informationSpock:primary>db.serverstatus (){"Host": "h6.corp.yongche.org",//Host name"Version": "2.6.2",//mongodb version"Process": "Mongod",//mongodb process, mainly Mongod and MONGOs

Oracle multi-user concurrent access transaction: an inseparable operation lock acting on some data: Write lock, mutex lock (can only be used by one process) read lock, shared lock (can be Oracle multi-user concurrent access transaction: an

Yang Tao briefly summarized the MySQL lock table mechanism in his blog, listing the possibility of various MySQL lock tables. 1. for MySQL, there are three lock levels: Page-level, table-level, and RoW-level. A typical page-level engine is BDB.A

I have made up my mind to start learning oracle. I have been using mysql for a short time. today I will write down these statements to explain my journey to mysql. the following is my personal experience in using mysql. There may be many mistakes

Environment:The MySQL database version on the master and slave servers is 5.1.34.Host IP: 192.168.0.1Slave IP Address: 192.168.0.21. MySQL master server configuration1. Edit the configuration file/etc/my. cnf# Make sure it is as downstreamServer-id =

Mysql lock table problem show processlist check the database table status and whether it is locked; kill id // kill the table to be locked ================================ ============================== set autocommit = 0; select * from t1 where uid

  Compared with small sites, database administrators of large sites must do the following in advance:   Provides a recovery plan for core business data in the event of a disaster. Theoretically, this process must be executed at least once. Provides

In MySQL, table locks are not deadlocked when table-level locking is used for storage engines. This means that all necessary locks are requested immediately at the beginning of a query and the tables are always locked in the same order. In a table

MySQL 5.1 supports table-level locking for MyISAM and MEMORY tables, page-level locking for BDB tables, and row-level locking for InnoDB tables. In many cases, you can guess the type of lock the application uses based on the training, but it is

Multi-thread Analysis of JAVA-Linux general technology-Linux programming and kernel information. The following is a detailed description. · I. Source and characteristics of the JAVA language In this era of high-speed information, merchants have made

Mysql metadata lock (3), mysqlmetadatalock Preface The MDL lock is mainly used to protect the metadata of Mysql internal objects. The MDL mechanism ensures the concurrency of DDL, DML, and SELECT query operations. MySQL Meta Lock (1) and MySQL Meta

MySQL databaseIs a small relational database management system, MySQL databaseOptimizationIt is a very important task in the MySQL database operation process. MySQL database optimization can simplify MySQL database operations. Step 1: 1: high-speed

Back up a mysql database using lvm-snapshot Prerequisites: Transaction logs and data files must be on the same volume; Before creating a snapshot volume, you must request the Global lock of MySQL. After the snapshot is created, manually release the

This article is mainly to share with you the PHP file lock concurrency operation, the default: PHP file operation function, not blocking state, but free operation State, hope to help everyone. Conditions: A file lock is required when a script

Mysql table optimization: 1. Analysis Table 2. Check Table 3. Optimization Table 4. table data import 5. lock table operation 1. Analysis Table 11. Command: ANALYZE [NO_WRITE_TO_BIN Mysql table optimization Brief: I. Analysis Table II. Checklist III.

MySQL replication (1) --- what is binary log bitsCN.com? Compared with small sites, database administrators of large sites must do the following in advance: Provides a recovery plan for core business data in the event of a disaster.

Install and configure Mysql master/slave bitsCN.com Environment:The MySQL database version on the master and slave servers is 5.1.34.Host IP: 192.168.0.1Slave IP address: 192.168.0.21. MySQL master server configuration1. edit the configuration