Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-statementprocessing-category.html
Big Selects Enabled If set to 0, MySQL aborts SELECT statements that are likely to take a very long time to execute (that is, statements for which the optimizer estimates that the number of examined rows exceeds the value of max_join_size). This ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
| | Expected time for applying all Index creation suggestions: 25 s | | | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ To ... To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output that includes the following information: New indexes to ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-maintenance.html
The maintenance window start day and time can be viewed on the DB System Details page in the MySQL HeatWave on AWS Console. Maintenance 22 Maintenance This section describes the maintenance of DB Systems and MySQL HeatWave. Essential patching and ...Maintenance is initiated during the maintenance window defined when creating a DB ...
https://dev.mysql.com/doc/heatwave-aws/en/running-autopilot-index-advisor-using-heatwave-console.html
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 schema. Perform the following ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-known-issues-limitations.html
The following are some known issues and limitations for MySQL Connector/J: When Connector/J retrieves timestamps for a daylight saving time (DST) switch day using the getTimeStamp() method on the result set, some of the returned values might be ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
To improve the start up time of the mysql client and to updating statistics, you can turn off auto-rehash using the --disable-auto-rehash option. Starting a mysql client with the --auto-rehash option enabled, which is the default. InnoDB detects ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. (For unique indexes, this is always 1.) MySQL uses this ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
This can simply be the name of a column whose type is one of MySQL's integer types. You should also keep in mind that this expression is evaluated each time a row is inserted or updated (or possibly deleted); this means that very complex expressions ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
MySQL uses table locking (instead of page, row, or column locking) for all storage engines except InnoDB. But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-datetime-fractional.html
For fractional second handling in MySQL 5.6.4 and higher, see Fractional Seconds in Time Values. In your C# or Visual Basic code, refer to the Millisecond member to retrieve the fractional second value from the MySqlDateTime object returned by the ... MySQL Connector/NET supports the fractional seconds feature in MySQL, where the fractional seconds part of temporal values is preserved in data stored and retrieved through ...