Inspect the CREATE TABLE below:
Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB;
Query Ok, 0 rows affected, 2 warnings (0.11 sec)
Mysql> SHOW WARNINGS;
Which two is true connecting the meaning of the warnings?
A.
The InnoDB storage engine was disabled during server startup.
B.
Global variable skip _innodb was set to ON after the server had started.
C.
The default storage engine MYISAM was used for the table created.
D.
MYSQL server was not started with the option default –storage –engine=InnoDB
E.
Needed to specify TYPE = InnoDB instead of ENGINE=InnoDB
any ideas about the answer?
I don’t know. I assume it’s A and B.
E: is the wrong syntax, my book had nothing on that and https://dev.mysql.com/doc/refman/5.6/en/using-innodb-tables.html said nothing about it either.
C: is wrong
SET default_storage_engine=myisam;
CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB;
show table status from YOUR_DATABASE_NAME;
SHOW WARNINGS;
D: Seems just to be like C, except the server starts off like that.
————————————————————————
Unknown:
A: Something I do not want to try. I tried disabling it but then read there is whole a lot of other things I need to do. https://stackoverflow.com/questions/11772611/how-to-disable-innodb-in-mysql
B: Seems just like A. OFF and SKIP are about the same.
E is wrong they removed type= in 5.1
B is wrong. If the –skip-innodb should be either set as ON during starting the server or restart the server after that.
C is correct. Here is not asking about the reason of warnings, just about the issues related to the warnings.
D is wrong, because the default engine is InnoDB. dont have to specify.
So the answer is A and C
A C
A, B