View InnoDB disk space utilization

View InnoDB disk space utilization page utilization mainly refers to the space used by each page in btee. We know that the default page size of InnoDB is 16 kb. However, the actual usage is not always full. We define the total usage bytes of all

Implementation of auto-incrementing sequence generator

Implementation idea of auto-incrementing sequence generator l requirement u achieves the equivalent function of auto-incrementing Field Values in MySQL; the auto-incrementing Field Values in database tables in the same application cluster are

MySql stored procedure-4. Parameters

MySql stored procedure-4. Parameter-related links: MySql stored procedure-1. Basic knowledge of SQL stored procedure-1. Parameter classification parameters, same as programming, mySql stored procedures can also contain parameters. In the previous

MySQL table name/column name case

MySQL table names/column names are case sensitive. in MySQL, databases and table pairs are stored in directories and files under those directories. Therefore, the sensitivity of the operating system determines the case sensitivity of the database

Mysql knowledge extension-database/table sharding

Mysql knowledge expansion-database/table sharding MySQL Internet Oracle Enterprise Application Data Structure. database Replication can solve the access problem and cannot solve the large-scale concurrent writing problem. To solve this problem, we

The problem that the MySQL table field name contains a minus sign

The problem that the MySQL table field name contains a minus signWhen inserting data into MySQL Data, the SQL syntax error is always prompted. After half a day of check, it turns out that the table name contains a minus sign. Original TABLE

How to use MySQL to intercept string functions

MySQL uses string Truncation in MySQL when creating a view today, which is very convenient. I feel that the string function of MySQL intercepts characters, which is more powerful than program interceptions (such as PHP or JAVA). So I want to make a

Mysql functions replace related subqueries (Correlated subquery)

The mysql function replaces the related subquery (Correlated subquery) SQL code CREATE TABLE '2017 _ teacher '('Teacher _ id' int (11) NOT NULL, 'School _ id' int (11) not null, primary key ('Teacher _ id'), KEY '2017 _ teacher_idx_school '('school _

Group_concat function in MySQL

The group_concat function in MySQL this article introduces how to use the group_concat function in MySQL through examples, such as select group_concat (name ). The complete syntax of the group_concat function in www.2cto.com MySQL is as follows:

How to reset automatic incremental columns of MySQL

How to reset the automatic incremental column of MySQL database provides a wonderful function AUTOINCREMENT column index. Your database table can be defined as a primary key with auto increment numbers. MySQL will take care of its unique value while

Query the disk space used by all databases in mysql and the size of all tables in a single database

Query the disk space used by all databases in mysql and the size of all tables in a single database SQL code www.2cto.com select TABLE_NAME, concat (truncate (data_length/1024/1024, 2), 'mb') as data_size, concat (truncate (index_length/1024/1024, 2)

MYSQL: basic operations

1. log on to the database www.2cto.com command: MYSQL-u username-p (mysql-h host address-u username-p user password) Description: Enter the command and press Enter, you can enter the password. After the password is verified, you can access the

Mysql startup error-server PID file cocould not be found resolved

Mysql startup error-server PID file cocould not be found solution [root @ yunhe ~] # Service mysql stopMySQL server PID file cocould not be found! [Failure] www.2cto.com solution: First, check the mysql-related process [root @ yunhe ~] # Ps aux |

How to batch modify the mysql database table prefix

In database design, for a specific project, the same table prefix is usually specified for all data tables, for example, WordPress Data Tables start with wp _ and Discuz Data Tables start with dz. This not only facilitates differentiation, but also

Master-slave Data Synchronization for Mysql servers

Example of Master-Slave Data Synchronization for Mysql Server: How can I synchronize data from A Master server to A Slave server by using server A as the Master server (Master) and server B1 and server B2 as the Slave server (Slave, let's take a

MySQL master-master replication, modifying the table structure online

MySQL master-master replication, online table structure modification has always been to think that the dual-master architecture can solve the mysql table online DDL requirements, but there is no practical test experience. Later I found that there

Mysql structure hierarchy

Mysql structure hierarchyTo understand MySql, you must keep in mind its architecture. Mysql is composed of SQL interfaces, Resolvers, optimizers, caches, and storage engines.Www.2cto.com1. Connectors refers to the interaction with SQL in different

MySQL Proxy-core

MySQL Proxy-Core layer (Core) Network Core is built on the basis of socket processing implementation, and the client connection and server connection are associated together. [Connection Life Cycle] connection can be in one of the following four

Build a mysql cluster in linux

Build a mysql cluster in linuxChapter 2 Environment Description1.1 System DescriptionThree linux servers are used and centos is used to minimize the installation of the system.1.2 Software DescriptionDatabase Management Nodes and database nodes all

In the hot standby server, switch to master to switch SQL

In the hot standby server, switching SQL from the master node fails in the master node. When a Hot Standby server needs to be switched in time, the original Server Load balancer under the master node also needs to be switched to the new master

Total Pages: 3233 1 .... 1249 1250 1251 1252 1253 .... 3233 Go to: GO

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.