PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-table-examples.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 1 row in set (0.01 sec) To change the storage type of an ...For ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
However, a user that requires an SSL connection must have been created before the server joining the group connects to the donor. new_member> SET GLOBAL group_replication_recovery_use_ssl=1; new_member> SET GLOBAL group_replication_recovery_ssl_ca= ... Group communication connections as well as recovery connections, are secured using ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation.html
MySQL Installer automatically installs MySQL Server and additional MySQL products, creates an options file, starts the server, and enables you to create default user accounts. Users should make sure the package has been installed on the system ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
If you now execute a SHOW CREATE TABLE statement, you can see how the partitioning makeup of the table has been changed: mysql> SHOW CREATE TABLE tr\G *************************** 1. Another solution might appear to be to make a copy of the table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-performance.html
Online DDL and Metadata Locks Online DDL operations can be viewed as having three phases: Phase 1: Initialization In the initialization phase, the server determines how much concurrency is permitted during the operation, taking into account storage ...Session 1: mysql> CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; mysql> START TRANSACTION; mysql> SELECT * FROM t1; The session 1 SELECT statement takes a shared metadata lock on table ... Online DDL improves ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
The KEY_BLOCK_SIZE clause in the following comment is executed only by servers from MySQL 5.1.10 or higher: CREATE TABLE t1(a INT, KEY (a)) /*!50110 KEY_BLOCK_SIZE=1024 */; The following descriptions list MySQL extensions, organized by category.
https://dev.mysql.com/doc/refman/5.7/en/invoking-programs.html
They indicate the host where the MySQL server is running, and the user name and password of your MySQL account. $> mysql --user=root test $> mysqladmin extended-status variables $> mysqlshow --help $> mysqldump -u root personnel Arguments that begin ... To invoke a MySQL program from the command line (that is, from your shell or command prompt), enter the program name followed by any options or other arguments needed to instruct the program what you want it to ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-command-line.html
You can stop the MySQL server by executing this command: C:\> "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, you need to invoke mysqladmin with the -p option and supply ...Note Users in the MySQL grant system are wholly independent from any operating system users under Microsoft ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Tables created for ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
cat t1.ibd | innochecksum --write=crc32 - > a.ibd Running innochecksum on Multiple User-defined Tablespace Files The following examples demonstrate how to run innochecksum on multiple user-defined tablespace files (.ibd files). On Windows systems, ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...