Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-table-handles-table.html
It is autosized by default; to configure the table size, set the performance_schema_max_table_handles system variable at server startup. This information shows which table handles the server has open, how they are locked, and by which sessions. The ...
https://dev.mysql.com/doc/refman/9.7/en/pluggable-storage.html
The shared library must be located in the MySQL server plugin directory, the location of which is given by the plugin_dir system variable. MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and ...Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared library must be loaded into MySQL using the INSTALL PLUGIN ...
https://dev.mysql.com/doc/refman/9.7/en/problems-with-mysql-sock.html
The default location for the Unix socket file that the server uses for communication with local clients is /tmp/mysql.sock. If the socket file is located in such a directory on your system, this might cause problems. Another approach is to change ...(For some distribution formats, the directory might be different, such as /var/lib/mysql for RPMs.) On some versions of Unix, anyone can delete files in the /tmp directory or other similar directories used for temporary ...
https://dev.mysql.com/doc/refman/9.7/en/replication-administration-status.html
The SOURCE_HEARTBEAT_PERIOD setting on the source (set by CHANGE REPLICATION SOURCE TO) specifies the frequency of the heartbeat, which defaults to half of the connection timeout interval for the replica (specified by the system variable ...The SHOW ... The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...
https://dev.mysql.com/doc/refman/9.7/en/show-binary-log-status.html
This is the same as the value for the gtid_executed system variable on this server, as well as the value for Executed_Gtid_Set in the output of SHOW REPLICA STATUS on this server. SHOW BINARY LOG STATUS This statement provides status information ...
https://dev.mysql.com/doc/refman/9.7/en/show-relaylog-events.html
Some events relating to the setting of user and system variables are not included in the output from SHOW RELAYLOG EVENTS. Note Issuing a SHOW RELAYLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the ... SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL channel Shows the events in the relay log of a ...
https://dev.mysql.com/doc/refman/9.7/en/program-options.html
It describes a handy technique that uses such variables to specify the TCP/IP port number and Unix socket file for the server and for client programs. List the options in environment variables (see Section 6.2.9, “Setting Environment Variables”). In practice, option files are used more commonly for this purpose, but Section 7.8.3, “Running Multiple MySQL Instances on Unix”, discusses one situation in which environment variables can be very ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates.html
When a variable lookup occurs, the system checks the data dictionary associated with the current section. The MySQL Workbench DBDoc Model Reporting system is based on the Google Template System. This discussion does not attempt to explain the Google ... This section provides an overview of creating and modifying DBDoc Model Reporting templates, as used by MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-understanding-consistency-guarantees.html
In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an eventual consistency system. The events that relate to the consistency of a system can be split into control ...This ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-show-tables.html
By default, this includes not only both user-created tables and NDB system tables, but NDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as well. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer ... ndb_show_tables displays a list of all NDB database objects in the ...