Myisamchk -R1 option is no more working with MySQL-4.0.4

Hi,

When trying to use the -R1 option of myisamchk, myisamchk fails. (the
behaviour is the same on all my MyISAM tables).

How-to-repeat :

myisamchk -o --tmpdir=/home/mysql/ forumadmin.MYI
- recovering (with keycache) MyISAM-table 'forumadmin.MYI'
Data records: 1

myisamchk -R1 --tmpdir=/home/mysql/ forumadmin.MYI
- Sorting records for MyISAM-table 'forumadmin.MYI'
Data records: 1 Deleted: 0
myisamchk: error: found 0 of 1 records
MyISAM-table 'forumadmin.MYI' is not fixed because of errors

myisamchk -o --tmpdir=/home/mysql/ forumadmin.MYI
- recovering (with keycache) MyISAM-table 'forumadmin.MYI'
Data records: 0
Data records: 1

myisamchk -R1 --tmpdir=/home/mysql/ forumadmin.MYI
- Sorting records for MyISAM-table 'forumadmin.MYI'
Data records: 1 Deleted: 0
myisamchk: error: found 0 of 1 records
MyISAM-table 'forumadmin.MYI' is not fixed because of errors

myisamchk -R1 --tmpdir=/home/mysql/ forumadmin.MYI
- Sorting records for MyISAM-table 'forumadmin.MYI'
Data records: 0 Deleted: 0

myisamchk -r --tmpdir=/home/mysql/ forumadmin.MYI
- recovering (with keycache) MyISAM-table 'forumadmin.MYI'
Data records: 0
Data records: 1

Conclusion : it seems the "found" result of myisamchk -R1 option returns
always 0 instead of the proper records count.

Regards,
Jocelyn Fournier


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12584@lists.mysql.com
To unsubscribe, e-mail

Re: Myisamchk -R1 option is no more working with MySQL-4.0.4

Hi!

On Sep 25, Jocelyn Fournier wrote:
> Hi,
>
> When trying to use the -R1 option of myisamchk, myisamchk fails. (the
> behaviour is the same on all my MyISAM tables).

Fixed, thank you.

Still, I want to note, that -R mode in myisamchk in implemented
not very efficiently. The recommended way is to use

ALTER TABLE ... ORDER BY ...

"myisamchk -R" can be even disabled in the future.

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12590@lists.mysql.com
To unsubscribe, e-mail

Re: Myisamchk -R1 option is no more working with MySQL-4.0.4

Hi Sergei,

Thanks for the tips about ALTER TABLE ... ORDER BY ..., but if want to
optimise all my MyISAM in one shot, it means I have to write a script to
issue the command for each table ?

Regards,
Jocelyn
----- Original Message -----
From: "Sergei Golubchik"
To: "Jocelyn Fournier"
Cc:
Sent: Wednesday, September 25, 2002 4:34 PM
Subject: Re: Myisamchk -R1 option is no more working with MySQL-4.0.4


> Hi!
>
> On Sep 25, Jocelyn Fournier wrote:
> > Hi,
> >
> > When trying to use the -R1 option of myisamchk, myisamchk fails. (the
> > behaviour is the same on all my MyISAM tables).
>
> Fixed, thank you.
>
> Still, I want to note, that -R mode in myisamchk in implemented
> not very efficiently. The recommended way is to use
>
> ALTER TABLE ... ORDER BY ...
>
> "myisamchk -R" can be even disabled in the future.
>
> Regards,
> Sergei
>
> --
> MySQL Development Team
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Sergei Golubchik
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
> /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
> <___/
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail bugs-thread12590@lists.mysql.com
> To unsubscribe, e-mail
>
>
>
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12601@lists.mysql.com
To unsubscribe, e-mail

Re: Myisamchk -R1 option is no more working with MySQL-4.0.4

Hi!

On Sep 25, Jocelyn Fournier wrote:
> Hi Sergei,
>
> Thanks for the tips about ALTER TABLE ... ORDER BY ..., but if want to
> optimise all my MyISAM in one shot, it means I have to write a script to
> issue the command for each table ?

I think so :(

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12602@lists.mysql.com
To unsubscribe, e-mail