PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-unused-indexes.html
These views display indexes for which there are no events, which indicates that they are not being used. This view is most useful when the server has been up and processing long enough that its workload is representative. Otherwise, presence of an ...
https://dev.mysql.com/doc/refman/5.7/en/sys-version.html
For example, use the VERSION() function to retrieve the MySQL server version. This view provides the current sys schema and MySQL server versions. Note As of MySQL 5.7.28, this view is deprecated and subject to removal in a future MySQL version.
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-information-schema-tables.html
The following sections describe the INFORMATION_SCHEMA tables associated with the thread pool plugin (see Section 5.5.3, “MySQL Enterprise Thread Pool”). They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information ...Thus, the MySQL server holds the mutex of the thread group while producing the ...
https://dev.mysql.com/doc/refman/5.7/en/update-optimization.html
Performing multiple updates together is much quicker than doing one at a time if you lock the table. For a MyISAM table that uses dynamic row format, updating a row to a longer total length may split the row. An update statement is optimized like a ...
https://dev.mysql.com/doc/refman/5.7/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. There are three means of integrity checking: MD5 checksums Cryptographic signatures using ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-locally.html
For more information on security settings, see Section 17.6, “Group Replication Security”. For example: [mysqld] # server configuration datadir=<full_path_to_data>/data/s1 basedir=<full_path_to_bin>/mysql-8.0/ port=24801 ...It is also possible ... The most common way to deploy Group Replication is using multiple server instances, to provide high ...
https://dev.mysql.com/doc/refman/5.7/en/help.html
Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, “Server-Side Help Support”). The following descriptions indicate the forms that the result set can take. The ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
For example, a system view named GEOMETRY_COLUMNS contains a description of geometry columns, one row for each geometry column in the database. The Open Geospatial Consortium publishes the OpenGIS® Implementation Standard for Geographic information ... The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications that manage spatial ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-update.html
The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. UPDATE t1 SET col1 = col1 + 1, col2 = col1; . If you access a column from the table to be updated in an expression, UPDATE ...
https://dev.mysql.com/doc/refman/5.7/en/constraints.html
Individual clients can set the SQL mode at runtime, which enables each client to select the behavior most appropriate for its requirements. We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which ... MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do ...