myisamchk

1. MyISAM does not support transactions. InnoDB is a transaction-type storage engine. When our tables need transaction support, MyISAM cannot be selected. 2. MyISAM only supports 1. MyISAM does not support transactions. InnoDB is a transaction-type

If there is a problem with the data table, you can use the -- recover -- quick parameter to fix the problem:Linux # myisamchk -- recover -- quick tbl_nameLinux # isamchk -- recover -- quick tbl_nameIf the preceding method cannot solve the problem,

Let us answer some of the following questions: Do you have a foreign key in your database? Do you need business support? Do you need full-text indexing? What kind of query mode do you often use? How big is your data? Thinking about these issues

If there is a problem with the datasheet, you can use the--recover--quick parameter to do the work of patching: Linux#myisamchk--recover--quick Tbl_name Linux#isamchk--recover--quick Tbl_name If the above method does not resolve the problem, you can

When a lamp server I met suddenly crashed, the Web site opened: Table ' xxx ' is marked as crashed and should as repaired can be repaired directly with the MySQL command myisamchk: MySQL prompts tblname table is corrupted, need to fix, workaround:

In general, to make a slower select ... where it is faster, you should first check to see if you can add an index. References between different tables are usually done by index. You can use the explain statement to determine which indexes the SELECT

mysql| data If there is a problem with the datasheet, you can use the--recover--quick parameters to do the work of patching: Linux#myisamchk--recover--quick Tbl_name Linux#isamchk--recover--quick Tbl_name If the above method does not resolve the

A mature database architecture is not designed to be high availability, high scalability and other features, it is with the increase in user volume, the infrastructure is gradually improved. This article mainly discusses the MySQL database in the

http://blog.csdn.net/xiaoyu714543065/article/details/8211265A transaction has four characteristics: atomicity (atomicity), consistency (consistency), isolation (isolation), and persistence (durability). These four properties are referred to as ACID

MySQL Search engine SummaryAfter mysql5.5, MySQL uses the InnoDB storage engine by default.To modify the default engine, you can modify the default-storage-enginein the configuration file. Can be through show variables like ' default_storage_engine '

1. Create a databaseCreating a database is a piece of space on the system disk for storage and management of data.(1), View the history database:Show databases(2), create a database:CREATE DATABASE database_name (DB name);(3), view the created

MySQL has a variety of storage engines, each of which has its own advantages and disadvantages, and can be chosen with merit:MyISAM, InnoDB, MERGE, MEMORY (HEAP), BDB (BerkeleyDB), EXAMPLE, Federated, ARCHIVE, CSV, Blackhole.MySQL's storage engine

1. MyISAM: The default table type, which is based on the traditional ISAM type, ISAM is an abbreviation for indexed sequential access method (indexed sequential access methods), which is the standard way to store records and files. It is not

In the database is a sheet of inextricably linked tables, so the table design is good or bad, will directly affect the entire database. While designing the table, we will focus on one issue and what storage engine to use. Wait a minute, storage

First, the Engine foundation1 Viewing system-supported storage engines　　Show engines;2 View the storage engine used by the table in two ways:A, Show table status from database_name where name= ' table_name ';b, show create TABLE table_name;To view

For example, we want to back up a database named Linux that already exists in MySQL, using the command mysqldumpThe command format is as follows:[Email protected] root]# mysqldump-u root-p linux >/root/linux.sqlEnter Password: Enter the password for

mysql database Mysqlcheck The use of knowledge is the main content of this article, we know, Mysqlcheck, is the MySQL comes with can check and repair MyISAM table, And it can also optimize and analyze tables, mysqlcheck functions like Myisamchk, but

MySQL various storage engines (i) MySQL various storage engine one MyISAM MyISAM file format MyISAM File Repair Storage format for MyISAM tables

A mature database architecture is not designed to be high availability, high scalability and other features, it is with the increase in user volume, the infrastructure is gradually improved. This blog post mainly on the MySQL database development

Change to: http://lizhenliang.blog.51cto.com/7876557/16574651. database table Design to avoid slow query, inefficient query statements, not properly indexed, database congestion (deadlock), etc.2. Database deploymentProject initial visits are not