Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
*/ C-style comment syntax, with a + character following the /* comment opening sequence. Consider this sequence of statements: SET @saved_val = @@SESSION.var_name; SET @@SESSION.var_name = value; SELECT ... SET @@SESSION.var_name = @saved_val; The ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-standard-monitor.html
The contents include the current log sequence number, how far the log has been flushed to disk, and the position at which InnoDB last took a checkpoint. The Lock Monitor is the same as the Standard Monitor except that it includes additional lock ...
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
Create the directory and go there: $> mkdir bld $> cd bld Configure the build directory. To do this, starting with mysql-src as your current working directory, create the directory build and then go there: $> mkdir build $> cd build Configure the ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
A keyring component or plugin must be loaded early during the server startup sequence so that other components can access it as necessary during their own initialization. The database administrator has the responsibility for creating any manifest ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
20.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for it. If you did not have binary logging enabled when you configured the user credentials on s1, and a remote cloning operation ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
IMPORT TABLE requires the FILE privilege to read the .sdi and table content files, and the CREATE privilege for the table to be created. If necessary, execute this statement to create it: mysql> CREATE SCHEMA hr; At the file system level, copy the ...The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
Let S be a logged statement that does not have an implicit commit, except CREATE TEMPORARY TABLE...SELECT (This includes all "pure DML": INSERT, UPDATE, DELETE, REPLACE, TRUNCATE, SELECT, DO, CALL, EXECUTE, LOAD DATA INFILE, and BINLOG. It also ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-tables.html
You can create the employee table that matches this interface, using the following CREATE TABLE statement, in a MySQL client application such as mysql. ClusterJ's main purpose is to read, write, and update row data in an existing database, rather ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
You can do so by creating tables to hold your data and loading them with the desired information. You can use the test database (if you have access to it) for the examples that follow, but anything you create in that database can be removed by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-collections-operations.html
In MySQL Shell, you can create new collections, get a list of the existing collections in a schema, and remove an existing collection from a schema. The following example creates a collection called flags in the world_x schema. Collection names are ...