Mysql [Warning] max_join_size error Solution

This article introduces how to solve the mysql [Warning] max_join_size error. If you need it, let's take a look.

This article introduces how to solve the mysql [Warning] max_join_size error. If you need it, let's take a look.

100716 06:32:45 d started
100716 6:32:45 [Warning] option 'max _ join_size ': unsigned value 18446744073709551615 adjusted to 4294967295
100716 6:32:45 [Warning] option 'max _ join_size ': unsigned value 18446744073709551615 adjusted to 4294967295
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100716 6:32:45 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the. ibd files...
100716 06:36:23 mysqld ended

When mysql is started on the server, an error is reported and cannot be started, as shown in the preceding log.

Solution
In my. cnf configuration file under etc, add

The Code is as follows:
Max_join_size = 4294967295

I solved the problem in this way.