Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
Connection pooling is a technique of creating and managing a pool of connections that are ready for use by any thread that needs them. Connection pooling can greatly increase the performance of your Java application, while reducing overall resource ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-load-balancing-failover.html
There are a few convenient shortcuts built into this, for those who want to have some level of control using properties, without writing Java code. Connector/J provides a useful load-balancing implementation for MySQL Cluster or multi-source ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
Spring allows us to add transactions into our code without having to deal directly with the JDBC classes. For that purpose, Spring provides a transaction management package that not only replaces JDBC transaction management, but also enables ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions-and-modifiers.html
They are often used with a GROUP BY clause to group values into subsets. For information about aggregate functions that operate on geometry values, see Section 14.16.12, “Spatial Aggregate Functions”.
https://dev.mysql.com/doc/refman/8.4/en/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/doc/refman/8.4/en/alter-instance.html
This feature is intended only for loading data into a new MySQL instance. ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE BINLOG MASTER KEY | RELOAD TLS [FOR CHANNEL ...
https://dev.mysql.com/doc/refman/8.4/en/apis-perl.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI with MySQL, install the following: The DBI module. Optionally, the DBD ...
https://dev.mysql.com/doc/refman/8.4/en/apis-python.html
The new MySQL Connector/Python component provides an interface to the same Python API, and is built into the MySQL Server and supported by Oracle. MySQLdb is a third-party driver that provides MySQL support for Python, compliant with the Python DB ...
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
Making Delimited-Text File Backups To create a text file containing a table's data, you can use SELECT * INTO OUTFILE 'file_name' FROM tbl_name. Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/binary-installation.html
Obtain and Unpack the Distribution Pick the directory under which you want to unpack the distribution and change location into it. These include generic binary distributions in the form of compressed tar files (files with a .tar.xz extension) for a ...