----- Original Message ----- From: "Bernd Jagla" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 03, 2003 1:14 PM Subject: Re: sort-records
> Yup, I guess I set parameters too high... > > Thanks > > Bernd > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, July 03, 2003 1:09 PM > Subject: Re: sort-records > > > I forgot to ask you how big machine you use. Because mysql makes sort in > temp table. If you set the parameters about tmp, heap, sort size are not > proper, if will core dump. Your memory size and tmp(mysql tmp, not /tmp) > disk size also can make core dump. > > > ----- Original Message ----- > From: "Bernd Jagla" <[EMAIL PROTECTED]> > To: "mysql" <[EMAIL PROTECTED]> > Sent: Thursday, July 03, 2003 12:49 PM > Subject: sort-records > > > 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. > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
