Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-snapshot-method.html
If you are not using InnoDB tables, you can get a snapshot of the system from a source without shutting down the server as described in the following steps: Acquire a read lock and get the source's status. Use MySQL Server's clone plugin to transfer ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/9.7/en/select-into.html
Support is provided for periodic synchronization of output files written to by SELECT INTO OUTFILE and SELECT INTO DUMPFILE, enabled by setting the select_into_disk_sync server system variable introduced in that version. The character_set_filesystem ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
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 ...
https://dev.mysql.com/doc/connector-j/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 ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-javascript-shell.html
Start MySQL Shell After you have installed and started MySQL server, connect MySQL Shell to the server instance. You need to know the address of the MySQL server instance you plan to connect to. To be able to use the instance as a Document Store, ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-shell.html
Start MySQL Shell After you have installed and started MySQL server, connect MySQL Shell to the server instance. You need to know the address of the MySQL server instance you plan to connect to. To be able to use the instance as a Document Store, ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-installation-source-code.html
MySQL Router is part of the MySQL Server source code tree; compiling MySQL Server also compiles MySQL Router. Note MySQL Router source code can be found in the router directory inside the MySQL Server source code repository. Get Source Code To ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/admin-api-routing-guidelines-visualising.html
Unreferenced servers lists topology members not referenced by a route or destination class. Show Detailed Information To view a detailed summary of the Routing Guideline, use the following: rg.show() rg.show() returns the following: The name of the ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-prepared-statement-data-structures.html
For input, buffer_type indicates the type of the variable containing the value to be sent to the server. For output, it indicates the type of the variable into which a value received from the server should be stored. MYSQL_BIND structures are also ... Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a MYSQL_STMT data ...
https://dev.mysql.com/doc/refman/9.7/en/internal-temporary-tables.html
Monitoring Internal Temporary Table Conversion When an internal temporary table is converted from in-memory to on-disk, the server increments system status variables to track these changes: TempTable_count_hit_max_ram is incremented when the ...Note ... In some cases, the server creates internal temporary tables while processing ...