PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/firewall-installation.html
$> mysql -u root -p < linux_install_firewall.sql Enter password: (enter root password here) Note As of MySQL 5.7.21, for a new installation of MySQL Enterprise Firewall, InnoDB is used instead of MyISAM for the firewall tables. MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html
Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns. A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER ... MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A full-text index in MySQL is an index of type ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
For example: mysql> GET DIAGNOSTICS CONDITION 1 @p5 = SCHEMA_NAME, @p6 = TABLE_NAME; mysql> SELECT @p5, @p6; +------+------+ | @p5 | @p6 | +------+------+ | | | +------+------+ In standard SQL, if there are multiple conditions, the first condition ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
For the purpose of demonstrating that the server is indeed in a group and that it is able to handle load, create a table and add some content to it. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
Detecting Partitions The replication_group_members performance schema table presents the status of each server in the current view from the perspective of this server. The majority of the time the system does not run into partitioning, and therefore ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. The following list indicates possible causes of and fixes for this ...
https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimization.html
This access method merges index scans from a single table only, not scans across multiple tables. AND key_partN = constN Any range condition over the primary key of an InnoDB table. If all columns used in the query are covered by the used indexes, ... The Index Merge access method retrieves rows with multiple range scans and merges their results into ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
Before you change innodb_buffer_pool_chunk_size, calculate the effect on innodb_buffer_pool_size to ensure that the resulting buffer pool size is acceptable. For example: mysql> SHOW STATUS WHERE Variable_name='InnoDB_buffer_pool_resize_status'; ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-enabling.html
The innodb_file_format configuration option enables an InnoDB file format for file-per-table tablespaces. SET GLOBAL innodb_file_format=Barracuda; Usage notes InnoDB file format settings do not apply to tables stored in general tablespaces. General ...Note The innodb_file_format configuration option is deprecated and may be removed in a future ...