0

I have changed all tables in my mariadb database from MyISAM to Aria (using adminer as tool), but the database engine is still shown as InnoDB. Should I change this to Aria, too?

I did not choose InnoDB at any time. Guess it is a default value.

At the end of the tables list, the 'all together (insgesamt)' says "InnoDB":

useronline      Aria    utf8_unicode_ci  
users           Aria    utf8_unicode_ci
19 insgesamt    InnoDB  utf8_unicode_ci

edit:

mysql version:

$ mysql --version
mysql  Ver 15.1 Distrib 10.0.15-MariaDB, for Linux (x86_64) using readline 5.1

and the output of SHOW CREATE TABLE albums;:

CREATE TABLE `albums` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `title` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=Aria AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PAGE_CHECKSUM=1
  • 1
    "Database engine" does not make sense in MySQL context, as that is only a per-table option (aside from a global/session default). Please provide further information on what is your MySQL server version and the output of SHOW CREATE TABLE *a_table*; to make sure your engine has been correctly changed. InnoDB is the default engine starting with MySQL/MariaDB 5.5. – jynus Dec 11 '14 at 15:07
  • Ok, so the '19 insgesamt InnoDB' must be the default engine.. (i have added the informations.) – haheute Dec 11 '14 at 15:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.