105472 - no mention that expectbigqueries unnecessary with mysql >=3.23.2

Status: RESOLVED FIXED

(Bugzilla :: Administration, task)

Description

[Myk Melez [:myk] [@mykmelez]]

The MySQL documentation says that setting the SQL_BIG_TABLES option is only
necessary with versions of MySQL older than 3.23.2.

http://www.mysql.com/doc/M/e/Memory_use.html

Installations with newer versions of MySQL have no need to set this option and
shouldn't since it slows down queries, but there is no mention of this in the
explanation of the "expectbigqueries" parameter.

The explanation of this parameter should say something like "Setting this
parameter is only necessary if you are running a version of MySQL older than
3.23.2."

Comment 1

[Dave Miller [:justdave]]

We are currently trying to wrap up Bugzilla 2.16.  We are now close enough to
release time that anything that wasn't already ranked at P1 isn't going to make
the cut.  Thus this is being retargetted at 2.18.  If you strongly disagree with
this retargetting, please comment, however, be aware that we only have about 2
weeks left to review and test anything at this point, and we intend to devote
this time to the remaining bugs that were designated as release blockers.

Comment 2

[Bradley Baetz (:bbaetz)]

Once we require a high enough mysql version, this param can be removed.

Comment 3

[Bradley Baetz (:bbaetz)]

Attachment: v1

we now require 3.23.6, so this param can now be removed

Comment 4

[Bradley Baetz (:bbaetz)]

-> me

Comment 5

[Jouni Heikniemi]

Comment on attachment 90455 [details] [diff] [review]
v1

I have to trust you wrt the MySQL specifics that I'm not so professional with,
but the Perl changes are fine.

2xr=jouni

Comment 6

[Bradley Baetz (:bbaetz)]

Checked in, thanks.