Mysql [Warning] max_join_size error Solution

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.