Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
This section provides information about techniques for more effective use of mysql and about mysql operational behavior. Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
The server's binary log consists of files containing “events” that describe modifications to database contents. To display their contents in text format, use the mysqlbinlog utility. You can also use mysqlbinlog to display the contents of relay ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. A description of error logging is given ...
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use PAM (Pluggable Authentication Modules) to ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 8.4. This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-examples.html
The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the Performance Schema for this purpose. The discussion here relies on the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be loaded. Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 11.4, “User-Defined Variables”. The user_variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the variable is ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement later. The prepared statement is executed with EXECUTE and released with DEALLOCATE PREPARE.