Re: Practical connection limits MySQL 5.1/5.5

eBay once developed a patch for pooled threads, on top of 5.0, to resolve this kind of issue so they can support 10k+ sessions(massive amount of application need to talk to those mysql). Not sure whether they are merged into main version though. Best regards Zhuchao 在 2011-4-14，17:59，Rei

Re: WHERE does not work on calculated view field - Found word(s) list error in the Text body

Hi, On 04/25/11 20:45, Larry McGhaw wrote: My best advice is to not use a custom MySQL function in a view when the parameter to that function is a column or expression that has the potential to result in NULL because of being on the right side of a left outer join (or the left side of a right

RE: WHERE does not work on calculated view field - Found word(s) list error in the Text body

Hello Daniel, My best advice is to not use a custom MySQL function in a view when the parameter to that function is a column or expression that has the potential to result in NULL because of being on the right side of a left outer join (or the left side of a right outer join). This particula

Join based upon LIKE

I have to match lists of new publications against our database, so that I can replace the existing publications in our catalog. For example, "The UK Market for Puppies in February 2011" would be a replacement for "The UK Market for Puppies in December 2010" Unfortunately, the publishers aren't

Re: Are those patches already includes in 5.5 community version?

Just looked at version 5.5/5.6 document: http://dev.mysql.com/doc/refman/5.5/en/memory-storage-engine.html at least the variable length memory patch is not included, i guess same with others; It is disappointed MySQL is not including those into the 5.5/5.6 version; BTW: i was reading http://ronald

Re: LEFT JOIN and WHERE: identical or not and what is better?

Hi Andre, everybody! Andre Polykanine wrote: > Hello everyone, > Sorry for my beginner question. Actually I have been using MySql for a > long time but I just start using some advanced things (earlier I > accomplished those tasks with PHP), so I will be asking stupid > questions, pl

Are those patches already includes in 5.5 community version?

For pathces like : *EBay Patches (5.0)* have included: - variable length memory storage engine - pool of threads - Virtual columns and others like *Google Patches (5.0 & 5.1)* included improvements in : - statistics/monitoring - lock contention - binlog - malloc() - fil

Re: LEFT JOIN and WHERE: identical or not and what is better?

The only difference once MySQL parses these two queries is the first one is a LEFT JOIN, which will produce all records from the blogs table even if there is no matching record in the users table. The second query produces an INNER JOIN which means only rows with matching records in both tables wil

Re: LEFT JOIN and WHERE: identical or not and what is better?

I can be wrong about that, but I think the difference between them should be irrelevant so it makes me think about a paranoiac thought. For me, the only difference is: Chose the one you feel better to understand your code. Am I wrong or not? -- João Cândido de Souza Neto "Andre Polykanine"

Re: LEFT JOIN and WHERE: identical or not and what is better?

'where' is a filter. You're limiting records based on a criterion. 'on' is used for joining. On Mon, Apr 25, 2011 at 10:42 AM, Andre Polykanine wrote: > Hello everyone, > Sorry for my beginner question. Actually I have been using MySql for a > long  time  but  I  just  start  using some

RE: Memory Usage.

>-Original Message- >From: Andrés Tello [mailto:mr.crip...@gmail.com] >Sent: Monday, April 25, 2011 10:24 AM >To: Mailing-List mysql >Subject: Memory Usage. > >How can I know how memory is being used by Mysql? > >I have 32GB Ram, but I can't make mysql to use more than 12GB Ram , and even >

LEFT JOIN and WHERE: identical or not and what is better?

Hello everyone, Sorry for my beginner question. Actually I have been using MySql for a long time but I just start using some advanced things (earlier I accomplished those tasks with PHP), so I will be asking stupid questions, please bear with me. Here is the first one. We have two que

RE: mysql deal with specail character problem

From: 赵琦 [mailto:tyzha...@gmail.com] Sent: Thursday, April 21, 2011 9:19 PM To: Jerry Schwartz Cc: Johan De Meersman; sstap...@mnsi.net; mysql Subject: Re: mysql deal with specail character problem thanks for reply! The charater set is latin1,and the key field is mangled by the email clien

Re: Memory Usage.

Am 25.04.2011 16:24, schrieb Andrés Tello: > How can I know how memory is being used by Mysql? > > I have 32GB Ram, but I can't make mysql to use more than 12GB Ram , and even > that I have tables over 40GB... > > Thanks! xD depends on storage-engine (myisam or innodb), buffer-sizes, size of th

Memory Usage.

How can I know how memory is being used by Mysql? I have 32GB Ram, but I can't make mysql to use more than 12GB Ram , and even that I have tables over 40GB... Thanks! xD