re: mysqlcheck 5.5 -a -o
On Mon, 2011-01-17 at 14:50 +0200, Michael Widenius wrote: > 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. > 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. > Thanks Monty > Regards, > Monty > > PS: Have you tried out MariaDB yet? I regrettably confess, not yet signature.asc Description: This is a digitally signed message part
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=arch...@jab.org
mysqlcheck 5.5 -a -o
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. signature.asc Description: This is a digitally signed message part