Is myisam_repair_threads considered safe
am 10.09.2009 21:33:16 von Rob Wultsch
myisam_repair_threads
"If this value is greater than 1, MyISAM table indexes are created in
parallel (each index in its own thread) during the Repair by sorting
process. The default value is 1.
Note :Multi-threaded repair is still beta-quality code."
The note is present is all versions of MySQL manual:
http://dev.mysql.com/doc/refman/5.1/en/server-system-variabl es.html#sysvar_myisam_repair_threads
http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html#sysvar_myisam_repair_threads
http://dev.mysql.com/doc/refman/4.1/en/server-system-variabl es.html#sysvar_myisam_repair_threads
Can anyone comment about whether this setting is safe, and if so on
what major versions?
--
Rob Wultsch
wultsch@gmail.com
--
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: Is myisam_repair_threads considered safe
am 18.09.2009 01:22:26 von Eric Bergen
It's been in mysql for at least 7 years.
http://ebergen.net/wordpress/2009/04/11/longest-beta-ever-my isamchk-paralle=
l-recover/
On Thursday, September 10, 2009, Rob Wultsch wrote:
> myisam_repair_threads
>
> "If this value is greater than 1, MyISAM =A0table indexes are created in
> parallel (each index in its own thread) during the Repair by sorting
> process. The default value is 1.
> Note :Multi-threaded repair is still beta-quality code."
>
> The note is present is all versions of MySQL manual:
>
> http://dev.mysql.com/doc/refman/5.1/en/server-system-variabl es.html#sysva=
r_myisam_repair_threads
> http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html#sysva=
r_myisam_repair_threads
> http://dev.mysql.com/doc/refman/4.1/en/server-system-variabl es.html#sysva=
r_myisam_repair_threads
>
>
> Can anyone comment about whether this setting is safe, and if so on
> what major versions?
>
> --
> Rob Wultsch
> wultsch@gmail.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Deric.bergen@g=
mail.com
>
>
--=20
Eric Bergen
eric.bergen@gmail.com
http://www.ebergen.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
Re: Is myisam_repair_threads considered safe
am 19.09.2009 02:01:37 von Rob Wultsch
--00c09fa216fe00feba0473e2f5e3
Content-Type: text/plain; charset=ISO-8859-1
I decided not to use it because of bug 47444 which is a continuation of
earlier bugs...
http://bugs.mysql.com/bug.php?id=47444
On Thu, Sep 17, 2009 at 4:22 PM, Eric Bergen wrote:
> It's been in mysql for at least 7 years.
>
>
> http://ebergen.net/wordpress/2009/04/11/longest-beta-ever-my isamchk-parallel-recover/
>
> On Thursday, September 10, 2009, Rob Wultsch wrote:
> > myisam_repair_threads
> >
> > "If this value is greater than 1, MyISAM table indexes are created in
> > parallel (each index in its own thread) during the Repair by sorting
> > process. The default value is 1.
> > Note :Multi-threaded repair is still beta-quality code."
> >
> > The note is present is all versions of MySQL manual:
> >
> >
> http://dev.mysql.com/doc/refman/5.1/en/server-system-variabl es.html#sysvar_myisam_repair_threads
> >
> http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html#sysvar_myisam_repair_threads
> >
> http://dev.mysql.com/doc/refman/4.1/en/server-system-variabl es.html#sysvar_myisam_repair_threads
> >
> >
> > Can anyone comment about whether this setting is safe, and if so on
> > what major versions?
> >
> > --
> > Rob Wultsch
> > wultsch@gmail.com
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=eric.bergen@gmail.com
> >
> >
>
> --
> Eric Bergen
> eric.bergen@gmail.com
> http://www.ebergen.net
>
--
Rob Wultsch
wultsch@gmail.com
--00c09fa216fe00feba0473e2f5e3--