[rt-users] 2.0.9 bogs with >10K tickets

[Jesse Vincent]

On Thu, Dec 20, 2001 at 01:42:39PM -0500, Darren Nickerson wrote:
> 
> >>>>> On Thu, 20 Dec 2001, "Jesse" == Jesse Vincent wrote:
> 
>   Jesse> If you installed 2.0.9, from scratch, it should be up to date on
>   Jesse> indices.  If you upgraded from an earlier rev, the upgrade process
>   Jesse> didn't touch your database.  (We don't have the infratstructure to do
>   Jesse> database frobbing during an update).
> 
> I updated from 2.0.0 recently. Just now, I did:
> 
> 	diff -u rt-2-0-0/etc/schema.mysql rt-2-0-9/etc/schema.mysql
> 
> and that's got me quaking in my boots. LOTS! of changes to the schema besides
> indices, for example:
> 
> 	-  Content LONGBLOB NULL  ,
> 	-  Headers LONGBLOB NULL  ,
> 	+  Content LONGTEXT NULL  ,
> 	+  Headers LONGTEXT NULL  ,
> 

The changes from LONGBLOB to LONGTEXT, iirc, get us case-insensitive searching.
There aren't, to my knowledge, any incompatible changes. You can add all the indices
by hand if you want or you can do a full database dump, install the new schema and indices
and then restore the content from the dump. 

It's probbly also worth looking at your system config.  As I read that, you've got 768M of ram
and 128M of swap, which is full.....Is mysql eating all that ram?

> 
>   Jesse> How much ram is being used on the database server?
> 
> [darren at hewes RT]$ free
>              total       used       free     shared    buffers     cached
> Mem:        770172     761096       9076       9872      43412     264428
> -/+ buffers/cache:     453256     316916
> Swap:       123880     123864         16
> 
> How do you recommend I proceed?
> 
> Thanks!
> 
> -Darren
> 
> 

-- 
http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.