Peer, How big are the table and index files? Can your OS handle files bigger than 2/4Gb?
I've got a table with 55 million rows with just 3 columns all floats. I've got three indexes with all the fields in various orders. My data file is 700Mb but my index file is over 4Gb, so yours could easily be so (as could your data file). Indexing my db takes under 2 hours on a sloooooow 400MHz Sun E250. I don't think the index process will use two processors, but I don't think your problem is related to processor speed. Andy > -----Original Message----- > From: Peer Reiser [mailto:[EMAIL PROTECTED] > Sent: 03 October 2003 10:28 > To: [EMAIL PROTECTED] > Subject: Re: Newbye speed question - which setup to use for indexing > > > Next week I will have access to a new PomerMac G5 with Dual 2GHZ > processors, > and i want to do some indexing. > Does anyone know if MySQL will take advantage of dual processors if the > only process running is the indexing process?? > > Is disk I/O more important ? > > The bad temper of my boss seems to increase exponentially with time and > he thinks that 2 weeks for importing the 27 million rows and indexing > is too slow (he doesnt know anything about informatics, but as i am > missing experience i cannot say if he is right or not). > > anyone tried indexing a large? database? > > thanks a lot > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
