PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key Advantages of InnoDB Its DML operations follow the ACID model, with transactions featuring commit, ... InnoDB is a general-purpose storage engine that balances high reliability and high ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
The collation is designed for a scenario involving a Web application for which users post their names and phone numbers. You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mysqld.html
row *************************** Id: 1 User: system user Host: db: Command: Daemon Time: 1 State: Waiting for event from ndbcluster Info: NULL Important To participate in an NDB Cluster, the mysqld process must be started with both the options ...To ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html
The create_old_temporals system variable was deprecated in NDB Cluster 7.4, and has now been removed. This setting can be controlled for individual tables by means of a PARTITION_BALANCE option (renamed from FRAGMENT_COUNT_TYPE in NDB 7.5.4) ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
For most users, the mixed replication format should provide the best combination of data integrity and performance. SELECT, a CREATE statement is generated from the table definition and replicated using statement-based format, while the row ...If, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-processlist.html
tmp_tables The number of internal in-memory temporary tables created by the current statement. tmp_disk_tables The number of internal on-disk temporary tables created by the current statement. The MySQL process list indicates the operations ...
https://dev.mysql.com/doc/refman/5.7/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Daemon This thread is internal to the server, not a thread that services a client connection.
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
YEAR(2) column definitions for new tables produce warnings or errors: Before MySQL 5.7.5, YEAR(2) column definitions for new tables are converted (with an ER_INVALID_YEAR_COLUMN_LENGTH warning) to 4-digit YEAR columns: mysql> CREATE TABLE t1 (y ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-unicode-uca.html
It is not possible to create user-defined UCA collations for utf16le; there is no utf16le_unicode_ci collation that would serve as the basis for such collations. Table 10.4 MySQL Character Sets Available for User-Defined UCA Collations Character Set ... This section describes how to add a UCA collation for a Unicode character set by writing the <collation> element within a <charset> character set description in the MySQL Index.xml ...
https://dev.mysql.com/doc/refman/5.7/en/alter-server.html
ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. For example, to update the USER option: ALTER SERVER s OPTIONS (USER ...