Search Results
https://dev.mysql.com/doc/workbench/en/wb-generating-php.html
SQL @variables generate PHP variables in the code that then bind to the statement before execution. MySQL Workbench can be used to generate PHP code with the bundled PHP plugin, by using the Tools, Utilities, Copy as PHP Code menu option. The ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj.html
This section provides basic information for writing, compiling, and executing applications that use ClusterJ. To run applications that use ClusterJ, you need the clusterj runtime jar file; in addition, libndbclient must be in the directory ...For ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-reconnect.html
The argument attempts specifies the number of times a reconnect is tried. The delay argument is the number of seconds to wait between each retry. Syntax: cnx.reconnect(attempts=1, delay=0) Attempt to reconnect to the MySQL server. You might set the ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-reconnect.html
The argument attempts specifies the number of times a reconnect is tried. The delay argument is the number of seconds to wait between each retry. Syntax: cnx.reconnect(attempts=1, delay=0) Attempt to reconnect to the MySQL server. You might set the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html
If an existing backup_id value is used, the backup fails with the error Backup failed: file already exists. Execute this command: ndb_mgm> ABORT BACKUP backup_id The number backup_id is the identifier of the backup that was included in the response ... Before starting a backup, make sure that the cluster is properly configured for performing ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-16.html
(WL #12459) X DevAPI: When using X DevAPI, performance for statements that are executed repeatedly (two or more times) is improved by using server-side prepared statements for the second and subsequent executions. Also made the error message clearer ... Version 8.0.16 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
A SET statement that assigns variable values is not written to the binary log, so in replication scenarios it affects only the host on which you execute it. To affect all replication hosts, execute the statement on each host. User-Defined Variable ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using MIXED mode. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
REPAIR TABLE upgrades a table if it contains old temporal columns in pre-5.6.4 format; namely, the TIME, DATETIME, and TIMESTAMP columns that lacked support for fractional seconds precision. Possible causes include but are not limited to file system ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. Each session corresponds to a MySQL thread, and executes one transaction after another. For example, if the blocking_pid is 6, issue this query: ... This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits ...