PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
ALTER TABLE tbl_name RENAME new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. For both InnoDB and ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
For HASH partitioning, the user-supplied expression must evaluate to an integer value. With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
This table can be updated by the user to perform filtering by database or table. In order not to make it necessary to insert a row in the ndb_replication table for each and every combination of database, table, and SQL node in your replication ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-notes.html
For use in single user mode, an entry for _mysql (note the underscore prefix) should already exist within the system /etc/passwd file. Choosing "Don't Allow" means this password won't be visible for use. You may need (or want) to create a specific ... You should keep the following issues and notes in mind: As of macOS 10.14 (Majave), the macOS MySQL 5.7 Installer application requires permission to control System Events so it can display a generated (temporary) MySQL root ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
Column definitions for character string data types CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can specify the column character set and collation: CHARACTER SET specifies the character set. If desired, a collation for the character ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...In some cases, MySQL may change a ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html
If the application has high requirements for the response time, it should most likely throttle users at a higher level itself. This section provides guidelines on setting thread pool system variables for best performance, measured using a metric ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
As with file-per-table tablespaces, the ability to place data files outside of the MySQL data directory allows you to manage performance of critical tables separately, setup RAID or DRBD for specific tables, or bind tables to particular disks, for ...The server keeps tablespace metadata in memory for the lifetime of a ... A general tablespace is ...
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
Note The use of MERGE tables entails the following security issue: If a user has access to MyISAM table t, that user can create a MERGE table m that accesses t. However, if the user's privileges on t are subsequently revoked, the user can continue ...“Identical” means that all tables have identical column data types and index ... The MERGE storage engine, also known as the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-tablespaces.html
The default setting for innodb_rollback_segments is 128, which is also the maximum value. Therefore, to allocate rollback segments to undo tablespaces, set innodb_rollback_segments to a value greater than 33. For example, if you have two undo ...