https://dev.mysql.com/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/group-replication-enterprise-backup.html
MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise Edition. This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. The ...
https://dev.mysql.com/internal-temporary-tables.html
The TempTable storage engine provides efficient storage for VARCHAR and VARBINARY columns. VARCHAR and VARBINARY column values are padded to the maximum column length, in effect storing them as CHAR and BINARY columns. In some cases, the server ...
https://dev.mysql.com/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...
https://dev.mysql.com/mysql-cluster-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups.
https://dev.mysql.com/mysql-cluster-replication-schema.html
Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and the replication slave (whether the slave is a single server or a ...
https://dev.mysql.com/mysql-indexes.html
In this context, VARCHAR and CHAR are considered the same if they are declared as the same size. For example, VARCHAR(10) and CHAR(10) are the same size, but VARCHAR(10) and CHAR(15) are not. Indexes are used to find rows with specific column ...
https://dev.mysql.com/mysql-nutshell.html
The TempTable storage engine provides efficient storage for VARCHAR and VARBINARY columns. This section summarizes what has been added to, deprecated in, and removed from MySQL 8.0. A companion section lists MySQL server options and variables that ...
https://dev.mysql.com/mysqlslap.html
--number-char-cols=N, -x N The number of VARCHAR columns to use if --auto-generate-sql is specified. mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. Invoke mysqlslap like ...
https://dev.mysql.com/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
