https://dev.mysql.com/mysql-stmt-attr-set.html
arg should point to a variable that is set to the desired attribute value. bool mysql_stmt_attr_set(MYSQL_STMT *stmt, enum enum_stmt_attr_type option, const void *arg) Can be used to affect behavior for a prepared statement. This function may be ...
https://dev.mysql.com/mysql-stmt-init.html
The handler should be freed with mysql_stmt_close(), at which point the handler becomes invalid and should no longer be used. See also Section 28.6.8, “C API Prepared Statement Data Structures”, for more information.
https://dev.mysql.com/mysql-stmt-prepare.html
int mysql_stmt_prepare(MYSQL_STMT *stmt, const char *stmt_str, unsigned long length) Given the statement handler returned by mysql_stmt_init(), prepares the SQL statement pointed to by the string stmt_str and returns a status value. You should not ...
https://dev.mysql.com/mysqld-safe.html
If the full path points to a nonexistent or unreadable file, mysqld_safe aborts with an error. mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when an error ...
https://dev.mysql.com/ndb-restore-different-number-nodes.html
Recreating the indexes avoids errors due to the restore not being consistent at all points. It is possible to restore from an NDB backup to a cluster having a different number of data nodes than the original from which the backup was taken. The ...
https://dev.mysql.com/ndb-restore-parallel-data-node-backup.html
Beginning with NDB Cluster 8.0.16, it is possible to take parallel backups on each data node using ndbmtd with multiple LDMs (see Section 22.5.3.5, “Taking an NDB Backup with Parallel Data Nodes”). The next two sections describe how to restore ...
https://dev.mysql.com/nested-join-optimization.html
The preceding examples demonstrate these points: For join expressions involving only inner joins (and not outer joins), parentheses can be removed and joins evaluated left to right. The following discussion refers to the join syntax described in ...
https://dev.mysql.com/numeric-functions.html
Table 12.7 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...
https://dev.mysql.com/optimize-benchmarking.html
Performance can vary depending on so many different factors that a difference of a few percentage points might not be a decisive victory. To measure performance, consider the following factors: Whether you are measuring the speed of a single ...
https://dev.mysql.com/optimize-table.html
OPTIMIZE TABLE does not sort R-tree indexes, such as spatial indexes on POINT columns. OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...
