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/mysql-cluster-programs-ndb-drop-table.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html
The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is rejected. Use cases for this plugin ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
Status This section shows the timestamp, the monitor name, and the number of seconds that per-second averages are based on. The number of seconds is the elapsed time between the current time and the last time InnoDB Monitor output was printed. This ... The Lock Monitor is the same as the Standard Monitor except that it includes additional lock ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
Smaller tables normally require less main memory while their contents are being actively processed during query execution. With ROW_FORMAT=REDUNDANT, CHAR(N) occupies N × the maximum byte length of the character set. With the compact family of rows ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
If the value chosen for performance_schema_max_mutex_classes is too small, no error is reported in the error log and there is no failure at runtime. For example, if a mutex is instrumented in the server source but the server cannot allocate memory ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
(You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The keyword STACKED means to retrieve information from the second diagnostics area, which is available only ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
A query that fails to parse differs from a query that parses but fails due to an error during execution. Consequently, there is no parsing at runtime and the type of each statement is known by the time it executes. The setup_timers table contains a ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-configuration.html
In this case, the server does not acquire the query cache mutex at all, which means that the query cache cannot be enabled at runtime and there is reduced overhead in query execution. Note You can set the maximum size that can be specified for the ...For example, a client can disable use of the query cache for its own queries like this: mysql> SET SESSION query_cache_type = OFF; If you set query_cache_type at server startup (rather than at runtime with a SET statement), only the numeric values are ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
Time The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. SHOW [FULL] PROCESSLIST ...For a comparison of this statement with other sources, see Sources of Process ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
For an event, an error occurs at event execution time if the account does not exist. Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that ...