Search Results
https://dev.mysql.com/doc/heatwave-aws/en/running-autopilot-index-advisor-using-heatwave-console.html
Recommendation: It is either DROP or CREATE Schema Name Table Name Indexed Columns Reason: Reason for making the recommendation. Reasons for DROP include Unused Index and Duplicate Index, and reason for CREATE is Missing Index. Performance Impact: ... Running Autopilot Index Advisor 11.1 Running Autopilot Index Advisor To run Autopilot Index Advisor, the user must connect to the DB system and have the following MySQL privileges: The EXECUTE privilege on the sys ...
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. Benefits of Connection Pooling The main benefits to connection pooling are: Reduced connection creation time.
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
The downloaded script explicitly creates MyISAM tables, which do not support transactional semantics. What this means is that we can create a Java interface and only use the operations on this interface without any internal knowledge of what the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-applications.html
To create a database such that its tables use a given default character set and collation for data storage, use a CREATE DATABASE statement like this: CREATE DATABASE mydb CHARACTER SET latin1 COLLATE latin1_swedish_ci; Tables created in the ... For ...
https://dev.mysql.com/doc/refman/8.4/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. Note If GTIDs are in use on the server where you create the dump (gtid_mode=ON), by default, mysqldump ...You can then transfer the file to the other machine and feed it as input to the mysql ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
Row Format InnoDB tables are created using the DYNAMIC row format by default. To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE statement. To ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
The SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements also provide information about tables. In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
Modifications occur indirectly when you use account-management statements such as CREATE USER, GRANT, and REVOKE to set up accounts and control the privileges available to each one. password_last_changed is updated by the CREATE USER, ALTER USER, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
If the routine has not been modified since its creation, this value is the same as the CREATED value. SQL_MODE The SQL mode in effect when the routine was created or altered, and under which the routine executes. DEFINER The account named in the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
This column has most of what you see in the Create Table column that SHOW CREATE VIEW produces. Suppose that the original statement was: CREATE VIEW v AS SELECT s2,s1 FROM t WHERE s1 > 5 ORDER BY s1 WITH CHECK OPTION; Then the view definition looks ...You must have the SHOW VIEW privilege to access this ...