Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
The default is 86400 seconds (24 hours), but the time period can be extended to as much as one year. Some INFORMATION_SCHEMA tables contain columns that provide table statistics: STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-next-key-locking.html
For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, the row is a “phantom” row. The so-called phantom problem occurs within a transaction when the same query produces different ...
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 ...
https://dev.mysql.com/doc/refman/8.4/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. If a latitude value is not in the range [−90, 90], ... Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text ...
https://dev.mysql.com/doc/workbench/en/wb-accessibility.html
MySQL Workbench includes options to improve user accessibility that you can select from the Workbench Preferences dialog. To open the dialog, click Edit and then Preferences from the menu. Fonts Modeling fonts are adjustable from the Appearance ...
https://dev.mysql.com/doc/workbench/en/wb-eer-diagram-editor.html
Enhanced Entity-Relationship (EER) diagrams are created by double-clicking Add Diagram in the Model Editor. You may create any number of EER diagrams just as you may create any number of physical schemas (databases). Clicking an EER diagram tab ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-partitioning-tab.html
To enable partitioning for your table, check the Enable Partitioning check box. This enables the partitioning options (shown in the figure that follows). Figure 8.18 The Partitioning Tab The Partition By pop-up menu displays the types of partitions ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-dsn.html
A Data Source Name associates the configuration parameters for communicating with a specific database. Generally, a DSN consists of the following parameters: Name Host Name Database Name Login Password In addition, different ODBC drivers, including ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn.html
A Data Source Name associates the configuration parameters for communicating with a specific database. Generally, a DSN consists of the following parameters: Name Host Name Database Name Login Password In addition, different ODBC drivers, including ...
https://dev.mysql.com/doc/internals/en/compression.html
Compression is its own protocol, is transparent to the rest of the MySQL protocol and compresses a stream of bytes (which may even be a part of several Protocol::Packet). It is enabled if the server announces CLIENT_COMPRESS in its ...