MySQL

MHA is the most efficient use of MySQL database Enterprise choice, it is simple and powerful, the implementation of the MySQL replication architecture based automatic master-slave failover, this article mainly uses the original text to describe the

Transferred from: http://chenling1018.blog.163.com/blog/static/14802542010320112355598/The MySQL permissions system revolves around two concepts:Authentication, determining whether a user is allowed to connect to a database serverAuthorization,

1. Install Xcode command line toolsFirst, compiling MySQL and homebrew requires the use of Xcode command line tools, so first install command line tools;If you have Xcode installed, just "Preferences ... > Downloads", then click the command line

Original: http://www.drupal001.com/2014/02/percona-xtrabackup-mysql/Xtrabackup IntroductionPercona Xtrabackup is open source free MySQL database hot backup software, it can be InnoDB and XTRADB storage Engine database non-blocking backup (for MyISAM

Include header file#include #ifdef _debug#pragma comment ( LIB, "Mysqlcppconn.lib")#else#pragma comment (lib, "Mysqlcppconn-static.lib")// My MySQL connector/c++ is self-compiled under the source code, need to introduce this, the official

MySQL's website: http://www.mysql.com/downloads/There will be several versions of the selection in this download screen.1. MySQL Community Server Community version, open source is free, but does not provide official technical support.2. MySQL

Wait problems caused by--mysql flush-------------------------------2014/07/13PrefaceIn the actual production environment, a large number of SQL statements are sometimes found to be in waiting for table. State, sometimes it may seem confusing, this

If all the updates are updated, refer to the following Article , MySQL database versions are updated quickly, and new features are constantly updated. What's more, it solves many bugs that affect our applications. In order to make our MySQL better,

The reason for writing this article is that mysql5.6.2 suddenly launched the memcached function. The emergence of nosql to InnoDB with memcached shows that nosql has indeed had a huge impact on relational databases. I personally think this is a huge

As a system O & M engineer, I think it is a daily task to view and analyze LINUX system logs. However, after a long time, I find that every time I view the site logs, I have to go to the background one by one, several servers can do this, but if you

MySQL is case sensitive. mysql is case sensitive.Frequently encountered problems are not particularly important but depressing. For example, MySQL is case sensitive today. First, test the result. In Linux, not on windows. There is a big difference.

In MySQL, innobackupex and xtrabackup are used for big data backup and restoration. innobackupex Backup and restoration of large data volumes is always a challenge. When MYSQL exceeds 10 Gb, it is slow to export data using mysqldump. Xtrabackup is

The reason for writing this article is that MySQL5.6.2 suddenly launched the memcached function. The emergence of NoSQL to InnoDB with Memcached shows that NoSQL has indeed had a huge impact on relational databases. I personally think this is a huge

Summary of MySQL mathematical functions, mysql mathematical functions 1. ABS (x): returns the absolute value of x.Copy codeThe Code is as follows:Mysql> select ABS (1), ABS (-1), ABS (0 );+ -------- + --------- + -------- +| ABS (1) | ABS (-1) | ABS

We know that the general SQL query statement is written as follows: Copy codeThe Code is as follows: select col from table; Of course this is okay, but what if the field name is "from? Copy codeThe Code is as follows: select from table; If this

I. Principles of Replication MySQL replication tracks all database changes (updates, deletions, and so on) in binary logs based on the master server ). Each slave server receives updates recorded by the master server to the storage of its binary

Author: skateTime: 2012/02/17 Mysql SQL Performance Analyzer The SQL Performance Analyzer of MySQL is mainly used to display the usage of various resources during SQL Execution. Analyzer can better displayPoor SQL Performance problems. How to use

Xtrabackup full backup solution, full Backup Recovery record [html] mysql> use inno Database changed mysql> insert into mm select 1; Query OK, 1 row affected (0.01 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> insert into mm select 2; Query OK, 1

Mysql tuning three steps (slow query and explain profile) often encounter some SQL problems in performance tests. In fact, the most problems encountered in performance tests over the past few years are databases, either high I/O or high cpu, Data

In mysql, there are many methods for adding users other than root users. The simplest way for us to understand commands is to directly operate on the GUI, for example, phpmyadmin database management tool. If you know the command, you can directly