MySQL

MySQL database base and client commands in Linux1.mysql Database Storage Engine:SHOW ENGINES; #查看mysql支持的存储引擎The following two storage engines are common:MyISAM: Three files per table:. frm: Table structure. MYD: Table Data. MYI: Table IndexInnoDB:

Storage Engine(1) MySQL can store data in a file (memory) with different techniques, which becomes the storage engine.Each memory engine uses different storage mechanisms, indexing techniques, locking levels, and ultimately offers a wide range of

Storage Engine is a major feature of MySQL, learning MySQL must understand it, know its various engines differences, how to choose and use the right. So it's a brief introduction.1. Look at the types of engines supported by the system, such as the

There are some things in MySQL that are similar to SQL Server, while many things are similar to Oracle, and today we share a database management approach that is slightly similar to SQL Server.1. Information_schema Database: This database provides a

MySQL Database Backup CommandMysqldump-hhostname-uusername-ppassword databasename > Backupfile.sqlBacking up the MySQL database to a format with a delete tableBacking up the MySQL database is a format with a delete table that allows the backup to

1 , prepare two database environments, or a single multi-instance environment for normal startup and logon. 2, Configurationmy.cnffile, main library configurationLog-binand theServer-idparameters, configuring from libraryServer-id, cannot normally

1. Table PropertiesBasic syntax for creating a table:CREATE TABLE "If not exists" Table name (field list, index or constraint list ")" Table option List "Where the field list is formatted as follows:Field Name Type "Property List",Field Name Type

Write in front: indexes have a critical impact on the speed of queries, and understanding indexes is also a starting point for database Performance tuning. Consider the following scenario, assuming that a table in the database has 10^6 records, the

Get readyPrimary server ip:192.168.1.100From server ip:192.168.1.101Create the database on the primary server, add the initial data, and then import to the slave server1. Install the MySQL service on the master/slave server respectively, the MySQL

Recent projects need to import a large number of compressed files into the database, so began to summarize the Python batch processing method, this is the first to extract the file names of these compressed files, and then import into the

The MySQL stored procedure is a new feature that has been added since MySQL 5.0. The advantages of a stored procedure are a whole bunch. But the main thing is the execution efficiency and the SQL code encapsulation . In particular, the SQL Code

The stored procedures are:Through a series of SQL statements, according to the parameters passed in (also can not), through a simple call,The ability to complete more complex functions than a single SQL statement, stored on the database server side,

1. mysql System architectureThe system structure that displays MySQL content, the entire system is divided three times:1) network connection and thread processing layer, this layer handles client connection request, authentication and threading,

--  added create trigger yqhl_htjs_b_htjbxx_insert before insert on  table name    for each row    begin    if  (NEW. F_sync_update is null)  or  (NEW. f_sync_update = 0)   then    set new. f_sync_update=null;       --  inserting newly added records

1.linux commands to start MySQL:Mysqladmin start/ect/init.d/mysql start (front of MySQL installation path)2.linux Restart MySQL command:Mysqladmin restart/ect/init.d/mysql Restart (front of MySQL installation path)3.linux the command to turn off

The explain command is the first recommended command to address database performance, and most performance issues can be easily resolved by this command, explain can be used to see how SQL statements are executed, to help select better indexes and

1. Download the MySQL installation files, download to the official website, http://dev.mysql.com/downloads/mysql/, has given you the choice of the current platform is what, my current is Mac OS X, the next bread will have multiple versions, the

Solve centos server exception power-off mysql startup exception Mysql startup error: mysqld Symptom:Centos server exception power-off MySQL startup exception Mysql startup error: mysqld_safe mysqld from pid file/usr/local/mysql/Linux. pid endBut

The reason why Mysql reports Row size too large 65535 and its solution are as follows: row65535 Error message:Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535 When a field type of mysql table plug-in is

MySQL-optimized partition table: mysql Partition Table When the database data volume increases to a certain amount, performance becomes a problem that cannot be ignored. How can we optimize it? There are several common methods: 1. Table sharding: