Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.0.15
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]>
|