MySql and InnoDB

Good day.

Tell me How right to enable InnoDB engine on mysql57 and check it

Interested in general because of this:

DBD::mysql::db do failed:
Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
 
Yes, not in the tables already InnoDB.
For example:
Code:
 select table_name,engine from information_schema.tables where table_name='software_name';
+---------------+--------+
| table_name    | engine |
+---------------+--------+
| software_name | InnoDB |
+---------------+--------+
1 row in set (0.002 sec)
 
I will not provide such information.
I am not the developer of this software.
log-error mysql contains only successful transactions.
 
Found:

"I am also facing the same issue on the server.

GTID is always-on server, please use below MySQL command to disable GTID.

SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = OFF;
SET @@GLOBAL.GTID_MODE = OFF_PERMISSIVE; "

No errors.
it remains to find how to set these variables at startup service mysql-server.
 
Found:

"I am also facing the same issue on the server.

GTID is always-on server, please use below MySQL command to disable GTID.

SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = OFF;
SET @@GLOBAL.GTID_MODE = OFF_PERMISSIVE; "

No errors.
it remains to find how to set these variables at startup service mysql-server.
... in your my.conf..... it's why i asked for it
 
my.cnf - usually after installation.
And there is no similar GTID.
Simply added at my.cnf these two variables.
 
Back
Top