Search Results
https://dev.mysql.com/doc/refman/8.4/en/changing-mysql-user.html
On Linux, for installations performed using a MySQL repository or RPM packages, the MySQL server mysqld should be started by the local mysql operating system user. To start the server as the given user automatically at system startup time, specify ... On Windows, you can run the server as a Windows service using a normal user ...If directories or files within the MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
Migration Wizard: Executes the database migration wizard for most any database, and is meant to migrate tables and data from supported database systems to your MySQL server. 9.1.1.1.6 The Database Menu This menu features actions against the ... Some ...
HeatWave on AWS :: 3.1.2.1.3 MySQL Versions Deprecation and Removal Policy in MySQL HeatWave Service
https://dev.mysql.com/doc/heatwave-aws/en/mysql-versions-deprecation.html
To update the MySQL Server version of a DB system, see Upgrade MySQL Version. When you are running a deprecated version of MySQL Server on your DB System, the MySQL version on the Details page of your DB System is marked with the Deprecated label.
https://dev.mysql.com/doc/refman/8.4/en/myisam-start.html
Automatic recovery is activated if you start mysqld with the myisam_recover_options system variable set. In this case, when the server opens a MyISAM table, it checks whether the table is marked as crashed or whether the open count variable for the ...Note If you do this, you should not access MyISAM tables from another program (such as from another MySQL server or with myisamchk) when the tables are in ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
Using Connection Pooling with Connector/J The concept of connection pooling in JDBC has been standardized through the JDBC 2.0 Optional interfaces, and all major application servers have implementations of these APIs that work with MySQL Connector/J. Generally, you configure a connection pool in your application server configuration files, and access it through the Java Naming and Directory Interface ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
Using Connection Pooling with Connector/J The concept of connection pooling in JDBC has been standardized through the JDBC 2.0 Optional interfaces, and all major application servers have implementations of these APIs that work with MySQL Connector/J. Generally, you configure a connection pool in your application server configuration files, and access it through the Java Naming and Directory Interface ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-processlist-table.html
A value of system user refers to a nonclient thread spawned by the server to handle tasks internally, for example, a delayed-row handler thread or an I/O or SQL thread used on replica hosts. The value of this column corresponds to the COM_xxx ...The ... Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-high-availability-and-clustering.html
Alternatively, as a last option, investigate setting the MySQL server variable 'wait_timeout' to a high value, rather than the default of 8 hours. Between cycles, the driver will pause for 250 ms if no servers are available. Setting this property to ... autoReconnect Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect before the next query issued on the connection in a new ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-security.html
There is also the Secure Deployment Guide, which provides procedures for deploying a generic binary distribution of MySQL Enterprise Edition Server with features for managing the security of your MySQL installation. For information about the ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
Connection The isClosed() method does not ping the server to determine if it is available. PreparedStatement Two variants of prepared statements are implemented by Connector/J, the client-side and the server-side prepared statements. Server-side ...