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/innodb-buffer-pool-resize.html
For example: mysql> SET GLOBAL innodb_buffer_pool_size=402653184; Note The buffer pool size must be equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances. For additional information about configuring buffer pool size ... You can configure InnoDB buffer pool size offline or while the server is ...
https://dev.mysql.com/doc/refman/5.7/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
DEFINER The account named in the DEFINER clause (often the user who created the trigger), in 'user_name'@'host_name' format. To see information about a table's triggers, you must have the TRIGGER privilege for the table. TRIGGER_SCHEMA The name of ...The TRIGGERS table has these columns: TRIGGER_CATALOG The name of the catalog to which the trigger ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
By doing so, it is possible to expend much less time and effort in finding matching rows than would be required to scan all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
To view available InnoDB mutex wait instruments, query the Performance Schema setup_instruments table, as shown below. The ENABLED and TIMED columns should be set to YES for the instruments that you enabled. mysql> SELECT * FROM ... A mutex is a ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-system-variables.html
For a description of the privilege requirements for setting system variables, see Section 5.1.8.1, “System Variable Privileges” The following table lists all dynamic system variables applicable within mysqld. Please see the corresponding item ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...For example, lookups are case-insensitive if the collation is latin1_swedish_ci, whereas lookups are case-sensitive if the collation is latin1_general_cs or ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ...For example, MySQL automatically converts strings to numbers as necessary, and vice ... When an operator is used ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-adding-binlog-master.html
These steps assume that you have enabled binary logging on the replication source server using --log-bin, the replica is using TABLE based replication metadata repositories, and that you have enabled a replication user and noted the current binary ...Use the CHANGE MASTER TO statement to configure a replication channel for each source on the replica (see Section 16.2.2, “Replication ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-encrypted-file-plugin.html
To specify the password for encrypting the keyring data file, set the keyring_encrypted_file_password system variable. (The password is mandatory; if not specified at server startup, keyring_encrypted_file initialization fails.) The ...The ... Note ...