Search Results
https://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...ibd2sdi can be used at runtime or while the server is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-indexes.html
Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. If the table has an index for the columns in question, MySQL can quickly determine the position to seek to in the middle of the ... Indexes are used to find rows with specific column values ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_digest_lost The number of digest instances ...This can be nonzero if the value of performance_schema_digests_size is too ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-flush.html
Some forms of the FLUSH statement are not logged because they could cause problems if replicated to a replica: FLUSH LOGS and FLUSH TABLES WITH READ LOCK. The FLUSH TABLES, ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements are written to ...These statements are written to the binary log unless you specify NO_WRITE_TO_BINLOG or its alias ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/monitoring-innodb-cluster.html
memberRole the Member Role as reported by the Group Replication plugin, see the MEMBER_ROLE column of the replication_group_members table. This value is taken from the VIEW_ID column of the replication_group_member_stats table. Note This is only ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-using-a-recommendation-model-items-to-users.html
Alternatively, if you do not want to generate an entire table of recommended users, you can run ML_PREDICT_ROW to specify an item to recommend items for. Set remove_seen to false to repeat existing interactions from the training table. Before You ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-using-a-recommendation-model-users-to-items.html
Alternatively, if you do not want to generate an entire table of recommended items, you can run ML_PREDICT_ROW to specify a user to recommend items for. Set remove_seen to false to repeat existing interactions from the training table. Before You ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-model-export.html
Use the ML_MODEL_EXPORT routine to export a model from the model catalog to a user defined table. ML_MODEL_EXPORT Overview After you run ML_MODEL_EXPORT, the output table has these columns and formats: chunk_id: INT AUTO_INCREMENT PRIMARY KEY ...To ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
An NDB tablespace to be dropped must not contain any data files; in other words, before you can drop an NDB tablespace, you must first drop each of its data files using ALTER TABLESPACE ... mysql> CREATE TABLESPACE myts -> ADD DATAFILE ... DROP ...