Hi all,
Currently i am doing performance level tuning of some queries that are
running very slow in my slow -query log. Below are the sample of some
queries & the cardinality of indexes :-
--- Below queries take more than 15 minutes to complete on a table
scd_table of size 7 GB
SELECT t0.id, t0.be
I'm pretty sure all is well...
In one case, I think I have 4.1 client talking to 5.5 server.
> -Original Message-
> From: Honza Horak [mailto:hho...@redhat.com]
> Sent: Monday, September 17, 2012 2:53 AM
> To: Reindl Harald
> Cc: mysql@lists.mysql.com
> Subject: Re: Older mysql client with
If the subquery-version is not too slow, live with it.
If necessary, make your non-grouped SELECT a subquery and apply GROUP BY
outside. Thus:
SELECT ... FROM ( SELECT non-grouped... ) GROUP BY ...
Could you provide that; we might be able to simplify it.
Also provide SHOW CREATE TABLE for each
> -Original Message-
> From: Rick James [mailto:rja...@yahoo-inc.com]
> Sent: September 17, 2012 3:04 PM
> To: peter.braw...@earthlink.net; mysql@lists.mysql.com
> Subject: RE: function INTERVAL in view
>
> INTERVAL is a keyword. This is probably the root of the hiccup.
> Is that your Sto
INTERVAL is a keyword. This is probably the root of the hiccup.
Is that your Stored Function? Or UDF?
> -Original Message-
> From: Peter Brawley [mailto:peter.braw...@earthlink.net]
> Sent: Monday, September 17, 2012 11:12 AM
> To: mysql@lists.mysql.com
> Subject: Re: function INTERVAL i
n 2012-09-17 12:58 PM, h...@tbbs.net wrote:
My MySQL is of version 5.5.8-log. I find I cannot save a query with INTERVAL in
a view: redundant round brackets are added. If the query is
SELECT INTERVAL(1, 2, 3, 4)
within the frm file there is the expression
interval((1, 2, 3, 4))
which is wron
My MySQL is of version 5.5.8-log. I find I cannot save a query with INTERVAL in
a view: redundant round brackets are added. If the query is
SELECT INTERVAL(1, 2, 3, 4)
within the frm file there is the expression
interval((1, 2, 3, 4))
which is wrong.
What is known about this?
--
MySQL Gene
On 09/17/2012 11:08 AM, Reindl Harald wrote:
Am 17.09.2012 10:53, schrieb Honza Horak:
I'm thinking about compatibility issues between older mysql client (say 5.0.x
or 5.1.x) with newer mysql server
(5.5.x or 5.6.x). After some tests I've noticed no issues and it seems to work
just fine. Is an
Am 17.09.2012 10:53, schrieb Honza Horak:
> I'm thinking about compatibility issues between older mysql client (say 5.0.x
> or 5.1.x) with newer mysql server
> (5.5.x or 5.6.x). After some tests I've noticed no issues and it seems to
> work just fine. Is anybody aware of some
> problems that I
Hi experts,
I'm thinking about compatibility issues between older mysql client (say
5.0.x or 5.1.x) with newer mysql server (5.5.x or 5.6.x). After some
tests I've noticed no issues and it seems to work just fine. Is anybody
aware of some problems that I can expect?
Cheers,
Honza
--
MySQL G
10 matches
Mail list logo