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 ...
https://dev.mysql.com/optimizing-innodb-storage-layout.html
The primary key value for a row is duplicated in all the secondary index records that point to the same row. Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE ...
https://dev.mysql.com/order-by-optimization.html
Change the tmpdir system variable to point to a dedicated file system with large amounts of free space. This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and ...
