engine innodb

0. Defragment the table spaceOptimize table TableName1, table partition by year partition, quarter sub-partitionAlter TableKey_part Partition byRange Year(create_time)) Subpartition byHash (quarter (create_time)) Subpartitions4(Partition

1, the log to enter the target table structure information 1.1 The target table structure information on the Hive library CREATE TABLE ' Yemao_log ' ( ' id ' int, ' time ' int, ' url_from ' string, ' url_current ' string, ' url_to '

How to batch modify MySQL engine in production environmentIn general, this demand is not much, but occasionally, here we recommend the use of SED to the backup of the content of the engine conversion method, of course, do not forget to modify the MY.

There is a way to do this online:1. View the commands for the current data engine:Show engines;2.Use ' [DBNAME] `;SELECT Group_concat (CONCAT (' ALTER TABLE ', table_name, ' engine=innodb; ') SEPARATOR ")From INFORMATION_SCHEMA. TABLES as TWHERE

This article describes how to use the MySQL database partition function. the difference and connection between MySQL table shards and partitions are described in detail. For more information, see Zero: What is database partition?Let's talk about

MySQL database partition function tutorial, mysql tutorial Zero: What is database partition?Let's talk about what is a database partition. Take mysql as an example. The data in the mysql database is stored on the disk as a file, which is stored

MySQL read/write splitting using MyCAT MyCAT is a database middleware developed based on Alibaba's open-source cobar product. It is jointly developed and open-source by several talented people with lofty ideals. Provides highly available data

Myisam table to innodb table to convert from InnoDB engine to MyISAM engine. after reading this article, you should know how to convert MyISAM engine to InnoDB engine (please make sure InnoDB is enabled, mySQL command line show engines command view )

001 set @ Prov_Code: = 32; 002 set @ Prov_Name = "Provincial/Municipal Departments"; 003 set @ Area_Code: = 3201; 004 set @ Area_Name = "Municipal Bureau "; 005 www.2cto.com 006 007 SET FOREIGN_KEY_CHECKS = 0; 008 -- ---------------------------- 009

We know that if we use MySQL, when the amount of database data reaches a certain amount of data, we will consider the database to do the sub-table, and other operations, but under what circumstances to do how to slice, the following table

Mysql stored procedure statement bitsCN.com 001 set @ Prov_Code: = 32; 002 set @ Prov_Name = "provincial/municipal departments"; 003 set @ Area_Code: = 3201; 004 set @ Area_Name = "municipal Bureau "; 005 006 007 SET FOREIGN_KEY_CHECKS = 0; 008 -- --

Mysql Optimization-Zabbix partition Optimization-mysqlzabbix Partition The biggest bottleneck of zabbix is that the database maintains zabbix's data storage and generates alarms. Therefore, zabbix can be used to build a monitoring system. Currently,

The company is using partition online. The partition field of a table is incorrect and needs to be rebuilt. It turns out that there is no way to directly fix it using an SQL statement like modifying the primary key field or index field. Instead, you

One, what is a database partition Some time ago wrote an article on the MySQL table, the following to say what is a database partition, MySQL as an example. The data in the MySQL database is documented as the situation exists on the disk, by

MySQL partition Table partition online modify partition field company online use partition, there is a table partition field error, need to be rebuilt, it turns out that there is no way to directly execute an SQL statement like modifying the primary

Modify the partition field bitsCN.com online in the MySQL partition table partition. MySQL partition table partition online partition field modification The company is using partition online. the partition field of a table is incorrect and needs

DDL statement -- modify a table Modifying a table is to modify the definition of an existing table in the database. It is simple to modify a table because it does not need to reload data or affect ongoing services. MySQL uses the alter table

0, what is a database partitionto say what is a database partition, take MySQL for example. The data in the MySQL database is documented as the situation exists on the disk, by default placed in the/mysql/ Data below (can be viewed through the

MySQL partition table technology analysis bitsCN.com MySQL partition overview:Allows you to allocate multiple parts of a single table across file systems based on rules that can be set to any size. In fact, different parts of a table are stored as

MySQL partition Overview:Allows you to allocate multiple parts of a single table across file systems based on rules that can be set to any size. In fact, different parts of a table are stored as separate tables in different locations. The