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/information-functions.html
The intended use is from within the mysql client, which reports query execution times: mysql> SELECT BENCHMARK(1000000,AES_ENCRYPT('hello','goodbye')); +---------------------------------------------------+ | ...It may be used to time how quickly ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
Max_data_length For MyISAM, Max_data_length is maximum length of the data file. For example, InnoDB stores multiple tables in its system tablespace and the data file timestamp does not apply. Even with file-per-table mode with each InnoDB table in a ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
MAX_DATA_LENGTH For MyISAM, MAX_DATA_LENGTH is maximum length of the data file. For example, InnoDB stores multiple tables in its system tablespace and the data file timestamp does not apply. Even with file-per-table mode with each InnoDB table in a ...The TABLES table has these columns: TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-performance.html
If the LOCK clause specifies a less restrictive level of locking than is permitted for a particular DDL operation, the statement fails with an error. Use this clause if the primary concern is finishing the DDL operation in the shortest amount of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-object-filtering.html
The ENABLED column indicates whether matching objects are monitored, and TIMED indicates whether to collect timing information. Setting the TIMED column affects Performance Schema table contents as described in Section 25.4.1, “Performance Schema ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. You can use it from any program that can send SQL statements to the server to be executed, ...Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
Seconds_Behind_Master This field is an indication of how “late” the replica is: When the replica is actively processing updates, this field shows the difference between the current timestamp on the replica and the original timestamp logged on ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
The index TYPE value indicates the type of index (1 = Clustered Index, 0 = Secondary index). The CLUST_INDEX_SIZE and OTHER_INDEX_SIZE fields report the number of pages on disk that store clustered and secondary indexes for the table, respectively.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.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/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 ...