https://dev.mysql.com/federated-description.html
To read a result set, it uses mysql_store_result() and fetches rows one at a time using mysql_fetch_row(). When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition ...
https://dev.mysql.com/file-instances-table.html
If a file was opened and then closed, it was opened 1 time, but OPEN_COUNT will be 0. The file_instances table lists all the files seen by the Performance Schema when executing file I/O instrumentation. If a file on disk has never been opened, it ...
https://dev.mysql.com/fips-mode.html
MySQL supports FIPS mode, if compiled using OpenSSL 1.0.2, and an OpenSSL library and FIPS Object Module are available at runtime. For MySQL to support FIPS mode, these system requirements must be satisfied: At build time, MySQL must be compiled ...
https://dev.mysql.com/firewall-installation.html
MySQL Enterprise Firewall installation is a one-time operation that installs the components described in Section 6.4.7.1, “MySQL Enterprise Firewall Components”. Installation can be performed using a graphical interface or manually: On Windows, ...
https://dev.mysql.com/firewall-usage.html
The Firewall_access_granted count is 4 because of the @@version_comment statement sent by the mysql client each of the three time you used it to connect as the registered user, plus the SHOW TABLES statement that was not blocked in DETECTING mode.
https://dev.mysql.com/full-disk.html
The thread is aborted the next time it checks the disk (in one minute). This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block ...
https://dev.mysql.com/fulltext-restrictions.html
For InnoDB, all DML operations (INSERT, UPDATE, DELETE) involving columns with full-text indexes are processed at transaction commit time. Full-text searches are supported for InnoDB and MyISAM tables only. The exception is that for Unicode, the ...
https://dev.mysql.com/function-optimization.html
For example: SELECT * FROM t WHERE partial_key=5 AND some_column=RAND(); If the optimizer can use partial_key to reduce the set of rows selected, RAND() is executed fewer times, which diminishes the effect of nondeterminism on optimization. A ...
https://dev.mysql.com/get-diagnostics.html
This shows that you can use GET DIAGNOSTICS multiple times to retrieve information about a statement as long as the current diagnostics area has not been cleared. GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, ...
https://dev.mysql.com/group-by-modifiers.html
In this case, each time there is a change in value in any but the last grouping column, the query produces an extra super-aggregate summary row. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows ...
