Search Results
https://dev.mysql.com/doc/refman/9.7/en/making-trace-files.html
If the mysqld server does not start or it crashes easily, you can try to create a trace file to find the problem. (On Windows, the debugging server is named mysqld-debug rather than mysqld.) Start the mysqld server with a trace log in ...To do ...
https://dev.mysql.com/doc/refman/9.7/en/monitor-innodb-mutex-waits-performance-schema.html
When two or more threads executing in the server need to access the same resource, the threads compete against each other. After adding the performance-schema-instrument rules to your configuration file, restart the server. A mutex is a ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-table-maintenance.html
myisamchk operations that affect indexes can cause MyISAM FULLTEXT indexes to be rebuilt with full-text parameters that are incompatible with the values used by the MySQL server. One advantage of these statements over myisamchk is that the server ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-enterprise-audit.html
MySQL Enterprise Edition includes MySQL Enterprise Audit, implemented using a server plugin. MySQL Enterprise Audit uses the open MySQL Audit API to enable standard, policy-based monitoring and logging of connection and query activity executed on ...Designed to meet the Oracle audit specification, MySQL Enterprise Audit provides an out of box, easy to use auditing and compliance solution for applications that are governed by both internal and external regulatory ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-enterprise-thread-pool.html
MySQL Enterprise Edition includes MySQL Enterprise Thread Pool, implemented using a server plugin. The default thread-handling model in MySQL Server executes statements using one thread per client connection. As more clients connect to the server ...In MySQL Enterprise Edition, a thread pool plugin provides an alternative thread-handling model designed to reduce overhead and improve ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-innodb-cluster-introduction.html
For more information about MySQL NDB Cluster, see Chapter 25, MySQL NDB Cluster 9.7 and Section 25.2.6, “MySQL Server Using InnoDB Compared with NDB Cluster”. An InnoDB Cluster consists of at least three MySQL Server instances, and it provides ... This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to enable you to deploy and administer a complete integrated high availability solution for ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-innodb-replicaset-introduction.html
An InnoDB ReplicaSet consists of at least two MySQL Server instances, and it provides all of the MySQL Replication features you are familiar with, such as read scale-out and data security. MySQL Server, and Chapter 19, Replication, which enables a ... This chapter introduces MySQL InnoDB ReplicaSet, which combines MySQL technologies to enable you to deploy and administer Chapter 19, ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog-hexdump.html
Master ID: The server ID of the replication source server that created the event. For more information about binary log format, see MySQL Internals: The Binary Log. In the example shown, '9d fc 5c 43' is the representation of '051024 17:24:13' in ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-consumer-configurations.html
No Instrumentation Global Instrumentation Only Global and Thread Instrumentation Only Global, Thread, and Current-Event Instrumentation Global, Thread, Current-Event, and Event-History instrumentation No Instrumentation Server configuration state: ... The consumer settings in the setup_consumers table form a hierarchy from higher levels to ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-error-summary-tables.html
The Performance Schema maintains summary tables for aggregating statistical information about server errors (and warnings). For a list of server errors, see Server Error Message Reference. For example, if MySQL Server errors lie in the range from M ...Collection of error information is controlled by the error instrument, which is enabled by ...