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
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
records for 60 days then that will cross 150GB of da
12 matches
Mail list logo