Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
From a programming point of view, it is the same as if your thread called DriverManager.getConnection() every time it needed a JDBC connection. Many of these resources will be used whether or not the connection is actually doing any useful work! ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
At this point, the plugin is still writing to the current log file, which has been renamed to audit.log.1. For pruning based on rotated log file age, the pruning point is the current time minus the value of audit_log_prune_seconds. The audit log ...
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
The binary log files provide you with the information you need to replicate changes to the database that are made subsequent to the point at which you performed a backup. Therefore, to allow a server to be restored to a point-in-time, binary logging ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
Implicit defaults are defined as follows: For numeric types, the default is 0, with the exception that for integer or floating-point types declared with the AUTO_INCREMENT attribute, the default is the next value in the sequence. Data type ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
1 row in set (0.00 sec) The only delimiter recognized between a date and time part and a fractional seconds part is the decimal point. The fractional part should always be separated from the rest of the time by a decimal point; no other fractional ... Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...
https://dev.mysql.com/doc/refman/8.4/en/entering-queries.html
At this point, it is more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. (Do you see the error in the statement? The string 'Smith is missing ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
Asynchronous replication can work only if the replica is able to continue reading the binary log from the point where it last read events. At that point, the replica is in synchrony with the source and the statement returns. In theory, by using a ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
The remote table that a FEDERATED table points to must exist before you try to access the table through the FEDERATED table. It is possible for one FEDERATED table to point to another, but you must be careful not to create a loop. The following ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-linestring.html
A LineString is a Curve with linear interpolation between points. LineString Properties A LineString has coordinates of segments, defined by each consecutive pair of points. A LineString is a Line if it consists of exactly two points. LineString ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-multipoint.html
A MultiPoint is a geometry collection composed of Point elements. MultiPoint Examples On a world map, a MultiPoint could represent a chain of small islands. On a city map, a MultiPoint could represent the outlets for a ticket office. A MultiPoint ...