mysqlcheck 5.5 -a -o

--=-8Cq1X4pg8C8xy9r7oHwo
Content-Type: multipart/alternative; boundary="=-2tTKy34ejapvYKxpW7w4"


--=-2tTKy34ejapvYKxpW7w4
Content-Type: text/plain; charset="ISO-8859-15"
Content-Transfer-Encoding: quoted-printable

In all previous versions we were able to run -Aao --auto-repair

Anyone know WHY, in 5.5, -a and -o , must be run separately, this
is kind of silly I think, requiring two passes now.



--=-2tTKy34ejapvYKxpW7w4
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable








In all previous versions we were able to run -Aao --auto-repair



Anyone know WHY, in 5.5,   -a   and   -o =
; , must be run separately, this is kind of silly I think, requiring two pa=
sses now.








--=-2tTKy34ejapvYKxpW7w4--

--=-8Cq1X4pg8C8xy9r7oHwo
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iQEcBAABAgAGBQJNM7NTAAoJECg/hgl/0DbH9wMH/3mxE3C6tdVXOcphPerW 338P
blPYbgpqnVyQsdoWzopg2UX2MzmyseC++tsUCPHDi5tUX+glJgTimxmiJqem atjC
Bsad/cSKOlaMPx4qCIZXsMqj2LD/2h+fvVpiBrO58ClRyXO4/H/VgULhDkG9 ym40
8q6hCNW+vKQOCvECJzWWQB6nAnbxp3pZdVSykD8oxT2Nv/ymUti7u+tKE/Qr Urtq
PIywZfPWtOV/WHX/Ty+PH5/3IybET4UDKYVkO5QQcfCbqeOces8D/GjET6UO 37Oy
rqbYZCh1zMJ/CQ31UCdDe2+UlwFI/vTW8I93BspYCE2sPHKSusuefb6ZNQAH KHQ=
=Asn3
-----END PGP SIGNATURE-----

--=-8Cq1X4pg8C8xy9r7oHwo--

re: mysqlcheck 5.5 -a -o

Hi!

>>>>> "Noel" == Noel Butler writes:

Noel> In all previous versions we were able to run -Aao --auto-repair

Noel> Anyone know WHY, in 5.5, -a and -o , must be run separately, this
Noel> is kind of silly I think, requiring two passes now.

I checked the 5.0 code and even there you could not run 'a' and 'o'
separately. mysqlcheck always used the later option.

However as optimize for most engines that supports it does an
automatic analyze, you can solve your problem by just removing the
'a' option above.

Regards,
Monty

PS: Have you tried out MariaDB yet?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

re: mysqlcheck 5.5 -a -o

--=-JZDOwV7PaKUH/U+ZoESw
Content-Type: multipart/alternative; boundary="=-HCNqo3b7QAWj0vsAWutn"


--=-HCNqo3b7QAWj0vsAWutn
Content-Type: text/plain; charset="ISO-8859-15"
Content-Transfer-Encoding: quoted-printable

On Mon, 2011-01-17 at 14:50 +0200, Michael Widenius wrote:

> Hi!
>=20
> >>>>> "Noel" == Noel Butler writes:
>=20
> Noel> In all previous versions we were able to run -Aao --auto-repair
>=20
> Noel> Anyone know WHY, in 5.5, -a and -o , must be run separately,=
this
> Noel> is kind of silly I think, requiring two passes now.
>=20
> I checked the 5.0 code and even there you could not run 'a' and 'o'
> separately. mysqlcheck always used the later option.
>=20


Ahhh, so all that time it was silently ignoring the -a ? But now borks
instead of ignores, my bad :)


> However as optimize for most engines that supports it does an
> automatic analyze, you can solve your problem by just removing the
> 'a' option above.
>=20


Thanks Monty


> Regards,
> Monty
>=20
> PS: Have you tried out MariaDB yet?


I regrettably confess, not yet


--=-HCNqo3b7QAWj0vsAWutn
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable








On Mon, 2011-01-17 at 14:50 +0200, Michael Widenius wrote:

Hi!



>>>>> "Noel" == Noel Butler <
lto:noel.butler@ausics.net">noel.butler@ausics.net> writes:



Noel> In all previous versions we were able to run -Aao --auto-repair



Noel> Anyone know WHY, in 5.5,   -a   and   -o  , must be run separately=

, this

Noel> is kind of silly I think, requiring two passes now.



I checked the 5.0 code and even there you could not run 'a' and 'o'

separately.  mysqlcheck always used the later option.

However as optimize for most engines that supports it does an

automatic analyze, you can solve your problem by just removing the

'a' option above.

Regards,

Monty



PS: Have you tried out MariaDB yet?