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

[Darren Nickerson]

>>>>> 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  ,

Ew.

  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