MySQL

System RequirementsMonitored host and MySQL monitoring account, Zabbix Agent 2.0 or more (preferably the same as the Zabbix-server version), PHP, Php-mysql (PHP version is not limited, tested 5.3 is possible. The best version is not too low),

Information: Docker version ( $ docker --version ): Docker version 18.03.1-ce, version 9ee9f40 System Information: WINDOWS10 Professional Edition MySQL is mounted in Docker's volume1. The first step: 1 Docker volume create

MyISAM lock Mechanism:MyISAM only table locks, divided into X and S lock two (or called read Lock,write Lock). Read Plus s lock, write plus x lock. Blocking each other, so concurrent DML performance is not good. InnoDB lock Mechanism:Lock

17.1 MySQL master-slave introduction· MySQL master-slave is also called replication, AB replication. Simply speaking is a and b two machines from the back, write the data on a, the other B will follow the writing data, both data real-time

ObjectiveTalking about MySQL query optimization, I believe you have a collection of artifice: You cannot use SELECT *, do not use null fields, reasonably create an index, select the appropriate data type for the field .... Do you really understand

MySQL Trigger if then ElseIf else's useCREATE PROCEDURE DBName.Proc_getgrade(Stu_no varchar(20),Cour_no varchar(10)) BEGINDECLARE Stu_gradeFloat; SelectGradeIntoStu_gradeFromGradewhereStudent_no=Stu_noandCourse_no=Cour_no; IfStu_grade>=90 Then

1. Uninstall MySQLFind native-installed MySQLRpm-qa | Grep-i MySQL--nodeps--forceRpm-ev mysql-server-5.6.15-1.el6.x86_64Rpm-ev--nodeps mysql-libs-5.1.71-1.el6.x86_64 (forced unload)Find previous versions of MySQL directories, and delete old versions

First, update your source:[Plain]View Plain Copy $ sudo apt-get update First Step-Install ApacheApache is an open source software that is currently running on more than 50% servers worldwide and is one of the LAMP

1. Filter the reason for emoji expressionIn our project development, emoji expression is a troublesome thing, even if we can store it, it doesn't have to be perfect, because it's updated fast: On platforms other than iOS, such as PC or Android. If

Original: http://www.techxue.com/techxue-11898-1.htmlToday, the responsiveness of Web applications is one of the keys to success. It interacts with users, users of the site's views, and even the Google site rankings have an inseparable relationship.

Pros: Hot backup, no impact on business, incremental backup, remote backup.Purpose: Automatically package backup to remote 10.0.0.111 backup serverPremise:1. Installing XtrabackupYum Install http://www.percona.com/downloads/percona-release/redhat/0.1

Is you a hacker?How to build another qq/wechat/whatsapp/skype/imessage?Let's go through this!!!!Materials:A Linux/unix/windows/mac Computer/server, and do some basic things!Is you feeling?Okay, let ' s ride the rocket!Get materials:1. A Search

Linux Operation phase IV (VII) MySQL REPLICATION (Master-slave replication, semi-synchronous replication, replication filtering)First, MySQL Replication Related concepts:1, the role of replication: to support the implementation of backup; ha,

Tested under MySQL 5.6.MyISAM Engine:When creating a data table, MySQL generates 3 files, respectively (table: Test):TEST.FRM, Test. MYD, Test. Myi file,TEST.FRM is the table structure, Test.myd is the file that holds the data, Test.myi is the file

Lamp (short for Linux, Apache, MySQL, PHP/perl/Python) is now popular. It is also similar in windows, such as Wamp (Apache, MySQL, PHP on Windows ). This article describes how to manually configure Apache, MySQL, and PHP in a Windows environment.

1. Why back up the database? Backup is the most important and easy to ignore for databases. Unexpected events may cause serious losses. The more important the data is, the more frequently the data changes, and the more frequently backup is

Replace and regexp usage0 Comments | This entry was posted on Apr 08 2010. Mysql replace usage 1. replace Replace into table (id, name) values ('1', 'A'), ('2', 'bb ') This statement inserts two records into the table. If the primary key id is 1 or 2

MySql and MySql WorkBench Install Mysql 1. Download MySQL Community Server 5.6.13 2. decompress the MySQL packageDecompress the downloaded MySQL package to the custom directory. The decompressed directory is:"D: \ Program Files \ MySQL \ mysql-5.6.13

The following articles mainly introduce how to use MySQL built-in functions to convert IP addresses and related numbers. In actual operations, when processing character formats, such as converting 54789, we only need to use: format (12345, 0). The

Differences between null and not null in mysql and efficiency issues Mysql users may encounter the following situations: 1. My field type is not null. Why can I insert null values? 2. Why is not null more efficient than null? 3. When determining