High innodb_lock_wait_timeout values ​​on mysql

Question

we are trying to get some statistics on our large log tables in MySQL. Some select queries take too long to complete and throw exceptions like:
Raised: java.sql.SQLException: lock timeout was exceeded; try restarting the transaction.
This leads to the fact that our application stops working with the same error. After some research, we decided to change the "innodb_lock_wait_timeout" variable of our MySQL server configuration.

But what are the disadvantages of this configuration?

Answer 1

. . , linux mytop , EXPLAIN, , . / , .

, MariaDB (fork of MySQL) , , .

Answer 2

, , - , . , CREATE TABLE AS SELECT * FROM table_x..., , -, table_x InooDB.

innodb_locks_unsafe_for_binlog true ( my.cnf innodb_locks_unsafe_for_binlog=1). InnoDB.

. .