PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
An error in a manually entered setting might not be discovered until much later. SET statements that persist system variables avoid the possibility of malformed settings because settings with syntax errors do not succeed and do not change server ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
If any argument has a longitude or latitude that is out of range, an error occurs: If a longitude value is not in the range (−180, 180], an ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE error occurs (ER_LONGITUDE_OUT_OF_RANGE prior to MySQL 8.0.12). If ... Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
With the IGNORE modifier, the update statement does not abort even if errors occur during the update. Rows updated to values that would cause data conversion errors are updated to the closest valid values instead. (This is because the order in which ... UPDATE is a DML statement that modifies rows in a ...
https://dev.mysql.com/doc/refman/8.0/en/events-status-info.html
INTO var_list statements, if the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. The Event Scheduler writes information about event execution that terminates with an error or warning ...See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-tables.html
Final instrument names correspond to server commands and SQL statements: Server commands correspond to the COM_xxx codes defined in the mysql_com.h header file and processed in sql/sql_parse.cc. Some final instrument names are specific to error ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html
After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application. Important Because X Plugin is not a mandatory plugin, it does not ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
Each plugin_library is the name of a library file that contains plugin code, and each name is the name of a plugin to load. Alternatively, the INSTALL PLUGIN statement causes the server to load the plugin code from the library file at runtime: ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-scaleout.html
Figure 19.1 Using Replication to Improve Performance During Scale-Out If the part of your code that is responsible for database access has been properly abstracted/modularized, converting it to run with a replicated setup should be very smooth and ... You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-table-select.html
mysql-js> db.city.select() +------+------------+-------------+------------+-------------------------+ | ID | Name | CountryCode | District | Info | +------+------------+-------------+------------+-------------------------+ | 1 | Kabul | AFG | Kabol ... You can use the select() method to query for and return records from a table in a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-table-select.html
mysql-py> db.city.select() +------+------------+-------------+------------+-------------------------+ | ID | Name | CountryCode | District | Info | +------+------------+-------------+------------+-------------------------+ | 1 | Kabul | AFG | Kabol ... You can use the select() method to query for and return records from a table in a ...