Re: Limitation of DRBD For MySQL

On 6/18/07, Eric Bergen <[EMAIL PROTECTED]> wrote: Hi, You have hit most of the reasons. One other important one is that if a table or filesystem is corrupted that corruption is propagated over to the drbd slave. My opinion and several other reasons can be found here: http://ebergen.net/wordpres

INNER versus OUTER

I'm using the latest MySQL with InnoDB and something is happening I don't understand. I am going to try this first by paraphrasing my queries since they are complex and have some proprietary info in them. It seems that when a LEFT OUTER or an INNER join will produce the same result and other joins

Re: mysqldump problem with large innodb tables...

My backups use mysqldump, but they have always just worked. I would suggest you try to make a minimal test case that can reproduce the problem and submit it as a bug report, if possible. I'm not familiar with the error message off-hand, but the InnoDB manual is large and complete, so I'm sure

Re: Hiding columns used in GROUP BY and HAVING clauses

Dan Nelson wrote: In the last episode (Jun 18), Edward Kay said: From: Dan Nelson [mailto:[EMAIL PROTECTED] At the moment, I have this and it works: select * from contact_address group by primary_entity_id having count(primary_entity_id) = 1 and is_primary =

Re: Hiding columns used in GROUP BY and HAVING clauses

In the last episode (Jun 18), Edward Kay said: >From: Dan Nelson [mailto:[EMAIL PROTECTED] > > > > > > At the moment, I have this and it works: > > > > > > > > > > select * from contact_address > > > > > group by primary_entity_id > > > > > having count(primary_entity_id) = 1 > >

Re: Change in behaviour in version 5.0.41

Paul DuBois wrote: At 3:29 PM +0100 6/15/07, Ben Clewett wrote: Dear MySql, I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with date comparisons. In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True. In 5.0.41:'2007-06-15' = '2007-06-15 00:00:00' is False.

Re: Change in behaviour in version 5.0.41

At 3:29 PM +0100 6/15/07, Ben Clewett wrote: Dear MySql, I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with date comparisons. In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True. In 5.0.41:'2007-06-15' = '2007-06-15 00:00:00' is False. In 5.1.6-alpha: '

RE: Hiding columns used in GROUP BY and HAVING clauses

> -Original Message- > From: Baron Schwartz [mailto:[EMAIL PROTECTED] > Sent: 18 June 2007 15:53 Sent: 18 June 2007 15:11 > > > > > > > > At the moment, I have this and it works: > > > > select * from contact_address > > group by primary_entity_id > >

Fwd: Re: How to know configure parameters on compiled MySQL

-- Forwarded Message -- Subject: Re: How to know configure parameters on compiled MySQL Date: Monday 18 June 2007 From: David Southwell <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] On Saturday 16 June 2007 02:56:02 Andrey Kumykov wrote: > Hello,all. > There is the function "phpinf

Re: Hiding columns used in GROUP BY and HAVING clauses

Edward Kay wrote: -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: 18 June 2007 15:11 At the moment, I have this and it works: select * from contact_address group by primary_entity_id having count(primary_entity_id) = 1 and is_p

RE: Hiding columns used in GROUP BY and HAVING clauses

> -Original Message- > From: Dan Nelson [mailto:[EMAIL PROTECTED] > Sent: 18 June 2007 15:11 > > > > At the moment, I have this and it works: > > > > > > > > select * from contact_address > > > > group by primary_entity_id > > > > having count(primary_entity_id)

echoing comments in mysql (changed 4.0 to 5.0 ?)

I have a number of database administration shell scripts which construct into a temp file sequences of mysql commands AND comments (in a specific custom format with @log-xxx@ codes) like these /* @log-action@ DATE UPDATE of all correlations for table NAME */ select concat(now(),' UPDATING ALL

Re: Hiding columns used in GROUP BY and HAVING clauses

In the last episode (Jun 18), Edward Kay said: > From: Dan Nelson [mailto:[EMAIL PROTECTED] > > In the last episode (Jun 15), Edward Kay said: > > > I have a table of addresses. Each address is associated with a > > > primary entity and a primary entity can have n different > > > addresses. For eac

How to know configure parameters on compiled MySQL

Hello,all. There is the function "phpinfo" in the PHP interpreter, which allows to know configure options. Is there analog ability in Mysql? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Hiding columns used in GROUP BY and HAVING clauses

> -Original Message- > From: Dan Nelson [mailto:[EMAIL PROTECTED] > Sent: 15 June 2007 19:24 > To: Edward Kay > Cc: MySQL List > Subject: Re: Hiding columns used in GROUP BY and HAVING clauses > > > In the last episode (Jun 15), Edward Kay said: > > I have a table of addresses. Each add

RE: mysql-server-5.1.19 path variable error set on compile

Hi, Set this variable at command line or in your my.cnf. Geoffroy. -Message d'origine- De : David Southwell [mailto:[EMAIL PROTECTED] Envoyé : dimanche 17 juin 2007 17:33 À : mysql@lists.mysql.com Objet : mysql-server-5.1.19 path variable error set on compile # uname -a 6.1-RELEASE F

Re: Limitation of DRBD For MySQL

Hi, You have hit most of the reasons. One other important one is that if a table or filesystem is corrupted that corruption is propagated over to the drbd slave. My opinion and several other reasons can be found here: http://ebergen.net/wordpress/2007/04/02/drbd-in-the-real-world/ -Eric On 6/1