Search Results
https://dev.mysql.com/doc/internals/en/creating-tables.html
Once a handler is instanced, the first operation that will likely be required is the creation of a table. Your storage engine must implement the [custom-engine.html#custom-engine-api-reference-create create()] virtual method: virtual int ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-online-backup.html
You might execute this command in the shell or terminal, which looks similar to: /bin/mysqlbackup --defaults-file="/var/lib/meb/foo.cnf" --show-progress=stdout backup --with-timestamp Backup Job Details: Displays information about the state of a ...
https://dev.mysql.com/doc/workbench/en/wb-configuration-additional.html
Safe Updates: When enabled (default), MySQL Workbench will not execute UPDATE or DELETE statements if a key is not defined in the WHERE clause. For example, DELETE FROM foo is considered unsafe, whereas DELETE FROM foo WHERE id = 1 is safe and will ... Commonly used configuration options and preferences include: Rescan for Local MySQL Instances: Right-click on the home screen, and this option will scan your system for MySQL instances and add connection tiles to the home ...
https://dev.mysql.com/doc/internals/en/com-change-user.html
COM_CHANGE_USER changes the user of the current connection and reset the connection state. and others It is followed by the same states as the initial handshake.
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-constants.html
4.3.1.14.42 PROPERTY_CONNECTION_RECONNECT_TIMEOUT public static final String PROPERTY_CONNECTION_RECONNECT_TIMEOUT = "com.mysql.clusterj.connection.reconnect.timeout"; Since 7.5.7 The number of seconds to wait for all sessions to be closed when ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-firewall.html
MySQL Enterprise Firewall is an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against allowlists of accepted statement patterns. MySQL Enterprise Firewall installation is ...This helps harden MySQL against attacks such as SQL injection or attempts to exploit applications by using them outside of their legitimate query workload ...
https://dev.mysql.com/doc/x-devapi-userguide/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-sign-keys.html
--connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer Default Value 5 Minimum Value 0 Maximum Value 5 Set the number of seconds after a failed connection attempt which ndb_sign_keys waits before trying again, up to the ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. If the slow query log is enabled and FILE is selected as an output destination, ...
https://dev.mysql.com/doc/refman/8.4/en/json-modification-functions.html
An error occurs if the json_doc argument is not a valid JSON document or any path argument is not a valid path expression or contains a * or ** wildcard. An error occurs if the json_doc argument is not a valid JSON document or any path argument is ... The functions in this section modify JSON values and return the ...