The most recent release of MariaDB 11.8 is:
Alternate download from mariadb.org
{% endhint %} [MariaDB 11.8](https://mariadb.com/docs/release-notes/community-server/11.8/what-is-mariadb-118) is a long-term release, maintained until June 2028. This list includes all features since the previous long-term release, [MariaDB 11.4](https://mariadb.com/docs/release-notes/community-server/11.4/what-is-mariadb-114) (those introduced in the [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115), [MariaDB 11.6](https://mariadb.com/docs/release-notes/community-server/old-releases/11.6/what-is-mariadb-116) and [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117) rolling releases, and in MariaDB 11.8). ## Upgrading * Note that if you are using system versioned tables, all rows and indexes has to be updated in these to use the extended timestamp range ('`2106-02-07 06:28:15 UTC`'). Upgrading to 11.8 can take a **long time** if you have many rows in your system versioned tables! * If you are not using system versioned tables and you are upgrading from 10.0 and up, the upgrade should just take a few seconds. * See Also: [Upgrading Between Major MariaDB Versions](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/install-and-upgrade-mariadb/upgrading/platform-specific-upgrade-guides/upgrading-on-linux/upgrading-between-major-mariadb-versions) and [Upgrading from MariaDB 11.4 to MariaDB 11.8](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-from-mariadb-11-4-to-mariadb-11-8). ## Downgrading * If you have system versioned tables, downgrading is not trivial. In other cases see [downgrading between major versions](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/install-and-upgrade-mariadb/downgrading-between-major-versions-of-mariadb). ## New Features ### Vectors * [Vector datatype and vector indexing](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-structure/vectors/vector) * Functions [VEC\_FromText](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/vector-functions/vec_fromtext) and [VEC\_ToText](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/vector-functions/vec_totext) * Functions [VEC\_DISTANCE\_COSINE](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/vector-functions/vec_distance_cosine), [VEC\_DISTANCE\_EUCLIDEAN](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/vector-functions/vec_distance_euclidean), [VEC\_DISTANCE](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/vector-functions/vector-functions-vec_distance) for calculating either a Euclidean or Cosine distance between two vectors. The last one automatically uses Euclidean or Cosine, depending on the underlying index type ([MDEV-35450](https://jira.mariadb.org/browse/MDEV-35450)) * Vector indexes can use x86\_64 (AVX2 and AVX512), aarch64 neon ([MDEV-34699](https://jira.mariadb.org/browse/MDEV-34699)) and Powerpc64 AltiVec ([MDEV-36184](https://jira.mariadb.org/browse/MDEV-36184)) SIMD instructions ### Character Sets * The default [character set](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/data-types/string-data-types/character-sets) has been changed from `latin1` to `utf8mb4` ([MDEV-19123](https://jira.mariadb.org/browse/MDEV-19123), [MariaDB 11.6](https://mariadb.com/docs/release-notes/community-server/old-releases/11.6/what-is-mariadb-116)). This can have implications for older replica servers, particularly those running MariaDB 10.6 or older. See [this section](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/data-types/string-data-types/character-sets/setting-character-sets-and-collations#default-character-set-and-collation-changes) for details, and how to configure MariaDB 11.8+ primaries to replicate to older replicas. * Change [default Unicode collation](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/data-types/string-data-types/character-sets/supported-character-sets-and-collations) to uca1400\_ai\_ci, a modern Unicode collation with proper support for SMP characters (including emoji)([MDEV-25829](https://jira.mariadb.org/browse/MDEV-25829), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) ### Optimizer * Optimization improvement for single-table UPDATE/DELETE: make cost-based choice between subquery strategies ([MDEV-25008](https://jira.mariadb.org/browse/MDEV-25008)) * The [Charset Narrowing Optimization](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/charset-narrowing-optimization) is now on by default ([MDEV-34380](https://jira.mariadb.org/browse/MDEV-34380)) * Optimizer can now take advantage of queries of the format [SUBSTR(col, 1, n) = const\_str](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/string-functions/substring) ([MDEV-34911](https://jira.mariadb.org/browse/MDEV-34911)) * Add basic optimizer support for [virtual columns](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/data-definition/create/generated-columns) - see [Virtual Column Support in the Optimizer](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/virtual-column-support-in-the-optimizer) ([MDEV-35616](https://jira.mariadb.org/browse/MDEV-35616)) * [Index condition pushdown](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/index-condition-pushdown) is now supported for partitioned tables ([MDEV-12404](https://jira.mariadb.org/browse/MDEV-12404), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) * ANALYZE for statement should show selectivity of pushed index condition ([MDEV-18478](https://jira.mariadb.org/browse/MDEV-18478), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) ### System-Versioned Tables * Allow a [system-versioned table](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-structure/temporal-tables/system-versioned-tables) to be converted from implicit to explicit row\_start/row\_end columns ([MDEV-27293](https://jira.mariadb.org/browse/MDEV-27293)) ### Temporary files and tables * [Limit size of created disk temporary files and tables](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/security/limiting-size-of-created-disk-temporary-files-and-tables/limiting-size-of-created-disk-temporary-files-and-tables-overview) ([MDEV-9101](https://jira.mariadb.org/browse/MDEV-9101), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) * There are two system variables used for controlling this feature ([MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)): * [max\_tmp\_session\_space\_usage](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/security/limiting-size-of-created-disk-temporary-files-and-tables/max_tmp_session_space_usage-system-variable): Limits the temporary space allowance per user * [max\_tmp\_total\_space\_usage](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/security/limiting-size-of-created-disk-temporary-files-and-tables/max_tmp_total_space_usage-system-variable): Limits the temporary space allowance for all users. ### Data Types * The [TIMESTAMP](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/data-types/date-and-time-data-types/timestamp) range of values was extended. The maximal allowed value for timestamps was '`2038-01-19 03:14:07 UTC'`, and is now '`2106-02-07 06:28:15 UTC`'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms ([MDEV-32188](https://jira.mariadb.org/browse/MDEV-32188), [MariaDB 11.5](https://kb-archive.mariadb.net/kb/en/what-is-mariadb-115/)). Note that if you are using system versioned tables, all rows have to be updated in these to use the new end range. This can take a **long time** if you have many rows in your system versioned tables! ### Authentication * [New PARSEC authentication plugin](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/plugins/authentication-plugins/authentication-plugin-parsec) ([MDEV-32618](https://jira.mariadb.org/browse/MDEV-32618), [MariaDB 11.6](https://mariadb.com/docs/release-notes/community-server/old-releases/11.6/what-is-mariadb-116)) * Extend [Unix socket authentication](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/plugins/authentication-plugins/authentication-plugin-unix-socket) to support `authentication_string` ([MDEV-33479](https://jira.mariadb.org/browse/MDEV-33479), [MariaDB 11.6](https://mariadb.com/docs/release-notes/community-server/old-releases/11.6/what-is-mariadb-116)) ### InnoDB * Fix [innodb-adaptive-hash-index](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/innodb/innodb-system-variables#innodb_adaptive_hash_index) scalability with multiple threads ([MDEV-35049](https://jira.mariadb.org/browse/MDEV-35049)) ### Backup and Restore * Parallel dump of multiple databases via [mariadb-dump](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/clients-and-utilities/backup-restore-and-import-clients/mariadb-dump) with the `--dir` option ([MDEV-33625](https://jira.mariadb.org/browse/MDEV-33625), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) * Parallel import of multiple databases via [mariadb-import](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/clients-and-utilities/backup-restore-and-import-clients/mariadb-import) with the `--dir` option ([MDEV-33627](https://jira.mariadb.org/browse/MDEV-33627), [MariaDB 11.6](https://mariadb.com/docs/release-notes/community-server/old-releases/11.6/what-is-mariadb-116)) * Added the related `--database`, `--ignore-database`, `--table` and `--ignore-table` options. * Refactor [mariadb-import](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/clients-and-utilities/backup-restore-and-import-clients/mariadb-import) threading * The [mariadb-dump](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/clients-and-utilities/backup-restore-and-import-clients/mariadb-dump) `--no-autocommit` option is now set by default to allow faster data loading by InnoDB, writing only one undo log for the whole operation ([MDEV-32250](https://jira.mariadb.org/browse/MDEV-32250)) * [mariadb-import](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/clients-and-utilities/backup-restore-and-import-clients/mariadb-import) has a new option, `--innodb-optimize-keys` to delay creation of secondary indexes until after data load, resulting in faster loads. On by default. ([MDEV-34740](https://jira.mariadb.org/browse/MDEV-34740)) ### Replication * When [binlogging](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/server-monitoring-logs/binary-log) is enabled, committing a large transaction no longer freezes all other transactions until completed ([MDEV-32014](https://jira.mariadb.org/browse/MDEV-32014), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * [binlog\_optimize\_thread\_scheduling](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables#binlog_optimize_thread_scheduling) has been deprecated ([MDEV-33756](https://jira.mariadb.org/browse/MDEV-33756), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * Async rollback prepared transactions during binlog crash recovery ([MDEV-33853](https://jira.mariadb.org/browse/MDEV-33853), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * New variable, [slave\_abort\_blocking\_timeout](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables#slave_abort_blocking_timeout), for aborting long-running queries on a replica ([MDEV-34857](https://jira.mariadb.org/browse/MDEV-34857), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * [binlog\_optimize\_thread\_scheduling](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables#binlog_optimize_thread_scheduling) deprecated ([MDEV-33756](https://jira.mariadb.org/browse/MDEV-33756), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * New definition for `Seconds_Behind_Master` ([MDEV-33856](https://jira.mariadb.org/browse/MDEV-33856), [MariaDB 11.6](https://mariadb.com/docs/release-notes/community-server/old-releases/11.6/what-is-mariadb-116)) * Added three variables to [SHOW ALL REPLICAS STATUS](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/administrative-sql-statements/show/show-replica-status) * New [Information Schema SLAVE\_STATUS Table](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/information-schema/information-schema-tables/information-schema-slave_status-table) ### Galera * Automatic SST user account management ([MDEV-31809](https://jira.mariadb.org/browse/MDEV-31809), [MariaDB 11.6](https://mariadb.com/docs/release-notes/community-server/old-releases/11.6/what-is-mariadb-116)) ### UUID * New function for generating version 4 UUIDs [UUID\_v4](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid_v4) ([MDEV-11339](https://jira.mariadb.org/browse/MDEV-11339), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * New function for generating version 7 UUIDs [UUID\_v7](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid_v7) ([MDEV-32637](https://jira.mariadb.org/browse/MDEV-32637), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) ### Other Functions * New [FORMAT\_BYTES](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/secondary-functions/miscellaneous-functions/miscellaneous-functions-format_bytes) function. Given a byte count, returns a string consisting of a value and the units in a human-readable format ([MDEV-31736](https://jira.mariadb.org/browse/MDEV-31736)) ### Protocol * Permit bulk implementation to return ALL individual results ([MDEV-30366](https://jira.mariadb.org/browse/MDEV-30366), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) * Send initial values of system variables in first OK packet ([MDEV-31609](https://jira.mariadb.org/browse/MDEV-31609), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) ### Observability * New [USERS table](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/information-schema/information-schema-tables/information-schema-users-table) in the Information Schema for storing information about users, [password expiry](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/security/user-account-management/user-password-expiry), and the limits set by [max\_password\_errors](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#max_password_errors) ([MDEV-23729](https://jira.mariadb.org/browse/MDEV-23729), [MDEV-32218](https://jira.mariadb.org/browse/MDEV-32218), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) * Add more columns to Information Schema [TABLE\_STATISTICS](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/information-schema/information-schema-tables/information-schema-table_statistics-table), [CLIENT\_STATISTICS](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/information-schema/information-schema-tables/information-schema-client_statistics-table) and [USER STATISTICS](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/information-schema/information-schema-tables/information-schema-user_statistics-table) tables ([MDEV-33151](https://jira.mariadb.org/browse/MDEV-33151), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) * Add QUERIES column to Information Schema [INDEX\_STATISTICS](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/information-schema/information-schema-tables/information-schema-index_statistics-table) table ([MDEV-33152](https://jira.mariadb.org/browse/MDEV-33152), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) * Add [FLUSH GLOBAL STATUS](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/administrative-sql-statements/flush-commands/flush#flush-status) ([MDEV-33145](https://jira.mariadb.org/browse/MDEV-33145), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) * Provide InnoDB async IO statistics ([MDEV-32841](https://jira.mariadb.org/browse/MDEV-32841), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) * Extend [Query Response Time plugin](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/plugins/other-plugins/query-response-time-plugin) to be compatible with Percona server ([MDEV-33501](https://jira.mariadb.org/browse/MDEV-33501), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) ### [Sequences](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-structure/sequences) * Additional features for Sequences ([MDEV-28152](https://jira.mariadb.org/browse/MDEV-28152), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) * [CREATE SEQUENCE ... AS](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-structure/sequences/create-sequence) permits creating as any [INT](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/data-types/numeric-data-types/int) type (including [BIGINT UNSIGNED](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/data-types/numeric-data-types/bigint)), extending the range * [Information Schema Sequences table](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/information-schema/information-schema-tables/information-schema-sequences-table) * Parser accepts larger and smaller values for [MINVALUE](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-structure/sequences/create-sequence#minvalue) and [MAXVALUE](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-structure/sequences/create-sequence#maxvalue) * [ANALYZE TABLE](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/table-statements/analyze-table) on [sequences](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-structure/sequences) no longer attempts to collect statistics ([MDEV-33938](https://jira.mariadb.org/browse/MDEV-33938)) ### System-Versioned Tables * Allow a [system-versioned table](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-structure/temporal-tables/system-versioned-tables) to be converted from implicit to explicit row\_start/row\_end columns ([MDEV-27293](https://jira.mariadb.org/browse/MDEV-27293), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) ### Stored Routines * ROW data type for stored function return values ([MDEV-12252](https://jira.mariadb.org/browse/MDEV-12252), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * Stored routines parameters can have default values ([MDEV-10862](https://jira.mariadb.org/browse/MDEV-10862)) * Update triggers can optionally have a list of columns an update of which executes the trigger. Updating other columns does not execute the trigger ([MDEV-34551](https://jira.mariadb.org/browse/MDEV-34551)) ### Derived Tables * Add optional correlation column list for [derived tables](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/data-manipulation/selecting-data/subqueries/subqueries-in-a-from-clause-derived-tables) ([MDEV-31466](https://jira.mariadb.org/browse/MDEV-31466), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) ### \[SHOW] CREATE SERVER * Implement [SHOW CREATE SERVER](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/administrative-sql-statements/show/show-create-server) ([MDEV-15696](https://jira.mariadb.org/browse/MDEV-15696), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * Allow arbitrary options in [CREATE SERVER](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/data-definition/create/create-server) ([MDEV-34716](https://jira.mariadb.org/browse/MDEV-34716), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) ### Slow Query Log * New variable, [log\_slow\_always\_query\_time](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/server-monitoring-logs/slow-query-log/log_slow_always_query_time-system-variable), for specifying that all queries longer than this time are logged to the [slow query log](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/server-monitoring-logs/slow-query-log), regardless of [log\_slow\_min\_examined\_row\_limit](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#log_slow_min_examined_row_limit) and [log\_slow\_rate\_limit](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#log_slow_rate_limit) ([MDEV-33144](https://jira.mariadb.org/browse/MDEV-33144), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) ### Information Schema * When querying the [information Schema](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/information-schema), [stored functions](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/stored-routines/stored-functions) that have the same name as a native function no longer generate a warning ([MDEV-35437](https://jira.mariadb.org/browse/MDEV-35437)) ### Spider * The Spider variables [spider\_table\_crd\_thread\_count](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/spider/spider-system-variables#spider_table_crd_thread_count) and [spider\_table\_sts\_thread\_count](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/spider/spider-system-variables#spider_table_sts_thread_count) have been deprecated ([MDEV-28009](https://jira.mariadb.org/browse/MDEV-28009), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * Deprecate [spider\_casual\_read](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/spider/spider-system-variables#spider_casual_read) ([MDEV-31789](https://jira.mariadb.org/browse/MDEV-31789), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) ### General * [SESSION\_USER()](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/secondary-functions/information-functions/session_user), which used to be an alias for [USER()](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/secondary-functions/information-functions/user) now shows the value of [CURRENT\_USER()](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/secondary-functions/information-functions/current_user) when the session was created ([MDEV-30908](https://jira.mariadb.org/browse/MDEV-30908), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * CURRENT\_TIMESTAMP should return a TIMESTAMP (WITH TIME ZONE?) ([MDEV-15751](https://jira.mariadb.org/browse/MDEV-15751), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * A warning has been added when [max\_sort\_length](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#max_sort_length) is exceeded. ([MDEV-27277](https://jira.mariadb.org/browse/MDEV-27277), [MariaDB 11.7](https://mariadb.com/docs/release-notes/community-server/old-releases/11.7/what-is-mariadb-117)) * Single-table [DELETEs](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/data-manipulation/changing-deleting-data/delete) now support table aliases ([MDEV-33988](https://jira.mariadb.org/browse/MDEV-33988), [MariaDB 11.6](https://mariadb.com/docs/release-notes/community-server/old-releases/11.6/what-is-mariadb-116)) * Set thread names for MariaDB Server threads ([MDEV-32537](https://jira.mariadb.org/browse/MDEV-32537), [MariaDB 11.6](https://mariadb.com/docs/release-notes/community-server/old-releases/11.6/what-is-mariadb-116)) * [REPAIR TABLE ... FORCE](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/table-statements/repair-table) ([MDEV-33449](https://jira.mariadb.org/browse/MDEV-33449), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) ### Variables * Deprecate and ignore the [alter\_algorithm](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#alter_algorithm) system variable ([MDEV-33655](https://jira.mariadb.org/browse/MDEV-33655), [MariaDB 11.5](https://mariadb.com/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115)) * For a list of all new variables, see [System Variables Added in MariaDB 11.8](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-variables-added-in-mariadb-11-8) ## Removed Features The following deprecated features have been removed: * `