show table status

Metadata: Data, information that describes the data is also data, called metadata[MySQL] How to get metadataMySQL provides the following three ways to get the metadata for a database object: 1) Show Statement 2) query the related table from the

"Ultra-simple" MySQL storage engine selection and Configuration Storage engine IntroductionData in MySQL is stored in files (or memory) in a variety of different technologies. Each technology uses different storage mechanisms, indexing techniques,

We can understand the rationale behind mysqldump by opening the general log and looking at the commands executed during mysqldump full library backup.Open General Logmysql> set global general_log=on;Where the general log's storage path can be viewed

MySQL storage engine MyISAM and InnoDB storage engine Data in MySQL has a variety of different technologies for storing files or in memory. Each of these technologies uses different storage mechanisms, indexing techniques, locking levels,

1.1 Use of the storage engine Each table in the database is processed by the storage engine specified (when the table was created). The engines available to the server depend on the following factors: Version of MySQL

Mysql> show engines;Mysql> ALTER TABLE T1 engine = InnoDB;Mysql> ALTER TABLE t7 auto_increment = 100;Mysql> Show Table status like "T6" \G;Try to reply to a single table with the IDB file, and note that you want to revert to the original library:1.

First, create the syntax form of the viewCREATE VIEW view_nameAs query statement;Working with viewsSELECT * from View_name;Second, create a variety of views1. Encapsulates the view that implements the query constant statement, the so-called constant

Show Table status;//View all table states, with this command to know when the table was created and when it was last updated, and whether the table is a base table or a view, and what table engine is the information.Show table status from DBName

1. mysql defaults to auto-commit, which is the autocommit mode, meaning that if a transaction is not explicitly opened, then each transaction is treated as a transaction to commit the operation.Show variables like ' autocommit ' to see the current

Installation of MySQL:Download mysql-5.5.54-linux2.6-x86_64.tar.gz# TAR-XF Mysql-5.5.54-linux2.6-x86_64.tar.gz# LN-SV Mysql-5.5.54-linux2.6-x86_64/usr/local/mysqlFor security, create a MySQL-only user without logging in to bash# Useradd Mysql-b/sbin/

In the database optimization, we see some of the tables are designed to use text or BLOB fields, if the single table storage space reached nearly hundred g or dozens of G, this situation again to change and optimization is very difficultFirst,

Sometimes, when using MySQL, you may find that even though a table deletes a lot of data, the data and index files of this table are surprisingly small. This is because when MySQL deletes data (especially text and blobs), it leaves a lot of data

Reprint Please indicate the source: The Curtain Roll westerly column (Http://blog.csdn.net/ljxfblog)Several ways MySQL obtains the self-increment ID Using the max function: select Max (ID) from TableName Advantages: Easy and

SHOW CHARACTER SETShow all the available character setsCHARACTER SET CHARACTERSETlike'latin%';SHOW COLLATIONThe output includes all available character sets like ' latin1% ';SHOW COLUMNSDisplays the information for each column in a given table, and

Storage of MySQL data on disk:Data BLOCK:A block of multiple disk blocks in which the storage engine manages data blocks.A disk is a block device, and the data stored on disk is stored in blocks.When MySQL reads the table into memory, it is also

For MySQL data fragmentation, in fact, and we delete the data is closely related to the deletion of data when the data file will inevitably create a discontinuous blank space, for a small amount of data deletion, and will not produce much white

What is a viewThe view in the database is a virtual table . A view is a table that is exported from one or more tables, and the behavior of the view is very similar to the table in which the user can query the data using the SELECT statement and

MySQL when creating a table, create a . frm file to save the table and column definitions. The index is stored in a . MYI (myindex) file extension and data is stored in the . MYD (MYData) extension in the file. First, using Show/describe statement

0x01MySQL storage engine: The storage Engine is also commonly referred to as the "table type"Mysql> show engines; ---View all currently supported storage enginesMysql> Show Table StatusStorage Engine Format:SHOW TABLE STATUS [{from | in}

1. Why should I use a view?To improve the reusability of complex SQL statements and the security of table operations, the MySQL database management system provides view features. The so-called view, essentially a virtual table, is not physically