Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_apply_status is used to keep a record of the operations that have been replicated from the source to the replica. ndb_apply_status is used to record which epoch transactions have been replicated and applied to a replica ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-rolling-restart.html
Features specific to the “new” version must not be used until all management nodes and data nodes have been upgraded. When performing a rolling restart to update the cluster's configuration, you can use the config_generation column of the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-mysql-security-procedures.html
Alternatively, you can start the MySQL server process with --user=mysql on the command line, but it is preferable to use the my.cnf option, since you might forget to use the command-line option and so have mysqld running as another user ... In this ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tde.html
This is indicated by the following message in the data node log: > tail -n2 ndb_5_out.log 2022-08-22 16:08:30 [ndbd] INFO -- Data node configured to have encryption but password not provided 2022-08-22 16:08:31 [ndbd] ALERT -- Node 5: Forced node ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-indexes.html
For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3). Indexes are used to find rows with specific column values quickly. Without an index, MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Safe-updates mode is helpful for cases when you might have issued an UPDATE or DELETE statement but forgotten the WHERE clause indicating which rows to modify. If it is important to have mysql terminate with an error if the connection has been lost, ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
This option is needed if you use the MySQL binary distribution but have the data directory outside of the binary distribution. mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as ...
https://dev.mysql.com/doc/refman/8.4/en/no-matching-rows.html
If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously wrong. Issue a ...Select only those columns that are used in the WHERE ...
https://dev.mysql.com/doc/refman/8.4/en/obtaining-plugin-information.html
Any that have a PLUGIN_LIBRARY value of NULL are built in and cannot be unloaded. Any that have a Library value of NULL are built in and cannot be unloaded. The mysql.plugin table shows which plugins have been registered with INSTALL PLUGIN. There ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
After deleting a large part of a MyISAM or ARCHIVE table, or making many changes to a MyISAM or ARCHIVE table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns). OPTIMIZE TABLE reorganizes the physical storage of ...