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/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-information-schema-tables.html
They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information about thread pool thread group states TP_THREAD_GROUP_STATS: Thread group statistics TP_THREAD_STATE: Information about thread pool thread states Rows in these ... The following sections describe the INFORMATION_SCHEMA tables associated with the thread pool plugin (see Section 5.5.3, “MySQL Enterprise Thread ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
mysql> CREATE TABLESPACE myts -> ADD DATAFILE 'mydata-1.dat' -> USE LOGFILE GROUP mylg -> ENGINE=NDB; You must remove all data files from the tablespace using ALTER TABLESPACE, as shown here, before it can be dropped: mysql> ALTER TABLESPACE myts -> ... DROP TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-introduction.html
MySQL Server, and Group Replication, which enables a set of MySQL instances to provide high-availability. InnoDB Cluster provides an alternative, easy to use programmatic way to work with Group Replication. The following diagram shows an overview of ... This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to enable you to deploy and administer a complete integrated high availability solution for ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. These tables contain information aggregated over groups of events, including those that have been discarded from the history tables. These do not fall into any of ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
Note Replication filters cannot be set on a MySQL server instance that is configured for Group Replication, because filtering transactions on some servers would make the group unable to reach agreement on a consistent state. Filters set using this ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html
If a long-running statement was permitted to block a thread group, all other connections assigned to the group would be blocked and unable to start execution until the long-running statement completed. Assuming that the TP_THREAD_GROUP_STATS table ... This section provides guidelines on setting thread pool system variables for best performance, measured using a metric such as transactions per ...
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
Simple comparison operations (>=, >, =, <, <=, sorting, and grouping) are based on each character's “sort value.” Characters with the same sort value are treated as the same character. For nonbinary strings (CHAR, VARCHAR, TEXT), string ...
https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html
The AGGREGATE keyword, if given, signifies that the function is an aggregate (group) function. CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function ...
https://dev.mysql.com/doc/refman/5.7/en/file-permissions.html
For example, to give group access to all new directories, start mysqld_safe as follows: UMASK_DIR=504 # = 770 in octal export UMASK_DIR mysqld_safe & For additional details, see Section 4.9, “Environment Variables”. If you have problems with ...