Re: [rt-users] DB performance
03.06.2010 17:23, rmp dmd wrote: > Hi, > > Currently our RT DB is about 308M. Not much but with nagios alerts, > production issues, customer problems, Im seeing the DB growing quickly. > > I need to make sure that DB will not affect the RT performance. > > Kindly help on how I can check DB integrity, and make sure that DB will not > slow RT. > The first question is: what db do you use? mysql/postgres/oracle? Different DBs requires different approaches. The second question is: what db do you use? The third and the rest of questions are rely on DB. -- Agnislav Onufrijchuk PortaOne, Inc., RT Developer Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7670 PortaOne Booth 3H1-10, Hall 3 Canadian Pavilion @ CommunicAsia Singapore Expo, June 15-18, 2010 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] DB performance
More details are helpful! How does your setup looks like? Hardware? Software? etc... Torsten 2010/6/3 rmp dmd > Hi, > > Currently our RT DB is about 308M. Not much but with nagios alerts, > production issues, customer problems, Im seeing the DB growing quickly. > > I need to make sure that DB will not affect the RT performance. > > Kindly help on how I can check DB integrity, and make sure that DB will not > slow RT. > > I've been googling but the information are not sufficient. > > > Thanks! > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- MFG Torsten Brumm http://www.brumm.me http://www.elektrofeld.de Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] DB performance
Hi, Currently our RT DB is about 308M. Not much but with nagios alerts, production issues, customer problems, Im seeing the DB growing quickly. I need to make sure that DB will not affect the RT performance. Kindly help on how I can check DB integrity, and make sure that DB will not slow RT. I've been googling but the information are not sufficient. Thanks! Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com