Re: MySQL runs on 16-cores server

2009-04-13 Thread mos
At 02:21 PM 4/13/2009, Baron Schwartz wrote: Mike, > MySQL does not scale well beyond 4 processors, at least not like PostgreSql > does. MySQL seems to hit a plateau rather quickly. If XtraDb's modified > Innodb plugin scales better, then fine. But I haven't seen any benchmarks > showing the sp

Re: MySQL runs on 16-cores server

2009-04-13 Thread Baron Schwartz
On Mon, Apr 13, 2009 at 8:34 PM, David Sparks wrote: >> Right now if you want a more scalable *current* version of >> MySQL, you need to look to the Google patches, the Percona builds (and >> Percona XtraDB, a fork of InnoDB), or OurDelta builds. > > Is there a webpage somewhere that compares and

Re: MySQL runs on 16-cores server

2009-04-13 Thread David Sparks
> Right now if you want a more scalable *current* version of > MySQL, you need to look to the Google patches, the Percona builds (and > Percona XtraDB, a fork of InnoDB), or OurDelta builds. Is there a webpage somewhere that compares and contrasts the above patchsets? I thought the Google patches

Thoroughbred data to MySQL

2009-04-13 Thread Carl
I have a customer that has a five year old system that runs on Thoroughbred (Thoroughbred Software International) data. Has anyone ever been successful converting Thoroughbred data to MySQL? If so, how did you do it? Thanks, Carl

RE: MySQL runs on 16-cores server

2009-04-13 Thread Wm Mussatto
On Mon, April 13, 2009 11:55, mos wrote: > Jerry, > > At 09:53 AM 4/13/2009, Jerry Schwartz wrote: >>Sorry for top-posting, but this is getting unwieldy. >> >>The problems with hardware in multiprocessor systems have been dealt with >>long since, assuming that Intel, AMD, et al have implemented the

Re: find records with only numbers

2009-04-13 Thread Claudio Nanni
He is looking only for six digit numbers. select field1 as f from table1 t where t.f regexp '^[0-9]{6}$' does the job Claudio Pinter Tibor wrote: Ed Reed wrote: I hope someone can give me a suggestion on this. I'd like to find records in a table where a specific field only contains a num

Re: find records with only numbers

2009-04-13 Thread Pinter Tibor
Ed Reed wrote: I hope someone can give me a suggestion on this. I'd like to find records in a table where a specific field only contains a number. For example, Select Field1 as f from table1 as t where lcase(t.f) not like in ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p',

Re: find records with only numbers

2009-04-13 Thread Claudio Nanni
Hi, this can be easily solved by using regular expressions. select field1 as f from table1 t where t.f regexp '[0-9]{6}' Cheers Claudio Nanni Ed Reed wrote: I hope someone can give me a suggestion on this. I'd like to find records in a table where a specific field only contains a number.

find records with only numbers

2009-04-13 Thread Ed Reed
I hope someone can give me a suggestion on this. I'd like to find records in a table where a specific field only contains a number. For example, Select Field1 as f from table1 as t where lcase(t.f) not like in ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','

Re: MySQL runs on 16-cores server

2009-04-13 Thread Baron Schwartz
Mike, > MySQL does not scale well beyond 4 processors, at least not like PostgreSql > does. MySQL seems to hit a plateau rather quickly. If XtraDb's modified > Innodb plugin scales better, then fine.  But I haven't seen any benchmarks > showing the speed improvements relative to the number of proc

RE: MySQL runs on 16-cores server

2009-04-13 Thread mos
Jerry, At 09:53 AM 4/13/2009, Jerry Schwartz wrote: Sorry for top-posting, but this is getting unwieldy. The problems with hardware in multiprocessor systems have been dealt with long since, assuming that Intel, AMD, et al have implemented the solutions. Ten years ago and more, I worked with ma

RE: LEFT JOIN with third-table key

2009-04-13 Thread Jerry Schwartz
>-Original Message- >From: shawn.gr...@sun.com [mailto:shawn.gr...@sun.com] >Sent: Saturday, April 11, 2009 3:50 PM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: LEFT JOIN with third-table key > >Jerry Schwartz wrote: >> This is a question that I run into frequently; I migh

RE: MySQL runs on 16-cores server

2009-04-13 Thread Jerry Schwartz
Sorry for top-posting, but this is getting unwieldy. The problems with hardware in multiprocessor systems have been dealt with long since, assuming that Intel, AMD, et al have implemented the solutions. Ten years ago and more, I worked with machines capable of 128 processors and they seemed to wor

Re: Error code 121

2009-04-13 Thread Kaushal Shriyan
On Mon, Apr 13, 2009 at 4:21 PM, Martin Gainty wrote: > dupe key.. > > http://planet.mysql.com/entry/?id=18404 > > Martin > __ > Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note > de déni et de confidentialité > > This messag

Re: Error code 121

2009-04-13 Thread Krishna Chandra Prajapati
Give the details what you are doing which gives the below issue. On Mon, Apr 13, 2009 at 4:03 PM, Kaushal Shriyan wrote: > On Mon, Apr 13, 2009 at 3:21 PM, Krishna Chandra Prajapati < > prajapat...@gmail.com> wrote: > >> prajap...@debian:~$ perror 121 >> OS error code 121: Remote I/O error >> >>

Re: Error code 121

2009-04-13 Thread Kaushal Shriyan
On Mon, Apr 13, 2009 at 3:21 PM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > prajap...@debian:~$ perror 121 > OS error code 121: Remote I/O error > > > On Mon, Apr 13, 2009 at 3:16 PM, Kaushal Shriyan > wrote: > >> Hi >> >> what does error 121 means in mysql. is there a way to fi

Re: Error code 121

2009-04-13 Thread Krishna Chandra Prajapati
prajap...@debian:~$ perror 121 OS error code 121: Remote I/O error On Mon, Apr 13, 2009 at 3:16 PM, Kaushal Shriyan wrote: > Hi > > what does error 121 means in mysql. is there a way to find out the > description of error code 121. > > Thanks and Regards > > Kaushal > -- Krishna Chandra Praj

Error code 121

2009-04-13 Thread Kaushal Shriyan
Hi what does error 121 means in mysql. is there a way to find out the description of error code 121. Thanks and Regards Kaushal

Re: Client Programs

2009-04-13 Thread Claudio Nanni
Hi you need a mysql client program. It can be any software capable of connecting to mysql server deamon. Usually you use the 'mysql' client program that is built-in the server software, in this case you need an installation of mysql also on the other machine. Or you can use MySQL Query browser incl

Client Programs

2009-04-13 Thread Manish Gupta
How do i run a mysql client program on a computer connected to the computer which has the mysql server installed and configured. the host computer does not have the mysql installed in any form. Regards -- Manish Gupta Follow me on twitter: twitter.com/nimbus3000