MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 121 to 130 of 137 total results

26.6.2 Partitioning Limitations Relating to Storage Engines

https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-storage-engines.html

When performing an upgrade, tables which are partitioned by KEY must be dumped and reloaded. In MySQL 8.0, partitioning support is not actually provided by the MySQL Server, but rather by a table storage engine's own or native partitioning handler.

29.12.21.8 The threads Table

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html

Examples are internal InnoDB threads, “binlog dump” threads sending information to replicas, and replication I/O and SQL threads. The threads table contains a row for each server thread. Each row contains information about a thread and ...

19.1.3.2 GTID Life Cycle

https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html

This technique is used by mysqlbinlog to generate a dump of the binary log that the client can replay to preserve GTIDs. The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the source. This client ...

19.1.6.3 Replica Server Options and Variables

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

Note that a buffer the size of this value is allocated for each thread that reads from the binary log and relay log files, including dump threads on sources and coordinator threads on replicas. This section explains the server options and system ...

19.4.7 Improving Replication Performance

https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-performance.html

Note that a buffer the size of this value is allocated for each thread that reads from the binary log and relay log files, including dump threads on sources and coordinator threads on replicas. As the number of replicas connecting to a source ...

19.5.3 Upgrading a Replication Topology

https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html

Perform any table repair or rebuilding operations needed to re-create database objects, such as use of REPAIR TABLE or ALTER TABLE, or dumping and reloading tables or triggers. When you upgrade servers that participate in a replication topology, ...

7.1.7 Server Command Options

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

This causes the Bison parser that is used to process SQL statements to dump a parser trace to the server's standard error output. When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, ...

10.3.3 SPATIAL Index Optimization

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

They exist only for backward compatibility (for example, the ability to perform a dump in MySQL 5.7 and restore in MySQL 8.0). MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial ...

Chapter 18 Alternative Storage Engines

https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html

CSV tables let you import or dump data in CSV format, to exchange data with scripts and applications that read and write that same format. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the ...

30.4.4.23 The ps_trace_thread() Procedure

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

Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...

Displaying 121 to 130 of 137 total results