[rtg] MySQL DB help

[Clayton Dukes (cdukes)]

Hire an SQL Administrator?
 

> -----Original Message-----
> From: rtg-bounces at lists.grdata.com 
> [mailto:rtg-bounces at lists.grdata.com] On Behalf Of Drew Weaver
> Sent: Tuesday, April 17, 2007 7:58 AM
> To: Andy Fletcher; Patrick Topping
> Cc: rtg at lists.grdata.com
> Subject: Re: [rtg] MySQL DB help
> 
> 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
> _______________________________________________
> RTG mailing list
> RTG at lists.grdata.com
> http://lists.grdata.com/mailman/listinfo/rtg
>