Search Results
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
The primary key for the server_cost table is the cost_name column, so it is not possible to create multiple entries for any cost estimate. The server recognizes these cost_name values for the server_cost table: disk_temptable_create_cost, ... To ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-configuring-iam-policies-endpoint.html
Configuring IAM Policies for Endpoints for a Query PrivateLink 6.1.2 Configuring IAM Policies for Endpoints for a Query PrivateLink Subsequent steps for the deployment of a Query PrivateLink requires the abilities to create and delete VPC endpoints ...This section helps to ensure that the desired principals in your AWS Account have the permissions for those ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-load-data.html
If a PRIVILEGE_CHECKS_USER account has been used to help secure the replication channel (see Section 19.3.3, “Replication Privilege Checks”), it is strongly recommended that you log LOAD DATA operations using row-based binary logging ...If you ... LOAD DATA is considered unsafe for statement-based logging (see Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-deploying-sandbox.html
We'll use bootstrapping (using --bootstrap), and create a self-contained MySQL Router installation using --directory. Test a MySQL Router installation by setting up a Router sandbox with InnoDB Cluster. In this case, Router acts as an intermediate ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling.html
Model-driven database design is an efficient methodology for creating valid and well-performing databases, while providing the flexibility to respond to evolving data requirements. MySQL Workbench provides extensive capabilities for creating and ...
https://dev.mysql.com/doc/workbench/en/wb-generating-sql.html
MySQL Workbench can be used to generate SQL, most typically as either INSERT statements or SELECT statements. The following common methods are for generating SQL statements in MySQL Workbench. Note All of the MySQL Workbench Export options include ...
https://dev.mysql.com/doc/workbench/en/wb-importing-sql-script.html
Open MySQL Workbench, select the models view from the sidebar in the home screen, click (>) next to Models, and then click Reverse Engineer MySQL Create Script. If the file was successfully imported, the application's status bar reads, Import MySQL ... For this tutorial, use the sakila database script, which you can find by visiting the https://dev.mysql.com/doc/index-other.html ...
https://dev.mysql.com/doc/connectors/en/connector-j-server-authentication.html
If the truststore file does not already exist, a new one will be created; otherwise the certificate will be added to the existing file. The next step is to configure Java or Connector/J to read the truststore you just created or modified. Setting ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-connpooling.html
When this is the case, it usually makes sense to create a pool of database connections available for web requests as needed. Although MySQL does not spawn an extra process when a connection is made, there is still a small amount of overhead to ...