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/solaris-installation-pkg.html
(default: all) [?,??,q]: The PKG installer installs all of the files and tools needed, and then initializes your database if one does not exist. To upgrade when using the Solaris package file format, you must remove the existing installation before ...To use this package, download the corresponding mysql-VERSION-solaris11-PLATFORM.pkg.gz file, then uncompress ... You can install ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-transitioning.html
(Any option file changes that must be made are performed in the next step.) Adjust any references to the plugin system and status variables to refer to the corresponding component system and status variables. Suppose that previously you had ...In ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-maintenance.html
OPTIMIZE PARTITION to reclaim any unused space and to defragment the partition data file. Some MySQL storage engines, including InnoDB, do not support per-partition optimization; in these cases, ALTER TABLE ... Example: ALTER TABLE t1 REPAIR ... A ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
If that is not the case, a GET STACKED DIAGNOSTICS when handler not active error occurs. This instance of GET DIAGNOSTICS assigns the SQLSTATE value and error message to the user variables @p3 and @p4: GET DIAGNOSTICS CONDITION 1 @p3 = ...(You can ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/8.0/en/static-format.html
It is also the fastest of the on-disk formats due to the ease with which rows in the data file can be found on disk: To look up a row based on a row number in the index, multiply the row number by the row length to calculate the row position. The ...
https://dev.mysql.com/doc/refman/8.0/en/history.html
We started out with the intention of using the mSQL database system to connect to our tables using our own fast low-level (ISAM) routines. This resulted in a new SQL interface to our database but with almost the same API interface as mSQL. However, ...This API was designed to enable third-party code that was written for use with mSQL to be ported easily for use with ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
When MySQL retrieves any value from a row, it reads a data block containing all the columns of that row (and possibly other adjacent rows). Keeping each row small, with only the most frequently used columns, allows more rows to fit in each data ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-expressions.html
In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or integer), a number is inserted with its exact value if it is within the column range. (See Section 7.1.11, “Server SQL Modes”.) The following discussion mentions ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-memory-tables.html
Benchmark your application against equivalent InnoDB or MyISAM tables under a realistic workload, to confirm that any additional performance is worth the risk of losing data, or the overhead of copying data from a disk-based table at application ...
https://dev.mysql.com/doc/refman/8.0/en/server-plugins.html
Clone permits cloning InnoDB data from a local or remote MySQL server instance. Plugins can be loaded at server startup, or loaded and unloaded at runtime without restarting the server. The plugins supported by this interface include, but are not ...