MySQL Forums
Forum List  »  General

Re: "SHOW VARIABLES" and "mysqladmin variables" show different settings
Posted by: rihad rihad
Date: February 18, 2011 09:25AM

Thanks, problem solved.
man mysql:
Quote

o max_join_size

The automatic limit for rows in a join when using --safe-updates.
(Default value is 1,000,000.)

And I _am_ using safe-updates in the new installation. I really need to fix up my logic: I should have known from the start that max_join_size has _got_ to mean something for updates...

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.