st...@edberg-online.com schrieb:
> At 11:10 AM +0530 6/13/09, Krishna Chandra Prajapati wrote:
>> Hi guys,
>>
>> I'm working in a telecom company. I have table called deliverylog in which
>> 30 million records gets inserted per/day. The table has grown to 0.5TB I
>> have to keep 60days record in
At 11:10 AM +0530 6/13/09, Krishna Chandra Prajapati wrote:
>Hi guys,
>
>I'm working in a telecom company. I have table called deliverylog in which
>30 million records gets inserted per/day. The table has grown to 0.5TB I
>have to keep 60days record in the table. So, 60days * 30 million = 1800
>mil
My first thought was: Archive Storage Engine;
http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html
But then I read "fetch the result", so you're not only inserting data,
but also doing some queries on it? Can you show the queries and your
model?
On Sat, Jun 13, 2009 at 07:40, Krishna
Hi guys,
I'm working in a telecom company. I have table called deliverylog in which
30 million records gets inserted per/day. The table has grown to 0.5TB I
have to keep 60days record in the table. So, 60days * 30 million = 1800
million records. The query is taking a lot of time to fetch the resul