Re: [rt-users] What's huge RT/Mysql

2015-11-11 Thread Arkadiusz Miśkiewicz
On Wednesday 11 of November 2015, Daniel Schwager wrote: > Hi JAS, > > > For normal usage it works fast. The number of tickets is only a problem > > for searching. Here we still use sphinx and searching is quite slow. > > .. > > > Going to try mysql builtin fulltext next (that won't fix session

Re: [rt-users] What's huge RT/Mysql

2015-11-11 Thread Arkadiusz Miśkiewicz
On Wednesday 04 of November 2015, Albert Shih wrote: > Hi everyone, > > I would like to know without any customisation how can a RT instance with > mysql backend can goes. Almost 2 000 000 tickets here (total), mysql DB is about 120GB, two rotational SATA disks in raid1 array. > As I

Re: [rt-users] What's huge RT/Mysql

2015-11-11 Thread Daniel Schwager
Hi JAS, > For normal usage it works fast. The number of tickets is only a problem for > searching. Here we still use sphinx and searching is quite slow. .. > Going to try mysql builtin fulltext next (that won't fix session problem but > has potential to be faster). Currently, we are going to

Re: [rt-users] What's huge RT/Mysql

2015-11-10 Thread Christian Loos
Hi, we have over 30 tickets and process 8 tickets a year. We currently use a single VM for our RT (Webserver and Database on the same Machine). And our RT is still really fast. Thanks to the BPS developers. Chris Am 04.11.2015 um 22:23 schrieb Albert Shih: > Hi everyone, > > I would

Re: [rt-users] What's huge RT/Mysql

2015-11-04 Thread Matt Zagrabelny
On Wed, Nov 4, 2015 at 3:23 PM, Albert Shih wrote: > Hi everyone, > > I would like to know without any customisation how can a RT instance with > mysql backend can goes. We use Pg, but there are places using MySQL that have many tickets. > > As I understand it's the number

[rt-users] What's huge RT/Mysql

2015-11-04 Thread Albert Shih
Hi everyone, I would like to know without any customisation how can a RT instance with mysql backend can goes. As I understand it's the number of tickets who can be a issue. Sowhen it's can become a problem ? 50 000 ? 100 000 ? 500 000 ? And same question with specific hardware (like mysql

Re: [rt-users] What's huge RT/Mysql

2015-11-04 Thread Albert Shih
Le 04/11/2015 à 23:27:53+0100, Torsten Brumm a écrit > Ok, we do around 800.000-1.000.000 Tickets a day. The DB is running since 14 > years now. Don't See Any Problems with such small amount of Tickets. What ? 1 000 000 tickets per day ? How that's possible ? from 14 years ? that's mean

Re: [rt-users] What's huge RT/Mysql

2015-11-04 Thread Torsten Brumm
Ok, we do around 800.000-1.000.000 Tickets a day. The DB is running since 14 years now. Don't See Any Problems with such small amount of Tickets. Von meinem iPhone gesendet > Am 04.11.2015 um 22:23 schrieb Albert Shih : > > Hi everyone, > > I would like to know without