MySQL

MySQL database backup and recovery background:As an operations engineer, often encounter hardware failure (redundancy), software failure (bug), natural disaster, hacker attacks, misuse of the database to destroy the problem, so be sure to do a good

Single-Table query optimization: (about the index, after the opening of a single chapter explained)(0) You can use the EXPLAIN keyword first to let you know how MySQL handles your SQL statements. This can help us to analyze the performance

Source: Http://chaoqun.17348.com/2008/08/memcached_work_with_mysqlThis is the experience of Fotolog, the legend of the larger site than Flickr, Fotolog on 21 servers deployed 51 memcached instances, a total of 254G cache space available, cache up to

MySQL stored procedure is very verbose, compared to MSSQL or Oracle stored procedures, if not explicitly specified, he implicitly specifies a series of attributes (characteristic) default values to create a stored procedureTypically, when you use

MySQL cluster tutorial (ii)Build in MySQL Linux environmentA: Download: wget https://cdn.mysql.com/Downloads/MySQL-5.7/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gzB: Pre-installation Environment check:1, check whether Linux installed MARIADB database,

Reference articleshttp://sofar.blog.51cto.com/353572/1601552/Http://www.0550go.com/database/mysql/mysql-atlas.html360 Open source Atlas is excellent, both in terms of performance and stability, compared to other open source components (amoeba, Cobar,

1. Create/Delete Database Create/DROP DATABASE DATABASENAME;2, creating a data Table CREATE TABLE table_name (COL_NAME1, Col_type [ notNULL],#Null is not allowed, the default can be null if not written, [] represents writable and writableCol_name2,

Original: http://blog.csdn.net/woslx/article/details/49685111The UTF-8 encoding may be 2 bytes, 3 bytes, 4 bytes of characters, but the UTF8 encoding of MySQL only supports 3 bytes of data, and the expression data on the mobile side is a 4-byte

Naming rules: Table name _ Field name1. Fields that need to be indexed, in the Where condition2. Fields with low data need not be indexed3, if the Where condition is an OR relationship, index does not work4, accord with the left

In the process of using MySQL, we often need to authorize the user (add, modify, delete), in MySQL there are three ways to implement the method of INSERT user table, CREATE user method, Grant method. Let's take a look at how the grant method is

Recently listened to Bosenry teacher's MySQL optimization Open class, this is my notes.Now let's talk about the two features of MySQL memory and I/O.First, MySQL Memory Features:1. There is also global memory and memory per session (each session is

MySQL database installation defaults to local access only, if you need remote connection to do something according to different operating systemWindows:The newly installed MySQL cannot log on locally and is displayed as a 1045 errormysql#1045

First, the ViewA view is a virtual table (not a real one), which is essentially "getting a dynamic dataset from an SQL statement and naming it", which you can use as a table by simply using "name" to get a result set. Using views we can take out the

"Database MySQL"Role:Save dataSuch as:1. Your open room record2. Bank card information3. Identity card InformationDatabase includes1. Library2. Table3. Fields4, Data line"Relational database and non-relational database"Interview questions often test

1, the first Data training Xltrabackup backup, be prepared, remember to remember!2.Mysql-uroot-pd********--export CSV file use dsideal_db; MariaDB [dsideal_db]> SELECT * fromT_resource_info into OUTFILE"/usr/local/mysql/t_resource_info.txt"Fields

The main contents of this article are as follows:1. syntax structure of functions2. Examples of functions2.1. the simplest function2.2. example of returning query results3. the difference between a function and a stored procedure3.1. differences

The MVCC of InnoDB is achieved by saving three hidden columns after each row of records, one of the two columns that saved the creation time of the row, the expiration time (or deletion time) of a saved row. Of course, it is not the actual time

This article mainly introduces the method of MySQL to modify time zone, summarizes and analyzes three common MySQL time zone modification techniques, including command line mode, configuration file mode and code mode, the need for friends can refer

Optimization tips for slow subquery efficiency of mysql in statements, mysql examples The table structure is as follows. There are only 690 articles. Article table article (id, title, content) label table tag (tid, tag_name) label intermediate table

MySQL or statement usage example, mysqlor statement example 1. Usage of or syntax in mysql. Note the usage of or in mysql syntax. An error occurred while querying the reward data !!! $sql = 'SELECT * FROM