MySQL

MySQL master-slave Switch manualMaster-slave ArchitectureOperation and Maintenance DepartmentV1.0 . Year May 24Normal switching Check slave synchronization Status 1) in master execution: show Processlist;Show Master have sent all

1.1.1 PhenomenonWhen exporting a MySQL database to a file, the following error occurs when importing:ERROR 1235 (42000) at line 267:this version of MySQL doesn ' t yet support ' multiple triggers with the same action time and Event for one table '1.1

1,my.cnfInvalid user name password inAbove the azure cloud, using Zabbix monitoring MySQL, found in/usr/local/mysql/my.cnf set the default user name password is invalid, out of data, and on the Zabbix server, using Zabbix_get also error failed, As

One installation method MySQL installation files are divided into two types, one in MSI format and one in ZIP format. Here's a look at both of these ways:MSI format can be directly clicked to install, follow it Install the installation instructions

NT (M) let's first split, int is representing integer data so the middle of the M should represent how many bits, and later the MySQL handbook also learned that my understanding is correct, I would like to illustrate.The integer types in the MySQL

All of the following steps are done using the command line to complete the operation of the MySQL service. one start/close MySQL (1) Start MySQL service net start MySQL (2) Stop MySQL service net stop MySQL Two log in/out of MySQL First, let's take

1. Replication overview1.1. Replication-Resolved issuesData replication technology has some of the following features:(1) Data distribution(2) Load balancing (load Balancing)(3) Backup(4) High availability (Hi availability) and fault tolerance1.2.

In order to learn the database, I went online to download the latest version of the WINDOWS64-bit MySQL 5.7.11, but spent a long time on the installation of the problem, but also borrowed a few predecessors to help themselves to solve the problem

When using SQL, most of the time, when you update a record, you need to retrieve its value or condition through Select, and then perform the modification by this value.However, the problem occurs when the above operations are placed concurrently in

MySQL cannot log on after creating a new user, prompting Access denied for user ' username ' @ ' localhost ' (using password:yes), mostly because of the presence of anonymous users, To resolve this problem, simply delete the anonymous user in the

Git Project address:Https://github.com/akopytov/sysbenchWith Sysbench it's easy to do performance benchmarks for MySQL (which is, of course, a powerful tool, in addition to testing the main database performance, testing other aspects, details of

From: The asynchronous implementation of MySQL query via the co-processObjectiveRecently studied Ben Linders's speech and learned that Facebook's MySQL query can be asynchronous to improve performance. Because Facebook was implemented earlier, they

There are many ways to delete data in MySQL, the most common is to use Delete to delete the records, let me introduce the delete delete a single record and delete the multi-table associated data of some simple instances.1. Delete from T1 where

CentOS 6.5 System installation Configuration lamp (APACHE+PHP5+MYSQL) Server environmentPrepare the article:1, configure the firewall, open 80 ports, 3306 portsVi/etc/sysconfig/iptables-A input-m state--state new-m tcp-p TCP--dport 80-j ACCEPT

1, Environment: two CentOS computer direct connection, its server A's IP address is 192.168.1.124, Server B's IP address is 192.168.1.121.2. Requirement Software Installation (SSH system is installed by default):Server A:Yum Install rsync

MySQL's "slow query" refers to an SQL statement that exceeds the maximum allowable query time ( long_query_time ), and the "unused index" query, by definition, is the SQL statement that the query statement does not use to the index.Slow query

Ext.: http://blog.fens.me/nodejs-mysql-intro/ObjectiveMySQL is a popular open source database product and is often the first choice for a free database. Checking the NPM list and discovering that Nodejs has 13 libraries to access

Percona utility-Introduction to pt-kill, perconapt-kill Pt-kill is an excellent tool for kill MySQL connection and is part of percona toolkit, when the maximum number of connections is exceeded due to a large number of idle connections and a

MySQL monitoring tool-Innotop, mysql tool-innotop Innotop is a powerful MySQL monitoring tool. It uses perl to show the running status of MysQL servers and Innodb in text mode.   Install innotop : Https://github.com/innotop/innotop Github provides

Analysis of mysql interactive connection and non-interactive connection; analysis of mysql interactive connection Interactive operations: in layman's terms, you open the mysql client on your local machine, that is, the black window, and perform