PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-index.html
These two statements are equivalent: SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden indexes that MySQL uses internally and are not accessible by ...
https://dev.mysql.com/doc/refman/8.0/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...Alternatively, add the bin directory to your PATH environment variable ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-encrypted-connections.html
For example, X Plugin can have SSL key, certificate, and certificate authority files that differ from those used for MySQL Server. These variables are described at Section 22.5.6.2, “X Plugin Options and System Variables”. Encryption per ...
https://dev.mysql.com/doc/refman/8.0/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...For ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html
Of chief importance is the number of thread groups in the thread pool, which can be set on server startup using the --thread-pool-size option; this cannot be changed at runtime. The recommendation initial setting for this system variable is the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-hash.html
You should also keep in mind that this expression is evaluated each time a row is inserted or updated (or possibly deleted); this means that very complex expressions may give rise to performance issues, particularly when performing operations (such ...See Section 26.6.1, “Partitioning Keys, Primary Keys, and Unique Keys”, for more ... Partitioning by HASH is used ...
https://dev.mysql.com/doc/refman/8.0/en/table-locking.html
But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily for tables that are queried often and rarely inserted into or updated. For storage engines that use only ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
This is displayed as a DATETIME value, and is NULL if no start date and time are defined for the event. Time zone The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. row ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
For each such row: The SUBPARTITION_NAME, SUBPARTITION_ORDINAL_POSITION, SUBPARTITION_METHOD, PARTITION_EXPRESSION, SUBPARTITION_EXPRESSION, CREATE_TIME, UPDATE_TIME, CHECK_TIME, CHECKSUM, and TABLESPACE_NAME columns are all NULL. UPDATE_TIME The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-worker-table.html
When the Performance Schema is disabled, local timing information is not collected, so the fields showing the start and end timestamps for applied transactions are zero. The start timestamps in this table refer to when the worker started applying ...