MySQL

MySQL Backup and recovery:1, disaster recovery;2, Audit;3, testing;Backup: The purpose is to restore, and to test the backup data;Backup type:Whether the database server is online depending on the backup:Cold: Cold BackupWin Bei: Warm backupHot

Typically, when using MySQL, you will find a ranking of data based on multiple ranking criteria, with the same conditions.Suppose there are table tables, two criteria fields Conditiona descending sort and conditionb ascending sort, the same

1. EntitiesAll kinds of data management objects, such as database tables, views, stored procedures, etc. , are the database entities in the database management system, which are convenient for data management. Broadly speaking, the data stored in

This period of time to understand the MySQL Shard technology and master-slave copy just tidy up the mind map to draw a record, hoping to give the people who need some helpP.S.: Personal finishing, there may be errors, but also hope that the ~The

A federated index is also called a composite index. For composite indexes: MySQL left-to-right uses fields from the index, and a query can use only one part of the index, but only the leftmost section. For example, the index is key index (A,B,C).

MySQL queries are case insensitive by default, such as:SELECT * FROM table_name where a like ' a% 'SELECT * FROM table_name where a like ' A% 'SELECT * FROM table_name where a like ' a% 'SELECT * FROM table_name where a like ' A% 'The effect is the

Install MySQL from MSSQL Guide data to MySQL: sqlyog with Visual Toolsrefer to: http://www.cnblogs.com/gaizai/p/3237907.htmlMySQL and MSSQL Syntax differences: Difference MSSQL Mysql Comments Single-line

Tag:mysql   python    practice     # -*-coding:utf-8-*-__author__ =  ' Administrator ' Import mysqldbimport pprintimport  sysreload (SYS) sys.setdefaultencoding (' UTF8 ') # help (MYSQLDB) s = mysqldb.connect (host= ' 192.168.2.19 ',   user= '

Test tableTo find out what a user is doing, combine the actionsThe following SQL can be used to achieve the purposeSELECT as Operation from Test GROUP by NAMEThen to find out how many such users, directly after the Select plus the count ()

#!/bin/shDump=/usr/local/mysql/bin/mysqldumpOut_dir=/data01/mysqldata_bakLinux_user=bakmysqlDb_name= database namedb_user= User Namedb_pass= PasswordDays=7CD $OUT _dirDate= ' Date +%y_%m_%d 'Out_sql= "$DATE. SQL"Tar_sql=

Creation of tablesCREATE TABLE ' Lee ' (' id ' int (ten) is not NULL auto_increment,' Name ' char (DEFAULT NULL),' Birthday ' datetime DEFAULT NULL,PRIMARY KEY (' id ')) engine=innodb DEFAULT Charset=utf8Data insertion:Insert into Lee (Name,birthday)

first of all, we should understand one of the important features of MySQL-plug-in storage engine, from the name can be seen in MySQL, users can choose the storage engine according to their own needs, in fact, even in the same database, different

The CI of PHP is a framework of the MVC pattern, this article is through the PHP+CI to the MySQL database to carry on the enhancement and deletion check.0. First create a database and data table on MySQL database side1 Create Databasetest;2 Usetest;

Tried for a long time, always landing failed. began to think that the password is wrong, and later found that the MySQL settings so that only through the 127.0.0.1 and not through localhost access.The solution to this problem is clear:(1) Change the

Install MySQL First:Sudo?apt-get?install?mysql-server?mysql-client?1. Terminal starts Mysql:/etc/init.d/mysql start;(Stop, restart.) ）2. Login Mysql:mysql-uroot-p (login with root account) and enter the password;3. View all database names: show

Ext.: http://blog.csdn.net/longyuhome/article/details/7913375Win7 System Installation MySQL5.5.21 diagramWe all know that MySQL is a small and medium-sized relational database management system, very practical, for us to learn a lot of technology is

1. Create a Sparksql_mysql Scala object on idea.2. The code to connect to MySQL is as followsimport java.sql. {DriverManager, PreparedStatement, Connection}import org.apache.spark.rdd.JdbcRDDimport Org.apache.spark. {sparkcontext,

One, sub-database sub-tableObviously, a main table (that is, very important tables, such as user tables) unlimited growth is bound to seriously affect performance, sub-library and sub-table is a very good solution, that is, the performance

MySQL configuration:1, use Innodb_flush_method=o_direct to avoid writing when the double buffer.2. Avoid using O_direct and EXT3 file systems-This will serialize everything written.3. Allocate enough innodb_buffer_pool_size to load the entire InnoDB

Recently in the optimization of a relatively large high-concurrency site, a lot of revenue, experience to share to everyone. 1. Table field Segmentation. frequently accessed tables, rows of large tables, remember to keep the minimum length field,