Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can be overridden by using the NO_DIR_IN_CREATE server SQL mode on the replica, which ...This can cause problems if no corresponding directory exists in the replica host file system or if it exists but is not accessible to the replica MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-python-asyncio.html
Reference: [as_completed]: https://docs.python.org/3/library/asyncio-task.html#asyncio.as_completed """ exec_seq = [] database_name = "TABLE_CREATOR" # Create/Setup database # --------------------- # No asynchronous execution is done here. async ...
https://dev.mysql.com/doc/connector-python/en/connector-python-asyncio.html
Reference: [as_completed]: https://docs.python.org/3/library/asyncio-task.html#asyncio.as_completed """ exec_seq = [] database_name = "TABLE_CREATOR" # Create/Setup database # --------------------- # No asynchronous execution is done here. async ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. (For unique indexes, this is always 1.) MySQL uses this ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-tablemetadatalockwaiters-category.html
Lists the Sys Schema Table Metadata Lock Waits metrics and provides a brief description of each. Table 6.41 Sys Schema Table Metadata Lock Waits Metrics NameDescriptionBlocking Account The account of the session that is blocking the current ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cluster-operations.html
The cluster_operations table provides a per-operation (stateful primary key op) view of all activity in the NDB Cluster from the point of view of the local data management (LQH) blocks (see The DBLQH Block). (If the MySQL Server is running with ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-config-params.html
The config_params table is a static table which provides the names and internal ID numbers of and other information about NDB Cluster configuration parameters. This table can also be used in conjunction with the config_values table for obtaining ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dictionary-columns.html
The table provides NDB dictionary information about columns of NDB tables.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-diskpagebuffer.html
The diskpagebuffer table provides statistics about disk page buffer usage by NDB Cluster Disk Data tables. The diskpagebuffer table contains the following columns: node_id The data node ID block_instance Block instance pages_written Number of pages ...If any of these values are less than 95%, this is a strong indicator that the setting for DiskPageBufferMemory needs to be increased in the config.ini ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-index-columns.html
This table provides information about indexes on NDB tables. The columns of the index_columns table are listed here, along with brief descriptions: table_id Unique ID of the NDB table for which the index is defined Name of the database containing ...