Are Single Column Indexes are sufficient

2012-09-17 Thread Adarsh Sharma
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

RE: Older mysql client with newer server compatibility

2012-09-17 Thread Rick James
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

RE: Making myself crazy...

2012-09-17 Thread Rick James
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

RE: function INTERVAL in view

2012-09-17 Thread Steven Staples
> -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

RE: function INTERVAL in view

2012-09-17 Thread Rick James
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

Re: function INTERVAL in view

2012-09-17 Thread Peter Brawley
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

function INTERVAL in view

2012-09-17 Thread hsv
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

Re: Older mysql client with newer server compatibility

2012-09-17 Thread Honza Horak
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

Re: Older mysql client with newer server compatibility

2012-09-17 Thread Reindl Harald
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

Older mysql client with newer server compatibility

2012-09-17 Thread Honza Horak
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