MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 311 to 320 of 328 total results

https://dev.mysql.com/doc/refman/8.0/en/show-binlog-events.html

As an alternative to SHOW BINLOG EVENTS, use the mysqlbinlog utility to save the binary log to a text file for later examination and analysis. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary ...

15.7.7.22 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/8.0/en/show-index.html

However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...

7.4.5 The Slow Query Log

https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html

Passwords in statements written to the slow query log are rewritten by the server not to occur literally in plain text. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least ...

2.8.7 MySQL Source-Configuration Options

https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html

The CMake program provides a great deal of control over how you configure a MySQL source distribution. Typically, you do this using options on the CMake command line. For information about options supported by CMake, run either of these commands in ...

14.16.10 Spatial Geohash Functions

https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html

Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. mysql> SET @gh = ST_GeoHash(45,-20,10); mysql> SELECT ST_AsText(ST_PointFromGeoHash(@gh,0)); +---------------------------------------+ | ...Geohash values are strings that contain only characters chosen from ...

15.4.2.6 START REPLICA Statement

https://dev.mysql.com/doc/refman/8.0/en/start-replica.html

However, it is sent in plain text over the connection to the replica server instance. START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | ...

13.3 String Data Types

https://dev.mysql.com/doc/refman/8.0/en/string-types.html

The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 13.7, “Data Type Storage Requirements”. For descriptions of functions that ...

10.2.2.2 Optimizing Subqueries with Materialization

https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html

For extended EXPLAIN output, the text displayed by a following SHOW WARNINGS includes materialize and materialized-subquery. The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution ...

30.4.5.14 The ps_thread_account() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-account.html

Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. Parameters in_thread_id BIGINT UNSIGNED: The thread ID for which to return the account. The value should match the THREAD_ID column from some ...

10.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html

ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT columns; in this case, MySQL cannot optimize the space required based only on the number of rows. The effective ...

Displaying 311 to 320 of 328 total results