MySQL

Yum-y Install CMakeYum-y Install Ncurses-develYum-y Install gcc-c++Useradd-m-u 8001-s/sbin/nologin mysqlMkdir/dataTAR-XVF mysql-5.5.32.tar.gz-c/usr/local/src/cd/usr/local/src/mysql-5.5.32Installation by means of CMakeCmake-dcmake_install_prefix=/usr/

There are many MySQL performance optimization programs on the web, however, MySQL optimization compared with SQL Server, more cumbersome and complex, the same settings, in different environments, due to memory, access, read and write frequency, data

A simple and sticky MySQL database implementation1. Background: Small series to do a simple Article management page, with the MySQL database. It needs the article top function,2. The original idea: The wit of the small part of the rapid brain

SHOW STATUS like ' uptime ' start timeSHOW STATUS like ' com_select ' total number of queriesSHOW STATUS like ' com_update ' total number of modificationsSHOW global STATUS like ' connections ' link number does not add GLOBAL to current sessionDOS

Multi-sorting problem of MySQL database problem background: you want to be able to sort in descending order of Istop first, and if the Istop value is the same, sort by date descending. tried a few times after the implementation: a very

Original table:The table after finishing:Scenario one (Dynamic SQL):BEGIN #Routine body goes here ... DECLARE v1int(3); DECLARE v2int(3); #DECLARE v3 VARCHAR ( the); #DECLARE Vcompany VARCHAR ( -); #DECLARE VName VARCHAR ( -); DECLARE Vcol VARCHAR (

PrefaceMySQL's master-slave replication is the MySQL itself with a feature, do not need additional third-party software can be implemented, its replication is not a copy file to achieve, but the use of the Binlog log file inside the SQL command to

The event scheduler in MySQL, which can be used to perform timed tasks.First, openEvent scheduling is turned off by default, and executable is turned on.To see if the event Scheduler is turned on:SHOW VARIABLES like ' Event_scheduler '; SELECT @

It's a pleasure to start the MySQL learning journey today, starting with the MySQL installation first ...The following installation environment is: Win64 for the system, mysql-5.5.27-winx64. It is divided into two parts: installation and

This article from: http://blog.chinaunix.net/uid-20785090-id-4759476.htmlFor Build-in's InnoDB architecture, each time the IO request is published, it isIs the thread of the MySQL service complete or is it done by innodb_read_io_threads? Discuss

according to MySQL lock monitor This article to operate. Readiness condition: More than 5.6.16 version of MySQL, login MySQLOpenSet global Innodb_status_output=on;set global innodb_status_output_locks=on;Add and Modify tables.Mysql>Show CREATE TABLE

In MySQL, if a table contains no varchar, text, and its deformation, blob, and its deformed fields, then this table is actually called a static table, that is, the table row_format is fixed, that is, each record occupies the same byte. The

IntroductionThe sub-partition is actually separate each partition of each partition table, currently only the range and list partition table can be sub-partition, sub-partition can only be hash or key partition. Sub-partitions can divide the

OA (Tomcat+mysql) Some recent problems, Friday, please factory technology remote debugging a bit. The debugging process is as follows:1. The index of OA database is optimized;2. Change the database minimum connection number from the original 30 to 5;

1, need to promote the main from the library, stop IO thread waiting for slave data all update completeStop slave Io_thread#show processlist output until you see that the status is slave have read all relay log; Waiting for the slave I/O thread to

1. Manipulate the database through SQL (Structured Query language): DDL: Data definition language, create library, create table, select;  dml: Data manipulation language, complete data additions and deletions; DQL: Data Query Language, Complete

MySQL database basics of MySQL_01, mysql_01mysql 1. operate databases through SQL (Structured Query Language:DDL: Data Definition Language, database creation, table creation, and selection;DML: data operation language to add, delete, and modify data;

MySQL sub-partitions and mysql partitionsIntroduction Subpartitions are actually used to separate each partition in each partition table. Currently, only tables with RANGE and LIST partitions can perform subpartitions. subpartitions can only be HASH

MySQL KEY partition and mysqlkey PartitionIntroduction KEY partitions are similar to HASH partitions, but KEY partitions support all data types except text and BLOB, while HASH partitions only support numerical partitions, KEY partitions cannot be

MySQL LIST partition and mysqllist PartitionIntroduction LIST partitions and RANGE partitions are very similar. The main difference is that LIST is a set of enumerated values, and RANGE is a set of consecutive RANGE values. The two are very similar