Search Results
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-yum-repo.html
In this case, MySQL 8.4 is enabled by default, and both MySQL 8.0 and the MySQL Innovation series are available but disabled by default. Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
The LOAD DATA statement loads a data file into a table. The statement can load a file located on the server host, or, if the LOCAL keyword is specified, on the client host. In theory, a patched server could tell the client program to transfer a ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
For example, suppose that you execute these statements: SELECT GET_LOCK('lock1',10); SELECT GET_LOCK('lock2',10); SELECT RELEASE_LOCK('lock2'); SELECT RELEASE_LOCK('lock1'); The second GET_LOCK() acquires a second lock and both RELEASE_LOCK() calls ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
These lock instances can be read locks, write locks, or a mix of both. MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/8.4/en/making-windows-dumps.html
Important The .exe and .pdb files must be an exact match (both version number and MySQL server edition); otherwise, or WinDBG complains while attempting to load the symbols. Program Database files (with suffix pdb) are included in the ZIP Archive ...
https://dev.mysql.com/doc/refman/8.4/en/manual-info.html
This is the Reference Manual for the MySQL Database System, version 8.4, through release 8.4.6. Differences between minor versions of MySQL 8.4 are noted in the present text with reference to release numbers (8.4.x). This manual is not intended for ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
We test mysqld with several memory-leakage detectors (both commercial and Open Source), so there should be no memory leaks. MySQL allocates buffers and caches to improve performance of database operations. The default configuration is designed to ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
Note A known issue exists where indexes on the same columns must be in identical order, in both the MERGE table and the underlying MyISAM table. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode. As a result, the address value for rows within each name group is ...