Re: [rt-users] DB performance

2010-06-04 Thread Agnislav Onufrijchuk
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

2010-06-03 Thread Torsten Brumm
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

2010-06-03 Thread 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