Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
The location of all undo tablespace files including user-defined undo tablespaces created using CREATE UNDO TABLESPACE syntax can be determined by querying the Information Schema FILES table: SELECT TABLESPACE_NAME, FILE_NAME FROM ...Default undo ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
The server creates a copy of the file in the directory where it stores temporary files. If you use LOAD DATA on an empty MyISAM table, all nonunique indexes are created in a separate batch (as for REPAIR TABLE). In some extreme cases, you can create ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
Many option files are plain text files, created using any text editor. A “login path” is an option group that permits only certain options: host, user, password, port and socket. It is created by the server upon execution of SET PERSIST or SET ... Most MySQL programs can read startup options from option files (sometimes called configuration ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database ...We solve this by introducing a separate MEM_ROOT object for storing the bind parameters array, which object can be cleared (deallocating the memory) on each call to mysql_stmt_bind_param() or ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/myai-installation-clean-cmdline.html
User and Password --mysql-root-user=username: User name and password for the MySQL root user. --mysql-root-allow-remote-connection: The root user is allowed to connect from hosts other than localhost. If this option is not specified, a random secret ... The MySQL AI Installer can also be run in command-line mode, without invoking the installation ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
If not already done, create an Oracle Cloud Infrastructure (OCI) bucket for storing files that you want to ingest into the vector store. To run the steps in this topic, create an Object Storage bucket with the name demo_bucket. Download the MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-connect-drivermanager.html
try { conn = DriverManager.getConnection("jdbc:mysql://localhost/test?" + "user=minty&password=greatsqldb"); // Do something with the Connection ... } catch (SQLException ex) { // handle any errors System.out.println("SQLException: " + ... When you ...
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-connection-pool.html
Closing the Client object closes all connections it manages, invalidates all Sessions the Client has created, and destroys the managed pool. X DevAPI supports connection pooling, which can reduce overhead for applications that open many connections ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-connect-drivermanager.html
try { conn = DriverManager.getConnection("jdbc:mysql://localhost/test?" + "user=minty&password=greatsqldb"); // Do something with the Connection ... } catch (SQLException ex) { // handle any errors System.out.println("SQLException: " + ... When you ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
This is to prevent the redo log data from being exposed to unauthorized users on the system. Otherwise, the following error is returned: ERROR 3846 (HY000): Redo log archive directory 'directory_path1' is accessible to all OS users Directories ...