Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-connpooling.html
In many situations, such as web applications, there will be a large number of small database transactions. When this is the case, it usually makes sense to create a pool of database connections available for web requests as needed. The difference ...Although MySQL does not spawn an extra process when a connection is made, there is still a small amount of overhead to create and set up the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
To use transactional database access, we will need to change the storage engine of the tables in the world database. First you create a simple interface: public interface Ex3Dao { Integer createCity(String name, String countryCode, String district, ... Spring allows us to add transactions into our code without having to deal directly with the JDBC ...
https://dev.mysql.com/doc/refman/8.4/en/account-names.html
MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. Other grant tables indicate privileges an account has for ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
By default, audit log filter definitions are stored in the mysql system database, and you can display audit filters by querying the mysql.audit_log_filter table. It is possible to use a different database for this purpose, in which case you should ... Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log.html
The log contents include when clients connect and disconnect, and what actions they perform while connected, such as which databases and tables they access. By default, MySQL Enterprise Audit uses tables in the mysql system database for persistent ... Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
When replica_parallel_type or replica_parallel_type is set to DATABASE, all the databases affected by the transaction are mapped before the transaction is scheduled. The use of binary log transaction compression with the DATABASE policy can reduce ... MySQL supports binary log transaction compression; when this is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-examples.html
Example 4: Database, Table, and Column Definition CREATE DATABASE d1 DEFAULT CHARACTER SET latin2 COLLATE latin2_czech_cs; USE d1; CREATE TABLE t1 ( c1 CHAR(10) ); We create a column without specifying its character set and collation. In this ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...