Search Results
https://dev.mysql.com/doc/refman/8.4/en/compressed-format.html
Compressed tables have the following characteristics: Compressed tables take very little disk space. The header for a row takes up one to three bytes depending on the biggest row in the table. Note While a compressed table is read only, and you ...
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-programs-ndb-delete-all.html
In some cases, this can be much faster than DELETE or even TRUNCATE TABLE. Usage ndb_delete_all -c connection_string tbl_name -d db_name This deletes all rows from the table named tbl_name in the database named db_name. Options that can be used with ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/internals/en/delete-table.html
Synopsis virtual int delete_table ( name); const char * name ; Description This is the delete_table method. By the time delete_table() has been called all opened references to this table will have been closed (and your globally shared references ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-how-to-import-onnx.html
Import model as a string: For smaller models, you can copy the encoded string and paste it into a session variable or temporary table column. Import model directly from a table (available as of MySQL 9.0.0): For larger models, you can load the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema.html
This section provides information and usage examples for InnoDB INFORMATION_SCHEMA tables. InnoDB INFORMATION_SCHEMA tables provide metadata, status information, and statistics about various aspects of the InnoDB storage engine. You can view a list ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dict-obj-info.html
The dict_obj_info table provides information about NDB data dictionary (DICT) objects such as tables and indexes. (The dict_obj_types table can be queried for a list of all the types.) This information includes the object's type, state, parent ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ps-tables.html
Thread names are shown in the name column of the threads and setup_threads tables using the format prefix/plugin_name/thread_name. Using the thread ID or OS thread ID for a given thread in the threads or setup_threads table, it is possible to obtain ... NDB provides information in the MySQL Performance Schema about ndbcluster plugin threads and instrumenting for transaction batch ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-full-table-scans.html
These views display normalized statements that have done full table scans. The statements_with_full_table_scans and x$statements_with_full_table_scans views have these columns: query The normalized statement string. no_index_used_count The total ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-temp-tables.html
These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of in-memory temporary tables used. The statements_with_temp_tables and ...db The default database for the statement, or NULL if there is ...