Search Results
https://dev.mysql.com/doc/refman/8.4/en/commit.html
The READ ONLY restriction prevents the transaction from modifying or locking both transactional and nontransactional tables that are visible to other transactions; the transaction can still modify or lock temporary tables. It is not permitted to ...
https://dev.mysql.com/doc/refman/8.4/en/communication-errors.html
Use of Ethernet protocol with Linux, both half and full duplex. Switch the duplex mode for both your network card and hub/switch to either full duplex or to half duplex and test the results to determine the best setting. If connection problems ...
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/8.4/en/connectors-apis.html
Both Connectors and the APIs enable you to connect and execute MySQL statements from another language or environment, including ODBC, Java (JDBC), C++, Python, Node.js, PHP, Perl, Ruby, and C. This is the primary method used to connect to an ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
The InnoDB buffer pool caches both table data and index data, speeding up lookups for queries and keeping query results in memory for reuse. Whether you convert the MyISAM table directly or create a cloned InnoDB table, make sure that you have ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
USING HASH prevents the creation of an ordered index; otherwise, creating a unique index or primary key on an NDB table automatically results in the creation of both an ordered index and a hash index, each of which indexes the same set of columns.
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
You may optionally follow either or both of these with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
Columns named in both parts or only in the SELECT part come after that. For storage engines that support both atomic DDL and foreign key constraints, creation of foreign keys is not permitted in CREATE TABLE ... You can create one table from ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
For example, an INSERT trigger activates not only for INSERT statements but also LOAD DATA statements because both statements insert rows into a table. syntax: a BEFORE INSERT trigger activates for every row, followed by either an AFTER INSERT ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-files-using-openssl.html
The first two examples are intended for use on Unix and both use the openssl command that is part of OpenSSL. (The CA certificate, if used, must be the same on both sides.) server-cert.pem, server-key.pem: Use these to set the ssl_cert and ssl_key ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...