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 )
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 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
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.