Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-overview.html
Note For MySQL instances with a large number of objects, this view might take a long time to execute. This view summarizes the types of objects within each schema. object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restore-cluster.html
Doing this can decrease the time required to restore a large data set, particularly where many indexes were in use. Stop the cluster using stop cluster, then restart it using start cluster with the --initial option, which causes the data node file ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-upgrade.html
indexTooLarge: Check for large indexes which are not supported by MySQL 8.0, or higher. The util.checkForServerUpgrade() function is an upgrade checker utility that enables you to verify whether MySQL server instances are ready for upgrade. You can ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-preparation.html
Ensure that each MySQL server acting as a replication source is assigned a unique server ID, and has binary logging enabled, using the row-based format. Use --ndb-replica-batch-size to set the batch size used for writes on the replica instead of ...
https://dev.mysql.com/doc/internals/en/binary-log-overview.html
It also contains statements that potentially could have updated it (for example, a DELETE which matched no rows), unless row-based logging is used. The binary log also contains information about how long each statement took that updated data. There ... [Some information in this section is derived from Chapter 20, The Binary Log, in the MySQL Reference Manual.] The binary log is a set of log files that contain information about data modifications made to a MySQL server ...
https://dev.mysql.com/doc/internals/en/frm-file-format.html
First, let's create an example table, using the mysql client: mysql> CREATE TABLE table1 (column1 CHAR(5)) ENGINE=MYISAM COMMENT '*'; Query OK, 0 rows affected (0.00 sec) The .frm file associated with table1 can be found in the directory that ...
https://dev.mysql.com/doc/internals/en/support-for-insert.html
All INSERT operations are handled through the [custom-engine.html#custom-engine-api-reference-write_row write_row()] method: int ha_foo::write_row(byte *buf) The *buf parameter contains the row to be inserted in the internal MySQL format. A basic ...
https://dev.mysql.com/doc/internals/en/x-protocol-notices-notices.html
sever-side generated primary keys (like AUTO_INCREMENT) rows-found, rows-matched, rows-affected CURRENT_SCHEMA Sent after statement that changes the current schema like USE ... Note The MySQL C/S provided some of this information via functions: ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-14.html
mysqlx_collection_t *c1 = mysqlx_get_collection(schema, "c1", 1); ulong64_t documents; mysqlx_collection_count(c1, &documents); mysqlx_table_count(): The number of rows in a table without filtering. mysqlx_table_t *t1 = mysqlx_get_table(schema, ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-tablestatistics-category.html
IO Write Number of bytes written to the table data/index files IO Write Latency Latency caused by IO writing to the table data/index files IO Write Requests Number of write requests to the table data/index files Rows Deleted Number of rows deleted ... Lists the Sys Schema Table Statistics metrics and provides a brief description of ...