[MDEV-20002] Create system tables as aria instead of myisam Created: 2019-07-09  Updated: 2019-07-09

Status: Open
Project: MariaDB Server
Component/s: Configuration
Affects Version/s: 10.1, 10.2, 10.3, 10.4
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Marc Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

System tables in database mysql are created as myisam tables and some newer ones as innodb, if the engine is available.
Since the aria engine was designed to be a better "myisam", the tables should be created as aria. With this change, it should be possible to totally disable the old myisam engine on mariadb installations.

 Comments   
Comment by Elena Stepanova [ 2019-07-09 ]

10.4 already has Aria for system tables.

Comment by Marc [ 2019-07-09 ]

You're right for aria, I've checked 10.4.
But there is "still"
SET @innodb_or_aria=IF(@have_innodb <> 0, 'InnoDB', 'Aria');
which prefers innodb over aria. Is there a chance to have this more configureable, even if innodb is enabled I'm not so happy to have innodb tables in my mysql configuration

Generated at Thu Feb 08 08:55:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.