Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-savepoints.html
For example, consider the following statements with no explicit BEGIN, session.startTransaction() or similar call: session.setSavepoint('testsavepoint'); session.releaseSavepoint('testsavepoint'); If autocommit mode is enabled on the server, these ...By setting savepoints within a transaction, you can later use the rollback functionality to undo any statements issued after setting the ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
The files must be located in the directory named by the plugin_dir system variable. To be usable by the server, the plugin library files must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). A MySQL ...The following tables show the plugin and library file names for simple and SASL-based LDAP ... Note LDAP ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-visual-explain-dbt3.html
It uses the DBT-3 database and begins with the following simple query example. SELECT * FROM orders WHERE YEAR(o_orderdate) = 1992 AND MONTH(o_orderdate) = 4 AND o_clerk LIKE '%0223'; As shown in the figure that follows, the query example was first ... This tutorial describes how to use Explain reports to locate and fix problematic (slow) ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-tc-time-track-stats.html
Each TC instance tracks latencies for a set of activities it undertakes on behalf of API nodes or other data nodes; these activities include transactions, transaction errors, key reads, key writes, unique index operations, failed key operations of ... The tc_time_track_stats table provides time-tracking information obtained from the DBTC block (TC) instances in the data nodes, through API nodes access ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
MyISAM supports concurrent inserts: If a table has no free blocks in the middle of the data file, you can INSERT new rows into it at the same time that other threads are reading from the table. You can put the data file and index file in different ...Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes (Compressed MyISAM tables are supported only when using the compressed row ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-result-sets.html
clobberStreamingResults This will cause a streaming result set to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview-requirements.html
Where communication latencies between data nodes are expected to be higher than would be expected in a LAN environment (on the order of 100 µs), timeout parameters must be increased to ensure that any allowed periods of latency periods are well ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-restore.html
The option datadir must be specified either in the file specified by the --defaults-file option or as a command-line option. The restore operations restores the data files from a backup to their original locations on the database server, or to ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
However, InnoDB provides a start up option called innodb-status-file, which dumps the same output as SHOW ENGINE INNODB STATUS to a file called innodb_status.mysql pid in the datadir. Default frequency 12:00:00 Default auto-close enabled yes InnoDB ...Default frequency 00:05:00 Default auto-close enabled no InnoDB Strict Mode Is Off To guard against ignored typos and syntax errors in SQL, or other unintended consequences of various combinations of operational modes and SQL commands, InnoDB provides a strict mode of ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-tarball.html
When the agent is configured as a daemon, cluster processes are started automatically when the agent is restarted, as long as the cluster was running when the agent shut down; however, StopOnError must be disabled (set to 0) for all data nodes in ...