PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-threadstat.html
The threadstat table provides a rough snapshot of statistics for threads running in the NDB kernel. Since this table contains counts taken at a given point in time, for best results it is necessary to query this table periodically and store the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-truncate.html
TRUNCATE TABLE is normally regarded as a DML statement, and so would be expected to be logged and replicated using row-based format when the binary logging mode is ROW or MIXED. However this caused issues when logging or replicating, in STATEMENT ...
https://dev.mysql.com/doc/refman/8.0/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...With ICP enabled, and if parts of the WHERE condition can be evaluated by using only columns from the index, the MySQL server pushes this part of the WHERE condition down to the storage ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-troubleshoot.html
loose-daemon_memcached_option='-c 64' To troubleshoot problems where the memcached daemon is unable to store or retrieve InnoDB table data, encode the -vvv memcached option in the daemon_memcached_option configuration parameter in the MySQL ... This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-limits.html
Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is with other storage engines. Instead, the following rules hold true: A DELETE statement on an NDB table makes the memory formerly used by ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
The instructions just given are subject to the limitations of CREATE TABLE ... If a table definition includes any of those characteristics, create t2 using a CREATE TABLE statement that is identical to the one used to create t1, but with the ...(Bug ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Are stored procedures and functions created on a replication source server replicated to a replica? A.4.24. You can manage stored procedures with CREATE [FUNCTION|PROCEDURE], ALTER [FUNCTION|PROCEDURE], DROP [FUNCTION|PROCEDURE], and SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-files.html
The files table is empty if no disk data objects have been created in NDB. See Section 25.6.11.1, “NDB Cluster Disk Data Objects”, for more information.
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html
You might create additional secondary indexes on tables that are frequently used to generate reports using SQL. If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of data.
https://dev.mysql.com/doc/refman/8.0/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...