MySQL

Why divide tables and partitions? We often encounter large tables in daily development, so-called large tables are those that store millions or even tens records. Such tables are too large to cause the database to take too long to query and insert,

What is master-slave replication:By copying data from one of the MySQL hosts to a different host, one server acts as the primary server (master) while one or more other servers act as slave servers (slave). When replicating, all writes to the data

Make a note for the convenience of inspection.View the status of the MySQL process through show processlist, which has the following status on the State column:AnalyzingThe thread makes an analysis of the statistics of the MyISAM table (for example,

three components of the InnoDB row store (description: F character = number of columns) Names (name) Sizes (size) Field Start Offsets (f*1) or (f*2) bytes Extra Bytes 6 bytes

A test Case1 Write stress tests:Use case: Automatically create table write 1 million data client concurrent 500 test InnoDB storage EngineCommand: Mysqlslap--auto-generate-sql-add-autoincrement-a--number-of-queries=1000000--number-char-cols=4--

ubuntu mysql Emma Chinese garbled problem solve Emma by default with Apt-get installation, Emma does not support Chinese, configuration file or directly modify the Emma program source file (Python). Apt-get installed Emmasudo apt-get install Emma

Linux settings MySQL and allow external machine access, the specific directory is the case, some people are installed in the personal directory, then find the corresponding directory can be Linux under set MySQL and allow external machine access

The variables in SQL Server are first declared and then assigned:Local variables with an @ identifier, global variables with two @ (common global variables are generally defined);Declare local variable syntax: DECLARE @ variable name data type; For

Linux environment, not under Windows platform. The difference is very big. Attention.A picture wins thousand words  mysql> show create table ac;+-------+--------------------------------------------------------------- ---------------------------------

Preface It's a tough time to play. In addition to the compiler using Yum installation, all others are compiled manually. Hum ~Seemingly on Nginx, PHP, MySQL three east, but they are too much to rely on others.There is no way to use them to be

When using MySQL, the load data infile is often used to import, and sometimes a format conversion problem is encountered when a column of type date is encountered:First create a simple people table with name, birthday, age three fields:mysql> create

August 11, 2012 SAS 9.1.3 version with MySQL connection test, can connect with database1 direct connectivity via ODBC pass throughConnect to ODBCCREATE TABLE (or view)2 through AccessAccess connects to MySQL using the access connection ODBC,ODBC,

MySQL Change portModify/ETC/MY.CNFAdd port=3308then restart MySQLIf you turn on the Selinux,mysql will not start, you will see the following error in the log[ERROR] Can ' t start server:bind on TCP/IP port:permission denied[ERROR] Do you already has

First create a test table:Insert into Test (TT) Values ('\\\\172.18.28.153');Now I want to use fuzzy matching to find out the string that starts with "\\172".Need to use like because "\" is an escape character, so you need to use 4 "\". The

Data backup schematic diagram650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/59/93/wKiom1TYWLvjFG6QAADdLOzjiWQ351.jpg "alt=" Wkiom1tywlvjfg6qaaddlozjiwq351.jpg "/>Data backup is part of data disaster protection, and all data backup

I read a blog post very well, it is easy to understand after reading, the post address is: http://www.cnblogs.com/lhj588/p/3315876.htmlRecently I met a friend in the group and said, so record:Assume that the table name is T. There are six fields in

Now, we introduce the database index, its advantages and disadvantages. The characteristics and application of MySQL index are described in detail. This paper analyzes how to avoid MySQL unusable, how to use explain to analyze query statements, and

This document uses Mysqldump to back up the database, mysqldump is a SQL-level backup mechanism, it is the data table into SQL script files, upgrade between different versions of MySQL is relatively appropriate, this is the most common backup method,

Mysql5.7 how to change the root password, mysql5.7 how to change the root password Version update. The password field in the original user has been changed to authentication_string Because of version updates, many online tutorials are not applicable,

SQL Server performance optimization -- wait -- SLEEP_BPROOL_FLUSHPreface: There is a database for historical archiving (referred to as the historical database). After a certain amount of time, the data file has reached more than 700 GB, and it was