Search Results
https://dev.mysql.com/doc/refman/8.4/en/install-plugin.html
For maximal compatibility, plugin names should be limited to ASCII letters, digits, and underscore because they are used in C source files, shell command lines, M4 and Bourne shell scripts, and SQL environments. INSTALL PLUGIN loads and initializes ... INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If you need only a specified ...If you combine LIMIT row_count with ORDER BY, MySQL stops sorting as soon as it has found the first row_count rows of the sorted result, rather than sorting the entire ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk.html
myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 15.7.3.2, “CHECK TABLE ... The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-start-phases.html
These phases are the same as those reported in the output from the node_id STATUS command in the management client (see Section 25.6.1, “Commands in the NDB Cluster Management Client”). There are several different startup types and modes, as ...
https://dev.mysql.com/doc/refman/8.4/en/using-system-variables.html
Many system variables are dynamic and can be changed at runtime by using the SET statement. For a description of the privilege requirements for setting and persisting system variables, see Section 7.1.9.1, “System Variable Privileges” Suffixes ...System variables can be set at server startup using options on the command line or in an option ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-2-0.html
Installation and Compilation Notes Bugs Fixed Installation and Compilation Notes The version requirements for the third-party libraries and tools needed for running and building Connector/J have been updated. MySQL Connector/J 9.2.0 supersedes 9.1 ... Version 9.2.0 is a new GA release of MySQL ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location VARCHAR(100), purchase_amount DECIMAL(10, 2), purchase_time DATETIME, target INT ); Insert the sample data to train ... This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly detection model, and an unsupervised anomaly detection model for ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
If the operation does not resume within the allotted time, it aborts and returns an error, and the donor drops the snapshot. This section describes failure handing at different stages of a cloning operation. If the cloning operation is unable to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-flushing.html
For table data stored on SSD, seek time is not a significant factor and you can disable this setting to spread out write operations. Side effects of limiting page flushing during idle periods may include a longer shutdown time following a lengthy ...
https://dev.mysql.com/doc/refman/8.4/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). It also ...