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/column-indexes.html
EXPLAIN for full-text queries may show Select tables optimized away in the Extra column due to matching occurring during optimization; in this case, no table access need occur during later execution. The most common type of index involves a single ...
https://dev.mysql.com/doc/refman/5.7/en/common-errors.html
Although the problems show up when you try to run client programs, the solutions to many of the problems involves changing the configuration of the MySQL server. This section lists some errors that users frequently encounter when running MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
The following table shows how various combinations of User and Host values in the user table apply to incoming connections. The preceding set of examples demonstrates this: Several of the entries shown match a connection from h1.example.net by fred.
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). To make the change permanent, add a line in your my.cnf file, as shown ...
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
Our experience shows that this kind of “educated guess” rarely misses optimal plans, and may dramatically reduce query compilation times. The task of the query optimizer is to find an optimal plan for executing an SQL query. Because the ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
The following examples show different ways to perform animal census operations. Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the ...
https://dev.mysql.com/doc/refman/5.7/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
Values of a generated column are computed from an expression included in the column definition. Generated columns are supported by the NDB storage engine beginning with MySQL NDB Cluster 7.5.3. Generated column definitions have this syntax: col_name ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. For information about restrictions on view use, see Section 23.9, “Restrictions on Views”. The ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files-using-mysql.html
For some distribution types, such as RPM and DEB packages, mysql_ssl_rsa_setup invocation occurs during data directory initialization. In this case, the MySQL distribution need not have been compiled using OpenSSL as long as the openssl command is ...