Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
You can get a fresher snapshot for your queries by committing the current transaction and after that issuing new queries. A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time.
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
Enabling innodb_stats_on_metadata may reduce access speed for schemas that have a large number of tables or indexes, and reduce stability of execution plans for queries that involve InnoDB tables. See Section 10.2.1.23, “Avoiding Full Table ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-mysql-memory-use.html
In this example, memory instrument data is queried in the Performance Schema memory_summary_global_by_event_name table, which summarizes data by EVENT_NAME. The following example demonstrates how to use Performance Schema and sys schema to monitor ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-tables.html
The pet table keeps track of which pets you have. If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-sql-statements.html
However, you can use LIKE to filter queries against the Information Schema ENGINES table, as discussed in the next item. This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
MySQL Configurator supports GUI (default) and CLI (by passing in --console) modes using the mysql_configurator.exe executable. Note MySQL Configurator CLI functionality was added in MySQL Configurator 9.2.0. Executing MySQL Configurator requires a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Queries can be displayed vertically by terminating the query with \G instead of a semicolon. This section provides information about techniques for more effective use of mysql and about mysql operational behavior. Input-Line Editing Disabling ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...