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
> 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 all | >> char between 15 and 1 characters long. | >> | &g

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
> 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 all char between 15 and 1 characters long. yesterday i did a alter table mytablename add column (version char(2)); By now (

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 datab

Newbye speed question

2003-10-03 Thread Peer Reiser
HI I am having a MYISAM database with 27 million rows and 19 fields all char between 15 and 1 characters long. yesterday i did a alter table mytablename add column (version char(2)); By now (18 hours later) it has not finished yet? Is there a way to somehow predict the time needed for this? Or t