Hi there,
I wanted to sort the records in one of my tables (205,000,000 entries) to test if this
will give me any speed increase.
It is an MyISAM table, and was trying to use myisamchk -R 2 user.
But what I get in return is a core dump and that the index file is not working
anymore...
I am using MySQL 4.0.12
on IRIX 6.5 release 15m
create statement:
CREATE TABLE `user` (
`e mail` varchar(100) NOT NULL default '',
`phoneNr` varchar(20) NOT NULL default '',
`id` smallint(5) unsigned NOT NULL auto increment,
`username` varchar(10) NOT NULL default '',
`password` varchar(10) NOT NULL default '',
`firstname` varchar(100) default '',
`lastname` varchar(100) default '',
`group ref` tinyint(3) unsigned default NULL,
`comment` varchar(20) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) TYPE=MyISAM;
Unfortunately I can't find a way to get around this problem.
Can you help me?
Thanks a lot
Bernd
=====================================================================
Please note that this e-mail and any files transmitted with it may be
privileged, confidential, and protected from disclosure under
applicable law. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this
message to the intended recipient, you are hereby notified that any
reading, dissemination, distribution, copying, or other use of this
communication or any of its attachments is strictly prohibited. If
you have received this communication in error, please notify the
sender immediately by replying to this message and deleting this
message, any attachments, and all copies and backups from your
computer.
