[rtg] MySQL DB help

[Drew Weaver]

I would also like tips / experiences on making the database more
accessible.

We have something like 2.5 billion rows in our tables now.

Any advice is helpful ;-)

-Drew

-----Original Message-----
From: rtg-bounces at lists.grdata.com [mailto:rtg-bounces at lists.grdata.com]
On Behalf Of Andy Fletcher
Sent: Tuesday, April 17, 2007 7:04 AM
To: Patrick Topping
Cc: rtg at lists.grdata.com
Subject: Re: [rtg] MySQL DB help

Sunday, April 15, 2007, 4:35:08 PM, you wrote:

> I am hoping someone can help me with this request...  I am not a DB
> person at all and was hoping a fellow RTG user would be able to assist
> me in setting up indexing in RTG.

Search the archives of this list for the definitive answer, but IIRC
you need to index on the dtime field at least. I've had some success
combining this with other fields, too.

If you're not sure how to add indexes, install phpMyAdmin.

HTH.

Andy.



_______________________________________________
RTG mailing list
RTG at lists.grdata.com
http://lists.grdata.com/mailman/listinfo/rtg