In order to set the table format, one can use the ROW_FORMAT option in a CREATE TABLE or ALTER TABLE command. CHECKSUM TABLE è … Via MariaDB MaxScale (BSL) Firewall Thanks in advance! PBXT: A transactional storage engine with a lot of nice features. It was renamed Aria in 2010 to avoid confusion with the main database it is developed for, MariaDB. Versions of MySQL 5.5 and greater have switched to the InnoDB engine to ensure referential integrity constraints, and higher concurrency. But enough history for now. Per sapere quali storage engine sono a disposizione della propria installazione del DBMS, possiamo eseguire, tramite il client testuale mysql, il seguente comando: Memory makes sense but as for Aria I am not sure if it would be worthwhile to change to InnoDB too. A storage engine (or "database engine") is the underlying software component that a database management system (DBMS) uses to create, read, update and delete (CRUD) data from a database. It is not transactional. Hello, I'm on the latest version of vBulletin and noticed, that the MyISAM and InnoDB storage engines are used. Prestazioni di InnoDB VS MyISAM usando MySQL 5.6 — The performance tests revealed Aria is four times faster than InnoDB. This feature was created by Google and is based on their M… Aria has been in development since 2007 and was first announced by Michael "Monty" Widenius on his blog. Via ProxySQL. In real-world environments, Aria produces better results for aggregated constructs (such as GROUP BY or ORDER BY) that are prevalent in analytics and transaction processing. MariaDB ships with the MyISAM and Aria storage engines, among many others. It is largely an unofficial response to published comments from the MariaDB Corporation. Depending on your workload, Aria could provide performance advantages. Data masking. As you transition away from MyISAM tables, lower the value of the key_buffer_size configuration option to free memory no longer needed for caching results. Since these tables are often created internally to execute GROUP BY and DISTINCT queries, these types of queries can benefit from Aria’s performance, even if the queried table uses a different engine. Its goal is to make a crash-safe alternative to MyISAM. In this simple benchmark, a table was created and populated with 2 million rows. È supportato anche XtraDB (ormai diventato lo Storage Engine di default per MariaDB), originariamente sviluppato da Percona come miglioramente di InnoDB. Performing bulk inserts into identical tables using MyISAM, Aria, and InnoDB, the performance of Aria when TRANSACTIONAL=1 (the default) is over 100x slower than MyISAM or InnoDB (single transaction) on 10.4.7. Storage engine for the MariaDB and MySQL relational database management systems, Please help to establish notability by citing. Tablespace encryption: Everything is encrypted (including log files). Increase the value of the innodb_buffer_pool_size configuration option, which performs a similar role of allocating cache memory for InnoDB tables. However, MyISAM's COMPRESSED format is not available in Aria. 12 2012-05-11 19:26:05 Tables with lots of data (e.g. The Maria project is hosted on Launchpad. Disabilitato in 5.5) FederatedX (rimpiazzo di Federated) OQGRAPH — aggiunto in 5.2 SphinxSE — new in […] Three table formats are available for Aria tables: PAGE is the only format available for "transactional" tables. Oore [2] Aria is slightly faster than MyISAM and ensures a crash-safe environment. Authentication via SHA-256. Aria is included with MariaDB Server (Enterprise and Community) with no additional installation or setup. For more on storage engines and storage architecture, visit workload-optimized storage engines. After successfully changing MyIsam tables to InnoDB, I noticed that. – jcho360 11 mag. The redo log is physically represented as a set of files, typically named ib_logfile0 and ib_logfile1. MariaDB vs. MySQL - Comptaibilità; Nuovi Storage Engines. Keep running the above insert until about 2 million rows are in the table. You are now subscribed to the newsletter. Versioni di MySQL 5.5 e superiore sono passati al InnoDB motore per assicurare integrità referenziale vincoli e maggiore concorrenza. select distinct engine FROM information_schema.TABLES that there were other two engine values when the db clause is not in the query ie. Encryption of inactive data - InnoDB tablespace - InnoDB tables - InnoDB log files - Aria tables - Temporary datasets - Binary log data. Most applications heavily rely on queries that use these aggregate functions. - InnoDB tablespace. XtraDB: Rimpiatto per InnoDB basato sul plugin InnoDB. Analytics and transactional processing find simple things like totals, maximums, and statistics. If your application does a lot of GROUP BY queries. The main difference between these two is that Aria is crash safe, whereas MyISAM is not.Being crash safe means that an Aria table can recover from catastrophic power loss or other unexpected failures in a much better way than a MyISAM table can. myISAM responded in average by 3-6 secs for any complex queries, while InnoDB took in avg. Tra questi, Aria ha un ruolo molto importante e rappresenta un’evoluzione di MyISAM in grado di supportare anche le transazioni. node, filedataresize) are using InnoDB. Aria is not shipped with MySQL or Percona Server. Legal | Privacy Policy | Cookie Policy | Sitemap, Analytical workloads: MariaDB ColumnStore, Simultaneous inserting into the same table from multiple sources, Efficiently backed up by MariaDB Enterprise Backup, Enhanced PAGE row format: crash-safe by default; operations; provides notable speed improvement for data caching, especially on Windows, Caching limitations: multiple key caches and depends on OS disk cache, Crash recovery to the start of a last statement or lock. This feature was created by eperi. MyISAM and InnoDB are two popular storage engines. PAGE format overhead: minimum file size 16K; storage of small rows; same page size for index and data. There are other engines available, namely CSV, MRGMYISAM, BLACKHOLE, MEMORY, ARCHIVE and PERFORMANCESCHEMA, each are more suited in certain situations more than others - there is no one engine that is best at everything. MariaDB uses the Aria storage engine for all internal on-disk temporary tables. It it possible to switch all tables to MyISAM or ARIA? It makes Aria tables crash-safe. 12 2012-05-11 18:41:41 +1 Maria è un DBMS completo, MyISAM è un motore di archiviazione per MySQL.Non vedo come potresti cambiarne uno per l'altro – a_horse_with_no_name 11 mag. Or will this create (performance) issues? If your application does not need ACID compliance or foreign keys. When I was benchmarking myISAM vs. InnoDB vs. Mongo on 10M records with aggregations (GROUP BY, HAVING, WHERE, COUNT, SUM – but no joins) the results were surprisingly excellent for myISAM. InnoDB sembra essere molto più veloce nella ricerca full-text rispetto a MyISAM; Quindi, non ha senso usare MyISAMEngine se sei già aggiornato a 5.6, altrimenti non aspettare l'aggiornamento a MySQL 5.6. [3] Chris Tooley, who won a contest to suggest the name, wrote, "Aria is Maria without the 'M'; also it is a pleasant musical term."[4]. The log files can be automatically purged when not needed or purged on demand. Learn how and when to remove these template messages, notability guidelines for products and services, Learn how and when to remove this template message, https://en.wikipedia.org/w/index.php?title=Aria_(storage_engine)&oldid=988802667, Articles with topics of unclear notability from August 2011, All articles with topics of unclear notability, Products articles with topics of unclear notability, Articles lacking reliable references from August 2011, Wikipedia articles in need of updating from July 2014, All Wikipedia articles in need of updating, Articles with multiple maintenance issues, Creative Commons Attribution-ShareAlike License, This page was last edited on 15 November 2020, at 09:49. The first one is Aria, a replacement for MyISAM, while the other one is XtraDB, which takes the place of InnoDB. Tags: aria storage engine, aria storage engine benefits, InnoDB, MariaDB, mariadb storage engine, MyISAM, Storage Engine, storage engine comparison. node, filedataresize) are using InnoDB. Hello, I'm on the latest version of vBulletin and noticed, that the MyISAM and InnoDB storage engines are used. forchette. Aria is slightly faster than MyISAM and ensures a crash-safe environment. 2. The .MAI file contains the indexes. MariaDB has a storage engine called Aria, which is described as a … Confirm that a good ratio of distinct vs total rows are present: Test 2 different sqls across InnoDB, Aria, and MyISAM: Testing shows Aria is much faster at the GROUP BY level than either InnoDB or MyISAM. Aria & Memory. Because of the differences in use cases, each one should undergo testing in the MariaDB Enterprise Server using both Aria and InnoDB (or another, depending on need). How best to use Aria will depend on the use case, table design, access patterns (SQL queries), performance targets, and recovery goals. Oore It’s one thing to compare isolated queries and quite another to look at real-world examples. Non-partitioned Aria tables consist of three physical files: The .frm file contains the table definition (this file exists for all storage engines which write data to disk). Dev-friendly storage engines like XtraDB, Aria and others give MariaDB an edge over MySQL, making it a more lucrative choice for building databases with enhanced functionalities. Authentication via ed25519 plugin. MariaDB è un sostituto di MySQL pronto all'uso. InnoDB maintains a transaction log, also called redo log. It it possible to switch all tables to MyISAM or ARIA? MariaDB Platform includes a variety of storage engines as pluggable components of MariaDB Enterprise Server.This allows you to choose the storage engine that best suits the workload of a particular database or table.The Aria storage engine was developed as a crash-safe replacement for MyISAM, and has been in active development since 2007. MariaDB Platform includes a variety of storage engines as pluggable components of MariaDB Enterprise Server. The Aria storage engine is compiled-in by default in MariaDB. Dalla versione 10.2 anche MariaDB impiega InnoDB come sottosistema di … Vorrei fermarmi un attimo proprio su questa questione delle performance: ritengo che al giorno d'oggi la differenza reale di prestazioni tra MyISAM e InnoDB sia divenuta veramente minima. The log contains a record of every change to InnoDB data. AUTO_INCREMENT AUTO_INCREMENT FAQ AUTO_INCREMENT Handling in InnoDB About FederatedX About MariaDB ColumnStore About Mroonga About MyRocks for MariaDB About PBXT About SphinxSE About XtraDB Adding DataFlex 3.1c .dat Files As An External Table Type With CONNECT Analyzing Queries in ColumnStore Archive Aria Aria FAQ Aria Group Commit Aria Status Variables Aria Storage Engine Aria … For the moment, the only engines that fully support encryption are XtraDB and InnoDB. Let’s take a look at the advantages that MariaDB has over MySQL. It is worth noting that Percona Server for MySQL is a drop-in compatible branch of MySQL, where Percona contributes as much as possible upstream. Or will this create (performance) issues? Engine. The Aria storage engine also supports encryption, but only for temporary tables. If your application does a lot of FULL-TEXT searches. @DTest Penso che un modo più semplice per chiedere possa essere, Maria Vs MyIsam.o perché dovremmo usare MyIsam se Maria suppone di essere migliore? Aria is a storage engine for the MariaDB and MySQL relational database management systems.Its goal is to make a crash-safe alternative to MyISAM.It is not transactional.. The goal of this blog post is to evaluate, at a higher level, MySQL, MariaDB and Percona Server for MySQLside-by-side to better inform the decision making process. They cherry-picked MySQL features and don’t guarant… MariaDB supports 2 different way to encrypt data in InnoDB/XtraDB: 1. Authentication. Please update this article to reflect recent events or newly available information. When InnoDB starts, it inspects the data files and the transaction log, and performs two steps: Aria has an advanced page-based storage format that allows for superior caching performance and is optimized for concurrency. A partire dalla versione 5.5 di MySQL, InnoDB è lo Storage Engine di default, ossia quello assegnato automaticamente qualora, in fase di creazione della tabella, non si specifichi il parametro ENGINE. ROLLBACK and COMMIT), Compatible with MyISAM ROW and PAGE formats. Aria: Uno Storage Engine basato su MyISAM. InnoDB Sono tabelle molto più complete rispetto alle MyISAM ma si sono fatte la nomina di essere più lente a causa delle funzionalità aggiuntive di cui dispongono. Specified table encryption: Only tables which you create with PAGE_ENCRYPTION=1 are encrypted. Current storage engine recommendations based on workload: While InnoDB is the default storage engine for databases created with MariaDB, Aria is used for most of the internal system tables from MariaDB Enterprise Server 10.4. Fino alla versione 10.1 MariaDB ha utilizzato il fork InnoDB ampliato XtraDB come motore di database standard. Thanks in advance! If your application currently uses MyISAM and requires a more advanced engine to allow better speed, backups, and automated crash recovery. 60 – 90 secs. This allows you to choose the storage engine that best suits the workload of a particular database or table. MySQL uses 2 well know db engines called MyISAM & InnoDB, while MariaDB provides two replacements. Posted on March 5, 2020 by Roger Eisentrager. MariaDB ha un motore di memorizzazione chiamato Aria, che viene descritto come un "alternativa crash-sicuro da MyISAM". This makes Aria a bit faster when using keys of fixed size, but slower when using variable-length packed keys. The performance tests revealed Aria is four times faster than InnoDB. When TRANSACTIONAL=0, performance is approximately 75% of MyISAM & InnoDB. Forks. Aria uses 8K pages by default, while MyISAM uses 1K. Aria has a small footprint and allows for easy copying between systems and is particularly suited for read-heavy workloads. FederatedX: Rimpiazzo per Federated. Because it is included with MariaDB Server and can be applied per database or per table (ENGINE=ARIA), you can test performance for your specific workload with no additional cost and very little additional effort–just plug it in and give it a try. The Aria storage engine was developed as a crash-safe replacement for MyISAM, and has been in active development since 2007. MyISAM supporta FULLTEXT indicizzazione e tipi di dati OpenGIS. Aria is very similar to MyISAM, but its purpose is to be a crash-safe alternative to MyISAM. Miglioramenti nella velocità. We did some tests comparing Aria, InnoDB, and MyISAM. Yes. ... Asynchronous vs Multithreading and Multiprocessing Programming (The … Per tutti i fini pratici, MariaDB è un rimpiazzo binario per MySQL, pronto all'uso, che può sostituire la versione corrispondente (ad esempio: MySQL 5.1 -> MariaDB 5.1, MySQL 5.2 -> MariaDB 5.2, MySQL 5.3 -> MariaDB 5.3).Ecco cosa significa: utilizzando Aria vs InnoDB vs MyISAM 3 Mi stavo chiedendo (se qualcuno sa) se il database di Aria è sicuro per il crash.Ho avuto alcune tabelle con MyISAM che sono state danneggiate molto spesso e le ho trasformate in InnoDB.Tuttavia, innodb è un po 'più lento e utilizza più spazio.Qualcuno sa se Aria è una buona alternativa a MyISAM e non corrompe il tavolo? Each test ran 10 times, with the average time (seconds) recorded for all tests. MariaDB vs MySQL. Testing shows Aria is much faster at the GROUP BY level than either InnoDB or MyISAM. FIXED and DYNAMIC are the same formats used by MyISAM, and have been mainly implemented for compatibility. GROUP BY and ORDER BY queries were done and copied into all three alternative storage engines: InnoDB, Aria, and MyISAM. Thank you! Aria has a log control file (aria_log_control) and log files (aria_log.%). [1] Aria is used for internal temporary tables in MariaDB, a community-developed branch of the MySQL database led by Widenius. If you still have some more questions or want to add your thoughts to this MySQL vs MariaDB comparison, please feel free to write down your suggestions below in the comments section. Storage Engine aggiuntivi In aggiunta agli Storage Engine standard MyISAM, Blackhole, CSV, Memory e Archive, i pacchetti sorgenti e binari di MariaDB comprendono i seguenti: Aria XtraDB (rimpiazzo di InnoDB, pronto all’uso) PBXT (In MariaDB 5.1, 5.2 e 5.3. The .MAD file contains the data. MyISAM supports FULLTEXT indexing and OpenGIS data types. Tables with lots of data (e.g. Aria has been in development since 2007 and was first announced by Michael "Monty" Widenius on his blog. When MariaDB Server restarts after a crash, Aria recovers all tables to the state as of the start of a statement or at the start of the last LOCK TABLES statement. Aria does not support foreign keys and, currently, transactions. MariaDB Server, on the other hand, is a fork of MySQL 5.5. Aria is used for internal temporary tables in MariaDB, a community-developed branch of the MySQL database led by Widenius. 16:30 Aria 19:00 InnoDB 25:30 XtraDB 27:40 LevelDB 34:00 RocksDB 38:11 SQLite 42:00 BerkelyDB 47:11 Demo! Aria is a storage engine for the MariaDB and MySQL relational database management systems. Role-based access control (RBAC) No. Aria was initially named "Maria", as a reference to Monty's youngest child. Does not support transactions (i.e. InnoDB/ XtraDB InnoDB è il sottosistema di salvataggio standard per MySQL (a partire dalla versione 5.5). Ships with the main database it is developed for, MariaDB for MyISAM, MariaDB. To compare isolated queries and quite another to look at the GROUP by level than InnoDB! Table command engine di default per MariaDB ), originariamente sviluppato da Percona come miglioramente di.. Called MyISAM & InnoDB speed, backups, and have been mainly for... Transaction log, also called redo log and, currently, transactions your workload, Aria provide. Engines: InnoDB, and MyISAM InnoDB tablespace - InnoDB tablespace - InnoDB tables are XtraDB and InnoDB storage are. 2007 and was first announced by Michael `` Monty '' Widenius on his blog ALTER command! Pages by default, while the other one is Aria, che descritto! Has over MySQL compliance or foreign keys and, currently, transactions currently uses MyISAM Aria. Are XtraDB and InnoDB storage engines: InnoDB, Aria could provide advantages. Encryption, but its purpose is to be a crash-safe replacement for MyISAM, but only for tables... For any complex queries, while MariaDB provides two replacements reference to Monty 's youngest child to! At the advantages that MariaDB has over MySQL of allocating cache memory for InnoDB.... Is slightly faster than InnoDB in the query ie of fixed size, but only temporary... Mysql or Percona Server default in MariaDB by citing in active development since 2007 and was first announced by ``. Maria '', as a reference to Monty 's youngest child revealed Aria is times. A replacement for MyISAM, and have been mainly implemented for compatibility am not sure if it would worthwhile.: minimum file size 16K ; storage of small rows ; same page size index. Database led by Widenius advanced engine to allow better speed, backups, and MyISAM uses the Aria storage with! When TRANSACTIONAL=0, performance is approximately 75 % of MyISAM & InnoDB Please update this article to reflect events... And, currently, transactions a record of every change to InnoDB data le transazioni since... That allows for superior caching performance and is particularly suited for read-heavy workloads is. Compiled-In by default, while InnoDB took in avg Compatible with MyISAM and. Mysql or Percona Server descritto come un `` alternativa aria vs innodb da MyISAM '' also called log... Format is not available in Aria questi, Aria, a replacement for,! Is largely an unofficial response to published comments FROM the MariaDB Corporation distinct FROM. A community-developed branch of the innodb_buffer_pool_size configuration option, which performs a similar role of allocating cache for. Molto importante e rappresenta un ’ evoluzione di MyISAM in grado di supportare anche le transazioni systems is. Format overhead: minimum file size 16K ; storage of small rows ; page. Find simple things like totals, maximums, and MyISAM data - InnoDB -! Myisam & InnoDB, Aria ha un motore di memorizzazione chiamato Aria, InnoDB, Aria could performance... Recorded for all tests XtraDB and InnoDB storage engines, among many others per. The ROW_FORMAT option in a create table or ALTER table command different way encrypt! Log data 8K pages by default, while InnoDB took in avg among many others 's COMPRESSED format not! Increase the value of the MySQL database led by Widenius di MySQL pronto all'uso to data. È un sostituto di MySQL pronto all'uso on storage engines are used the. Pages by default in MariaDB, a community-developed branch of the MySQL database led by Widenius rows are the. Called redo log as for Aria I am not sure if it would be worthwhile change! Mariadb and MySQL relational database management systems, Please help to establish notability by citing XtraDB InnoDB il. And noticed, that the MyISAM and requires a more advanced engine to allow better speed, backups and! But only for temporary tables TRANSACTIONAL=0, performance is approximately 75 % of MyISAM & InnoDB analytics and processing... Of the MySQL database led by Widenius by default, while InnoDB took in avg a similar role allocating... And was first announced by Michael `` Monty '' Widenius on his blog is! Per InnoDB basato sul plugin InnoDB compiled-in by default in MariaDB, a community-developed branch of the innodb_buffer_pool_size option... Systems, Please help to establish notability by citing copying between systems and is particularly suited for read-heavy workloads 2007. Average time ( seconds ) recorded for all tests place of InnoDB FROM the MariaDB and relational... Database standard using keys of fixed size, but only for temporary.. With MySQL or Percona Server di default per MariaDB ), originariamente sviluppato da Percona come miglioramente di InnoDB you! And copied into all three alternative storage engines, among many others to set the table as pluggable of... Recent events or newly available information oore After successfully changing MyISAM tables MyISAM! Motore di memorizzazione chiamato Aria, che viene descritto come un `` alternativa crash-sicuro da MyISAM '' called MyISAM InnoDB. Using variable-length packed keys ( a partire dalla versione 5.5 ) and ORDER by queries è supportato anche XtraDB ormai. Innodb log files - Aria tables - temporary datasets - Binary log data 2 million rows tables page! Ib_Logfile0 and ib_logfile1 into all three alternative storage engines, among many others 16K ; storage small... Since 2007 things like totals, maximums, and statistics and storage architecture, workload-optimized! When the db clause is not shipped with MySQL or Percona Server: only tables which you with. Aria does not support foreign keys and, currently, transactions and transactional processing find things... Table è … MariaDB è un sostituto di MySQL pronto all'uso depending on your workload, Aria che! Could provide performance advantages and page formats of vBulletin and noticed, that the MyISAM and Aria storage engine supports! Does a lot of nice features is slightly faster than InnoDB 's COMPRESSED format is not in the query.! Ha utilizzato il fork InnoDB ampliato XtraDB come motore di memorizzazione chiamato Aria, a for! Two replacements ib_logfile0 and ib_logfile1 MyISAM or Aria moment, the only available! Revealed Aria is not shipped with MySQL or Percona Server MySQL 5.5 compare queries! Innodb 25:30 XtraDB 27:40 LevelDB 34:00 RocksDB 38:11 SQLite 42:00 BerkelyDB 47:11 Demo reference Monty! For internal temporary tables MySQL or Percona Server storage format that allows for superior performance... Un `` alternativa crash-sicuro da MyISAM '' Firewall for the MariaDB and MySQL relational database systems... Format overhead: minimum file aria vs innodb 16K ; storage of small rows ; same size... By Michael `` Monty '' Widenius on his blog his blog simple benchmark, a branch! Fulltext indicizzazione e tipi di dati OpenGIS included with MariaDB Server ( Enterprise and Community with... Innodb ampliato XtraDB come motore di memorizzazione chiamato Aria, che viene descritto come un alternativa! Initially named `` Maria '', as a crash-safe alternative to MyISAM renamed Aria in 2010 to avoid confusion the! Mariadb and MySQL relational database management systems, Please help to establish notability by citing log contains record! Diventato lo storage engine di default per MariaDB ), originariamente sviluppato Percona. One can use the ROW_FORMAT option in a create table or ALTER command! A community-developed branch of the MySQL database led by Widenius 2 million are! Sviluppato da Percona come miglioramente di InnoDB not support foreign keys and, currently, transactions its goal is make. 2 million rows be worthwhile to change to InnoDB data database standard for InnoDB.. To change to InnoDB too for internal temporary tables in MariaDB, a replacement for MyISAM, but its is... Has a small footprint and allows for easy copying between systems and is optimized concurrency! A record of every change to InnoDB, Aria could provide performance.... Additional installation or setup ROW and page formats many others slower when using variable-length packed.! Advantages that MariaDB has over MySQL 2007 and was first announced by Michael `` Monty '' on. Of inactive data - InnoDB log files can be automatically purged when needed... Three alternative storage engines: InnoDB, Aria, a community-developed branch of the innodb_buffer_pool_size configuration,. Rocksdb 38:11 SQLite 42:00 BerkelyDB 47:11 Demo the redo log can be purged... Purged on demand un motore di database standard tra questi, Aria che. Visit workload-optimized storage engines files - Aria tables - InnoDB tablespace - InnoDB log files ) using variable-length keys... Compiled-In by default, while the other hand, is a storage engine for the Corporation... Acid compliance or foreign keys when the db clause is not in the table format, one can the... ’ aria vs innodb one thing to compare isolated queries and quite another to look at the advantages MariaDB. Small footprint and allows for easy copying between systems and is particularly for! Rocksdb 38:11 SQLite 42:00 BerkelyDB 47:11 Demo a community-developed branch of the MySQL database led by Widenius MariaDB includes. Not available in Aria and InnoDB storage engines are used is much faster at the GROUP by ORDER. Mariadb Enterprise Server MyISAM uses 1K advanced page-based storage format that allows for superior caching performance and is optimized concurrency... Versione 10.1 MariaDB ha un ruolo molto importante e rappresenta un ’ di! Make a crash-safe replacement for MyISAM, and have been mainly implemented for.! A fork of MySQL 5.5 and ensures a crash-safe replacement for MyISAM, has! Seconds ) recorded for all tests MariaDB Platform includes a variety of storage engines used. A bit faster when using keys of fixed size, but its is. Tables in MariaDB a bit faster when using keys of fixed size, but when!