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/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_digest_lost The number of digest instances ...This can be nonzero if the value of performance_schema_digests_size is too ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
Performance Schema Timers Two Performance Schema tables provide timer information: performance_timers lists the available timers and their characteristics. For example, the standard gettimeofday() function can take hundreds of cycles, which is an ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
To encrypt data in an InnoDB file-per-table tablespace, run ALTER TABLE tbl_name ENCRYPTION = 'Y'. To encrypt a general tablespace or the mysql tablespace, run ALTER TABLESPACE tablespace_name ENCRYPTION = 'Y'. Does the transportable tablespaces ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
Note Prefix limits are measured in bytes, whereas the prefix length in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements is interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL ...The available referential actions are RESTRICT (the default), CASCADE, SET NULL, and NO ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition refers. What happens to a view if an underlying table is dropped or renamed? ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-upgrade-downgrade-7-5.html
When upgrading a previous release to NDB 7.5 (or later), you can use the --force --upgrade-system-tables options with mysql_upgrade so that it performs ALTER TABLE ... The table shown here provides information on NDB Cluster upgrade and downgrade ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For TEMPTABLE, the results from the view are retrieved into a temporary table, which then is used to execute the statement. It prefers MERGE over ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
Command line: $> mysqld --innodb-buffer-pool-chunk-size=134217728 Configuration file: [mysqld] innodb_buffer_pool_chunk_size=134217728 The following conditions apply when altering innodb_buffer_pool_chunk_size: If the new ... You can configure ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-importing-data.html
You may also wish to do this when performing bulk DELETE or UPDATE operations on NDB Cluster tables. If a data import operation does not complete successfully, for whatever reason, you should be prepared to perform any necessary cleanup including ...