[MDEV-7385] Mariadb still create table with MyISAM even default ENGINE=Innodb Created: 2014-12-27  Updated: 2014-12-27  Resolved: 2014-12-27

Status: Closed
Project: MariaDB Server
Component/s: Galera SST, Replication, Storage Engine - InnoDB
Affects Version/s: 10.0.15
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: anil Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: galera, innodb, replication
Environment:

MariaDB-Galera-server x86_64 10.0.15-1.el7.centos @mariadb 135 M
MariaDB-client x86_64 10.0.15-1.el7.centos @mariadb 49 M
galera x86_64 25.3.5-1.rhel6



 Description   

As the default engine is Innodb but still when in see mysql database all tables under it are using MyISAM , due to that galera replication is not working properly , whenever i delete or insert users ..

MariaDB [mysql]> show table status;
+---------------------------+--------+---
-------------------+----------+----------
| Name                      | Engine | Ve
 Collation         | Checksum | Create_op
+---------------------------+--------+---
-------------------+----------+----------
| column_stats              | MyISAM |   
 utf8_bin          |     NULL |          
| columns_priv              | MyISAM |   
 utf8_bin          |     NULL |          
| db                        | MyISAM |   
 utf8_bin          |     NULL |          
| event                     | MyISAM |   
 utf8_general_ci   |     NULL |          
| func                      | MyISAM |   
 utf8_bin          |     NULL |          
| general_log               | CSV    |   
 utf8_general_ci   |     NULL |          
| gtid_slave_pos            | InnoDB |   
 latin1_swedish_ci |     NULL |          
| help_category             | MyISAM |   
 utf8_general_ci   |     NULL |          
| help_keyword              | MyISAM |   
 utf8_general_ci   |     NULL |          
| help_relation             | MyISAM |   
 utf8_general_ci   |     NULL |          
| help_topic                | MyISAM |   
 utf8_general_ci   |     NULL |          
| host                      | MyISAM |   
 utf8_bin          |     NULL |          
| index_stats               | MyISAM |   
 utf8_bin          |     NULL |          
| innodb_index_stats        | InnoDB |   
 utf8_bin          |     NULL | stats_per
| innodb_table_stats        | InnoDB |   
 utf8_bin          |     NULL | stats_per
| plugin                    | MyISAM |   
 utf8_general_ci   |     NULL |          
| proc                      | MyISAM |   
 utf8_general_ci   |     NULL |          
| procs_priv                | MyISAM |   
 utf8_bin          |     NULL |          
| proxies_priv              | MyISAM |   
 utf8_bin          |     NULL |          
| roles_mapping             | MyISAM |   
 utf8_bin          |     NULL |          
| servers                   | MyISAM |   
 utf8_general_ci   |     NULL |          
| slow_log                  | CSV    |   
 utf8_general_ci   |     NULL |          
| table_stats               | MyISAM |   
 utf8_bin          |     NULL |          
| tables_priv               | MyISAM |   
 utf8_bin          |     NULL |          
| time_zone                 | MyISAM |   
 utf8_general_ci   |     NULL |          
| time_zone_leap_second     | MyISAM |   
 utf8_general_ci   |     NULL |          
| time_zone_name            | MyISAM |   
 utf8_general_ci   |     NULL |          
| time_zone_transition      | MyISAM |   
 utf8_general_ci   |     NULL |          
| time_zone_transition_type | MyISAM |   
 utf8_general_ci   |     NULL |          
| user                      | MyISAM |   
 utf8_bin          |     NULL |          
+---------------------------+--------+---

even if i try to convert them to innodb it throws an error

MariaDB [mysql]> alter table user ENGINE=INNODB ;
ERROR 1025 (HY000): Error on rename of './mysql/#sql-1597_279' to './mysql/user' (errno: -1 "Internal error < 0 (Not system error)")
MariaDB [mysql]>                                   



 Comments   
Comment by Elena Stepanova [ 2014-12-27 ]

System tables are MyISAM so far, it's intentional and not a bug.
For advice on how to deal with them in Galera context, I recommend to ask the question at codership-team@googlegroups.com, as it's a common issue for all Galera-based clusters, not just MariaDB Galera cluster. You'll get wider expert opinion there.

Generated at Thu Feb 08 07:19:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.