e 14, 2012 2:33 AM
> To: mysql@lists.mysql.com
> Subject: RE: NoSQL help
>
> I tried with myisam engine also. But it also taking more time to
> generate the report. In my database I am having 8 innodb tables and at
> the same time I am joining 4 tables to get the report.
>
> I a
SHOW CREATE TABLE
SHOW TABLE STATUS
EXPLAIN SELECT ... \G
> -Original Message-
> From: Ananda Kumar [mailto:anan...@gmail.com]
> Sent: Thursday, June 14, 2012 4:04 AM
> To: Manivannan S.
> Cc: mysql@lists.mysql.com
> Subject: Re: NoSQL help
>
> As seen bel
> xl
>
> ref
>
> idx_unique_key_ib_xml\,index_message_id
>
> idx_unique_key_ib_xml
>
> 153
>
> reports.pl.Message_Id
>
> 1
>
> Using where
>
> ** **
>
> Sorry for the previous mailâ¦.. this is my execution plan
my execution plan for 1.5 million
records
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: Thursday, June 14, 2012 3:33 PM
To: Manivannan S.
Cc: mysql@lists.mysql.com
Subject: Re: NoSQL help
can u share the sql, explain plan, indexes etc,
show full processlist out put when the sql'
plan for 1.5 milion records..
From: Ananda Kumar [mailto:anan...@gmail.com]<mailto:[mailto:anan...@gmail.com]>
Sent: Thursday, June 14, 2012 3:33 PM
To: Manivannan S.
Cc: mysql@lists.mysql.com<mailto:mysql@lists.mysql.com>
Subject: Re: NoSQL help
can u share the sql, explain plan,
;
> From: Ananda Kumar [mailto:anan...@gmail.com]
> Sent: Thursday, June 14, 2012 12:32 AM
> To: Rick James
> Cc: Johan De Meersman; Manivannan S.; mysql@lists.mysql.com
> Subject: Re: NoSQL help
>
> Did you try with myisam tables.
> They are supposed to be good for reporting
terms of second, minute, hourly, weekly and Monthly
report also.
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: Thursday, June 14, 2012 12:32 AM
To: Rick James
Cc: Johan De Meersman; Manivannan S.; mysql@lists.mysql.com
Subject: Re: NoSQL help
Did you try with myisam tables.
They are supposed to
sman [mailto:vegiv...@tuxera.be]
> > Sent: Wednesday, June 13, 2012 6:20 AM
> > To: Manivannan S.
> > Cc: mysql@lists.mysql.com
> > Subject: Re: NoSQL help
> >
> >
> > - Original Message -
> > > From: "Manivannan S."
> >
Message-
> From: Johan De Meersman [mailto:vegiv...@tuxera.be]
> Sent: Wednesday, June 13, 2012 6:20 AM
> To: Manivannan S.
> Cc: mysql@lists.mysql.com
> Subject: Re: NoSQL help
>
>
> - Original Message -
> > From: "Manivannan S."
> >
&
At 07:27 AM 6/13/2012, Manivannan S. wrote:
Hi all,
I am using MySQL 5.1, in this I am inserting 5GB of
data for two days into my database. I am trying to generate a
report by processing these data which are available in my database.
Our clients are planning to keep the record
- Original Message -
> From: "Manivannan S."
>
> Hi all,
>
> [lots of data]
> [slow reports]
> [wooo NoSQL magic]
Not that I want to discourage you, but my standard first question is "why do
you think NoSQL (let alone any specific product) is the right solution?" :-)
Don't get me wro
11 matches
Mail list logo
