Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-server.html
As an alternative to the preceding setup, some operating systems also use /etc/rc.local or /etc/init.d/boot.local to start additional services on startup. MySQL distributions on Unix and Unix-like system include a script named mysql.server, which ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
You can also use mysqlbinlog to display the contents of relay log files written by a replica server in a replication setup because relay logs have the same format as binary logs. The server's binary log consists of files containing “events” ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
The TIMED column for the error row in the setup_instruments table is inapplicable because timing information is not collected. Memory instrumentation can be enabled or disabled at startup, or dynamically at runtime by updating the ENABLED column of ... An instrument name consists of a sequence of elements separated by '/' ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-sync-excluded-objects-table.html
This table provides information about NDB database objects which cannot be automatically synchronized between NDB Cluster's dictionary and the MySQL data dictionary. Example information about NDB database objects which cannot be synchronized with ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-pre-filtering.html
Pre-filtering can be applied to either the producer or consumer stage of event processing: To configure pre-filtering at the producer stage, several tables can be used: setup_instruments indicates which instruments are available. An instrument ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
In a non-multisource replication setup there is a single default replication channel. This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has usability ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. Some of the setup tables have columns that can be ... The name of the performance_schema database is lowercase, as are the names of tables within ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. The events_waits_current table contains the most recent event for each thread. Other similar tables contain current events at different levels of the event ...
https://dev.mysql.com/doc/refman/8.4/en/permission-optimization.html
The more complex your privilege setup, the more overhead applies to all SQL statements. Simplifying the privileges established by GRANT statements enables MySQL to reduce permission-checking overhead when clients execute statements. For example, if ...