MariaDB [test]> CREATE SEQUENCE t1;

Query OK, 0 rows affected (0.20 sec)

MariaDB [test]> OPTIMIZE TABLE t1;

+---------+----------+----------+-----------------------------------------------------------+

| Table   | Op       | Msg_type | Msg_text                                                  |

+---------+----------+----------+-----------------------------------------------------------+

| test.t1 | optimize | note     | The storage engine for the table doesn't support optimize |

+---------+----------+----------+-----------------------------------------------------------+

1 row in set, 1 warning (0.00 sec)

MariaDB [test]> show warnings;

+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Level | Code | Message                                                                                                                                                                                                 |

+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Note  | 1592 | Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave |

+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]> select @@binlog_format;

+-----------------+

| @@binlog_format |

+-----------------+

| MIXED           |

+-----------------+

1 row in set (0.00 sec)