PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-native.html
Note Before installing, make sure that you update your apt-get index files to ensure you are downloading the latest available version. Many Linux distributions include a version of the MySQL server, client tools, and development components in their ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
Use OPTIMIZE TABLE in these cases, depending on the type of table: After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. After ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-json.html
Before MySQL 8.0, an update to a JSON column was always written to the binary log as the complete document. In MySQL 8.0, it is possible to log partial updates to JSON documents (see Partial Updates of JSON Values), which is more efficient. JSON ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
The block_encryption_mode system variable controls the mode for block-based encryption algorithms. Its default value is aes-128-ecb, which signifies encryption using a key length of 128 bits and ECB mode. The optional init_vector argument is used to ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-synchronization.html
It blocks until the replica has read and applied all updates up to the specified position in the source's binary log. On a multithreaded replica, the function waits until expiry of the limit set by the replica_checkpoint_group, ... The functions ...
https://dev.mysql.com/doc/refman/8.0/en/password-security-user.html
To keep this file safe, use a restrictive access mode, the same way as described earlier for the .my.cnf file. In short, the safest methods are to have the client program prompt for the password or to specify the password in a properly protected ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Can a stored procedure call a trigger? A stored procedure can execute an SQL statement, such as an UPDATE, that causes a trigger to activate. Finally, nontransactional tables for which errors occur during large DML actions (such as bulk inserts) may ...Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-close.html
The counter works as follows: The first time a table is updated in MySQL, a counter in the header of the index files is incremented. When the last instance of a table is closed (because a FLUSH TABLES operation was performed or because there is no ... Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
An exclusive (X) lock permits the transaction that holds the lock to update or delete a row. Transaction data for an intention lock appears similar to the following in SHOW ENGINE INNODB STATUS and InnoDB monitor output: TABLE LOCK table `test`.`t` ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html
JSON_ARRAY_INSERT(json_doc, path, val[, path, val] ...) Updates a JSON document, inserting into an array within the document and returning the modified document. In MySQL 8.0.4, the optimizer can perform a partial, in-place update of a JSON column ... The functions in this section modify JSON values and return the ...