Search Results
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-tablestats-table.html
InnoDB tables are represented in this view if they have been opened since the last server restart and have not aged out of the table cache. The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB tables. This data ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-statistics-estimation.html
Instead, statistics are stored in memory, and are lost when the server is shut down. Whatever value of innodb_stats_transient_sample_pages works best for a system, set the option and leave it at that value. Optimizer statistics are not persisted to ...
https://dev.mysql.com/doc/refman/9.7/en/merge-table-advantages.html
If 10 clients are using a MERGE table that maps to 10 tables, the server uses (10 × 10) + 10 file descriptors. MERGE tables can help you solve the following problems: Easily manage a set of log tables. For example, you can put data from different ...
https://dev.mysql.com/doc/refman/9.7/en/myisamchk-table-info.html
If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it runs. To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-connection-tables.html
When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-errors.html
This may be helpful when performing an upgrade or when migrating to a system or application that uses administration tables to which the inbound replication user does not have access. If a statement produces the same error (identical error code) on ...
https://dev.mysql.com/doc/refman/9.7/en/replication-howto-slaveinit.html
To do this, on the replica, execute the following CHANGE REPLICATION SOURCE TO statement, replacing the option values with the actual values relevant to your system: mysql> CHANGE REPLICATION SOURCE TO -> SOURCE_HOST='source_host_name', -> ... To ...
https://dev.mysql.com/doc/refman/9.7/en/set-default-role.html
For each user named immediately after the TO keyword, this statement defines which roles become active when the user connects to the server and authenticates, or when the user executes the SET ROLE DEFAULT statement during a session. SET DEFAULT ...
https://dev.mysql.com/doc/refman/9.7/en/show-table-status.html
For example, InnoDB stores multiple tables in its system tablespace and the data file timestamp does not apply. Timestamps are not persisted when the server is restarted or when the table is evicted from the InnoDB data dictionary cache. SHOW TABLE ...