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/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. For example, INT(4) specifies an INT with a display width of four digits. This optional display ...
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: city ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-general.html
A replication channel requires two MySQL servers acting as replication servers (one each for the source and replica). For example, this means that in the case of a replication setup with two replication channels (to provide an extra channel for ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table options. It is also important to note that the results vary depending on whether the operation is logged using statement-based or row-based binary logging ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
This occurs when both of the following circumstances are true: Any session executes FLUSH TABLES or DDL statements on the handler's table. The session in which the handler is open executes non-HANDLER statements that use tables. HANDLER tbl_name ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode.html
Attempting to use them with SET NAMES or SET CHARACTER SET produces an error. The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the BMP. For information about the Unicode ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
Suppose that clients named user1 and user2 each connect one time from hosta and hostb. When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, for grant tables, the host ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 5.7.32) TRUNCATE TABLE statement ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/doc/refman/5.7/en/windows-restrictions.html
Some versions of Windows have a boot time setting to enable larger applications by reducing the kernel application. The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-lock-waits.html
blocking_trx_age How long the blocking transaction has been executing, as a TIME value. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been ... These views summarize the InnoDB locks that transactions are waiting ...