MySQL

View Current Library: Select database ();Switch directories: Use DB1; View:1. View library: show databases;2. View table: Show tables; View all tables (files) below the current libraryShow CREATE TABLE T12; Specify to view description information

Show Binlog events;View only the contents of the first Binlog file:Mysql> Show Binlog events;+------------------+-----+-------------+------------+-------------+----------------- ------------------------------------------------------------------------

First, optimize the classificationSecond, sample test dataRefer to MySQL's official Sakina database.Third, use the MySQL slow query log to monitor the efficiency problem of SQLThe first one, turn on the slow query log. The second, slow query log

First, Nginx1. Installing NginxYum Install Nginx2. Start NginxSystemctl start NginxIn addition to Systemctl start Nginx, commonly used related commands are systemctl stop nginx, systemctl restart Nginx, systemctl status Nginx3. Test if Nginx is

Split color platform to build sub-LibraryEnterprise: 217 1793 408[email protected] scripts]# cat backup_database.sh#!/bin/bashMysql_user=rootmysql_pass=123456Mkdir-p/backupfor n in mysql -u$mysql_user -p$mysql_pass -e ‘show databases;‘

1, Mysqlrplsync tools.A tool used to check the data consistency of master-slave replication.Mysqlrplsync --Master=Check:pass@192.168.152.157:3310 --slaves=check:pass@192.168.152.159:3311,check:pass@192.168.152.160:3312 2,

To modify the MySQL database password via the MySQL command line, here is a detailed description of how to use the MySQL command line to modify the password.Format: Mysqladmin-u username-P Old password password new password1. Add a password to root

MySQL Storage Engine MyISAM and InnoDB configuration MyISAM and InnoDB Maximum features: MyISAM: ① does not support transactions. ② table-level locking, where data locks the entire table when it is updated. ③ does not support foreign key

17.1 MySQL Master-slave introductionMaster is the Lord, Slave is from.Main application scenarios: Backup, Backup + "from" machine can also read, (reduce the pressure of the main)17.2 preparatory workTwo machines are required to install the MySQL

ObjectiveAs a background development, it is necessary to benchmark the database to master the performance of the database. This article describes the basic concepts of MySQL benchmarking and the detailed methods for benchmarking MySQL using Sysbench.

2.1 Modify Permissions 命令： GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘192.168.175.1‘ IDENTIFIED BY ‘love‘ WITH GRANT OPTION; FLUSH PRIVILEGES; 含义： 让IP为192.168.175.1的用户，可以使用用户名root和密码love来访问数据库。 如果把192.168

Database: A collection of data stored in an organized wayTables table: A structured list of data of a particular typeSchema schema: Information about the layout and characteristics of databases and tablesColumn columns: A field in a tableData type

recently looking at MySQL5.7 Manual, about semisynchronous replication this piece of content, we know that MySQL default replication is asynchronous, what is asynchronous? What is semi-synchronous? Don't say much nonsense, just look at the official

Storage Engine Introduction MySQL Storage engine MyISAM read and write faster, does not support things where the MyISAM storage engine is a piece of MySQL data before the system. Default storage engine prior to version

MySQL Storage engine Storage Engine IntroductionData in MySQL is stored in files (or memory) in a variety of different technologies. These different technologies and associated functions are called storage engines in MySQL.MySQL offers a number of

1. Description:The first is to prepare two servers, one master server (master), the other from the server (Slave), and then to ensure that the master and Slave version of the same and master can not be higher than Slave version, it is generally

Set up a MySQL server to answer ports and bind IP addresses The MySQL server listens to port 3306 By default and determines the firewall to open this port. Edit/ETC/MY.CNF Add the binding IP address.bind-address=192.168.42.

DELIMITER//(set Terminator I don't really understand why I have to remember that.)CREATE FUNCTIONym_date (mydate date) (Create function function name (parameter))RETURNS VARCHAR( -) (Specifies the return type of the function)BEGIN(function starts,

"Ultra-simple" MySQL storage engine selection and Configuration Storage engine IntroductionData in MySQL is stored in files (or memory) in a variety of different technologies. Each technology uses different storage mechanisms, indexing techniques,

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to