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/sys-schema-views.html
The sys schema contains many views that summarize Performance Schema tables in various ways. Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix ...
https://dev.mysql.com/doc/refman/8.0/en/update-optimization.html
The speed of the write depends on the amount of data being updated and the number of indexes that are updated. Another way to get fast updates is to delay updates and then do many updates in a row later. Performing multiple updates together is much ... An update statement is optimized like a SELECT query with the additional overhead of a ...For a MyISAM ...
https://dev.mysql.com/doc/refman/8.0/en/verifying-package-integrity.html
After downloading the MySQL package that suits your needs and before attempting to install it, make sure that it is intact and has not been tampered with. If you notice that the MD5 checksum or GPG signatures do not match, first try to download the ...There are three means of integrity checking: MD5 checksums Cryptographic signatures using GnuPG, the GNU Privacy Guard For RPM packages, the built-in RPM integrity verification mechanism The following sections describe how to use these ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-status-variables.html
If compression is used for the connection, this figure comprises compressed message payloads measured before decompression (Mysqlx_bytes_received_compressed_payload), any items in compressed messages that were not compressed such as X Protocol ...
https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html
This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional details. To make sure that you can take advantage of any new capabilities, update your grant ...
https://dev.mysql.com/doc/refman/8.0/en/activestate-perl.html
On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl: Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install it. For example, you might try a setting like this: C:\> set ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-unicode-uca.html
Instead, you begin with an existing “base” collation and describe the new collation in terms of how it differs from the base collation. Table 12.4 MySQL Character Sets Available for User-Defined UCA Collations Character Set Base Collation ...
https://dev.mysql.com/doc/refman/8.0/en/alter-function.html
However, you cannot change the parameters or body of a stored function using this statement; to make such changes, you must drop and re-create the function using DROP FUNCTION and CREATE FUNCTION. ALTER FUNCTION func_name [characteristic ...] ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
This is done because InnoDB and these operating systems cannot drop a table that is in use. If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new ...
https://dev.mysql.com/doc/refman/8.0/en/alter-view.html
This statement requires the CREATE VIEW and DROP privileges for the view, and some privilege for each column referred to in the SELECT statement. ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER ...