Re: Newbye speed question - which setup to use for indexing

2003-10-04 Thread Matt W
; Sent: Friday, October 03, 2003 7:49 PM Subject: Re: Newbye speed question - which setup to use for indexing > Jeremy Zawodny wrote: > > >On Fri, Oct 03, 2003 at 06:23:24PM -0400, Ware Adams wrote: > >>Peer Reiser wrote: > >> > >>>Next week I will have access t

Re: Newbye speed question - which setup to use for indexing

2003-10-03 Thread Ware Adams
Jeremy Zawodny wrote: >On Fri, Oct 03, 2003 at 06:23:24PM -0400, Ware Adams wrote: >>Peer Reiser wrote: >> >>>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 o

Re: Newbye speed question - which setup to use for indexing

2003-10-03 Thread Jeremy Zawodny
On Fri, Oct 03, 2003 at 06:23:24PM -0400, Ware Adams wrote: > Peer Reiser wrote: > > >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 >

Re: Newbye speed question

2003-10-03 Thread Michael Brunson
I wonder why you have 19 fields in a single table. I don't think there is really any way to predict it, since it depends on so many different factors. On Fri, 3 Oct 2003 11:19:56 +0200, Peer Reiser <[EMAIL PROTECTED]> wrote: | Fortunately the database is not in production :-) but it should go

RE: Newbye speed question - which setup to use for indexing

2003-10-03 Thread Ware Adams
Andy Eastham wrote: >How big are the table and index files? Can your OS handle files >bigger than 2/4Gb? Yes, OS X can deal with files larger than 4 GB. --Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC

Re: Newbye speed question - which setup to use for indexing

2003-10-03 Thread Ware Adams
Peer Reiser wrote: >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?? No, it won't directly. However, other process

RE: Newbye speed question - which setup to use for indexing

2003-10-03 Thread Andy Eastham
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.

Re: Newbye speed question - which setup to use for indexing

2003-10-03 Thread Peer Reiser
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 inc

Re: Newbye speed question

2003-10-03 Thread Peer Reiser
Fortunately the database is not in production :-) but it should go as soon as possible :-( On viernes, octu 3, 2003, at 11:03 Europe/Madrid, Wang Feng wrote: 18hrs??? So, the database has been LOCKED for 18hrs - Original Message - From: "Peer Reiser" <[EMAIL PROTECTED]> To: <[EMAIL

Re: Newbye speed question

2003-10-03 Thread Wang Feng
18hrs??? So, the database has been LOCKED for 18hrs - Original Message - From: "Peer Reiser" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 03, 2003 6:57 PM Subject: Newbye speed question > HI > > I am having a MYISAM database with 27 million rows and 19 fields