
ANALYSE (the only built-in procedure not requiring the server to be
recompiled).

SKIP LOCKED
-----------

MariaDB starting with 10.6
--------------------------
The SKIP LOCKED clause was introduced in MariaDB 10.6.0.

This causes those rows that couldn't be locked (LOCK IN SHARE MODE or FOR
UPDATE) to be excluded from the result set. An explicit NOWAIT is implied
here. This is only implemented on InnoDB tables and ignored otherwise.

SQL_CALC_FOUND_ROWS
-------------------

When SQL_CALC_FOUND_ROWS is used, then MariaDB will calculate how many rows
would have been in the result, if there would be no LIMIT clause. The result
can be found by calling the function FOUND_ROWS() in your next sql statement.

max_statement_time clause
-------------------------

By using max_statement_time in conjunction with SET STATEMENT, it is possible
to limit the execution time of individual queries. For example:

SET STATEMENT max_statement_time=100 FOR 
 SELECT field1 FROM table_name ORDER BY field1;

WAIT/NOWAIT
-----------

Set the lock wait timeout. See WAIT and NOWAIT.

Examples
--------

SELECT f1,f2 FROM t1 WHERE (f3<=10) AND (f4='y');

See Getting Data from MariaDB (Beginner tutorial), or the various
sub-articles, for more examples.

URL: https://mariadb.com/kb/en/select/