Search Results
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 ...row *************************** SCHEMA_NAME: NULL NAME: lg1 TYPE: LOGFILE GROUP REASON: Injected failure *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/perl-support.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI, you must install the DBI module, as well as a DataBase Driver (DBD) module ...You can obtain the necessary modules from http://search.cpan.org for Unix, or by using the ActiveState ppm program on ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
For some distribution types (such as binary distributions on Windows, or RPM and DEB distributions on Linux), the installation process initializes the MySQL data directory, including the mysql system database containing the grant tables. (The data ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
Access privileges for the connection metadata repository table mysql.slave_master_info should be restricted to the database administrator, because it contains the replication user account name and password for connecting to the source. Use a ... A ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-performance.html
Figure 19.3 Using an Additional Replication Source to Improve Performance For this to work, you must configure the MySQL instances as follows: Source 1 is the primary source where all changes and updates are written to the database. The above ... As ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable limitations. Figure 19.1 Using Replication to Improve Performance During ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
The replica does not check whether the databases on the source are compatible with those on the replica; it simply begins reading and executing events from the specified coordinates in the new source's binary log. In a failover situation, all the ...
https://dev.mysql.com/doc/refman/8.4/en/reproducible-test-case.html
The binary log is saved in the MySQL database directory with the name hostname-bin.NNNNNN. FTP the tables and the binary log to our bugs database using the instructions given in Section 1.6, “How to Report Bugs or Problems”. For information ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
This gives anyone with access to the server unrestricted access to all databases. --skip-show-database Command-Line Format --skip-show-database System Variable skip_show_database Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-event.html
It requires the EVENT privilege for the database from which the event is to be shown. Database Collation is the collation of the database with which the event is associated. SHOW CREATE EVENT event_name This statement displays the CREATE EVENT ...