Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
Performance Schema system variables have the following meanings: performance_schema Command-Line Format --performance-schema[={OFF|ON}] System Variable performance_schema Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value ON ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-descriptions.html
These tables have the same structure as the current events tables, but contain more rows. These tables contain information aggregated over groups of events, including those that have been discarded from the history tables. Tables in the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-summary-tables.html
This value is calculated only for timed events because nontimed events have a wait time of NULL. The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables. Section ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-tables.html
events_waits_history: The most recent wait events that have ended per thread. events_waits_history_long: The most recent wait events that have ended globally (across all threads). The Performance Schema instruments waits, which are events that take ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
Most Performance Schema tables have indexes, which gives the optimizer access to execution plans other than full table scans. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has ...
https://dev.mysql.com/doc/refman/8.4/en/perl-installation.html
MySQL Perl support requires that you have installed MySQL client programming support (libraries and header files). If you do not have access rights to install Perl modules in the system directory or if you want to install local Perl modules, the ...
https://dev.mysql.com/doc/refman/8.4/en/permission-optimization.html
Similarly, if you place no resource limits on any accounts, the server does not have to perform resource counting. If you have a very high statement-processing load, consider using a simplified grant structure to reduce permission-checking overhead.
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
A system variable can have a global value that affects server operation as a whole, a session value that affects the current session, or both. To persist system variables, you need not have login access to the MySQL server host or file system access ... The MySQL server maintains system variables that configure its ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-binlog.html
To apply events from the binary log, process mysqlbinlog output using the mysql client: $> mysqlbinlog binlog_files | mysql -u root -p If binary log files have been encrypted, mysqlbinlog cannot read them directly as in the previous example, but can ... This section explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math.html
These features have several implications for numeric operations and provide a high degree of compliance with standard SQL: Precise calculations: For exact-value numbers, calculations do not introduce floating-point errors. MySQL provides support ...