On Monday, I asked if there were consultants out there who could help set up an
NDB high availability system. As I compared our needs to NDB, it became
obvious that NDB was not the answer and more obvious that simply adding high
availability processes to our existing Innodb system was.
So, I
OK, I understand. Just seems "wrong" to have a link visible to the general
public, but the page is inaccessible.
> -Original Message-
> From: Shawn Green [mailto:shawn.l.gr...@oracle.com]
> Sent: Tuesday, July 17, 2012 11:33 AM
> To: mysql@lists.mysql.com
> Subject: Re: GA download rever
(Only for portuguese speaker colaborators of this list.
Para os colaboradores de língua portuguesa desta lista de discussão.)
Prezados,
Segue a divulgação de uma nova ferramenta para monitoramento e otimização de
servidores de bancos de dados MySQL.
Interface e suporte em português. Vale a pena
On 12-07-16 06:57 PM, Rick James wrote:
Plan A:
Would the anti-UNION problem be solved by hiding the UNION in a subquery? The
outer query would simply return what the UNION found.
Of course! Yes, problem solved.
Plan B:
Insert every row twice into expression_expression -- (e1,e2) and also
Hello Rick
On 7/16/2012 5:54 PM, Rick James wrote:
Shawn, can you explain why one of the links on that page is broken?
http://bugs.mysql.com/bug.php?id=14248833
Says
"No such bug #14248833 or bug is referenced in the Oracle bug system."
That's the wrong bug system to see that bug. I
Oops, there should be an ORDER BY.
We Your B,C formula is equivalent to mine; I simplified it by dividing out C.
Anyway, I like your way of describing it.
This might be a 'good' initial value:
SELECT @a := AVG(Value) FROM tbl;
or, maybe
SELECT @a := AVG(Value) FROM tbl WHERE ...; -- selecting o
2012/07/16 14:25 -0700, Rick James
Here's a different way to "smooth" numbers. It uses an exponential moving
average instead of "the last 5".
SELECT Time,
@a := (9 * @a + Value) / 10 AS moving_avg
FROM tbl
JOIN ( SELECT @a := 0 ) AS x;
Notes:
* Make 10 larger or smaller, depe