in 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
...@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 requirement
On Wed, Jun 13, 2012 at 11:52 PM, Rick James rja...@yahoo
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.commailto:mysql@lists.mysql.com
Subject: Re: NoSQL help
can u share the sql, explain plan, indexes etc,
show
. this is 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's
: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's are running
On Thu, Jun 14, 2012 at 3:03 PM, Manivannan S.
manivanna...@spanservices.com wrote
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 below,
Full table scan is happening
@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 am maintaining 60days records because the user will try to generate
- Original Message -
From: Manivannan S. manivanna...@spanservices.com
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?
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
[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. manivanna...@spanservices.com
Hi all,
[lots of data]
[slow reports]
[wooo NoSQL magic]
Not that I want
, 24 hourly partitions are rolled into a new daily
partition and the 90-day old partition is DROPped.
-Original 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
11 matches
Mail list logo