Search Results
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
If it is important to ensure the same row order with and without LIMIT, include additional columns in the ORDER BY clause to make the order deterministic. If you need only a specified number of rows from a result set, use a LIMIT clause in the ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-debian.html
Oracle provides Debian packages for installing MySQL on Debian or Debian-like Linux systems. The packages are available through two different channels: The MySQL APT Repository. This is the preferred method for installing MySQL on Debian-like ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-native.html
Important Native packages are often several versions behind the currently available release. Many Linux distributions include a version of the MySQL server, client tools, and development components in their native software repositories and can be ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. While held by one session, other sessions cannot obtain a lock of the same name.
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. MySQL distributions provide a locking interface that is accessible at two levels: ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
For users who have access to the .CSV files that contain log table data, the files are easy to import into other programs such as spreadsheets that can process CSV input. MySQL Server provides flexible control over the destination of output written ...
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/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because the data is vulnerable to crashes, hardware issues, or power outages, only use these tables as temporary work areas ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
The size of the buffer pool is important for system performance: InnoDB allocates memory for the entire buffer pool at server startup, using malloc() operations. MySQL allocates buffers and caches to improve performance of database operations. The ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
mysql> INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6) -> ON DUPLICATE KEY UPDATE c=VALUES(a)+VALUES(b); Important This usage is deprecated, and subject to removal in a future release of MySQL. The function return value and type are the same as the ...