Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Supersize Database

web-app

I have a Gemini (2.2.6) installation that has been running for just over a year, and the busy beavers have logged almost 30,000 issues.

The server team had a look at the database however and it's 5Gb.  I know there are a good few issues but should it really be this big or is there something else causing the swelling?  The only think i can think of is there are a few custom fields but all the field sizes seem reasonable enough.

Comments much appreciated.
voods
· 1 		voods
Wednesday, March 11, 2009, 3:19:01 PM
Replies (4)
helpful
0
not helpful

Check the number of attachments and the log file.
Mark Wing
· 9108 		Mark Wing
Wednesday, March 11, 2009, 3:54:43 PM
helpful
0
not helpful

I had a look at the database.

The .mdf is 5515MB, the log is 24MB and the issueattachments table is 55MB.

The issuealerts table however is 5.1GB there are around 30,000 records in the table.

Any idea how i can fix this without breaking the system? (system uses the MailPlugin)

Thanks in advance
voods
· 1 		voods
Wednesday, March 18, 2009, 12:01:51 PM
helpful
0
not helpful

Truncate the issuealerts table, it is only used by the scheduler.
Mark Wing
· 9108 		Mark Wing
Wednesday, March 18, 2009, 1:33:15 PM
helpful
0
not helpful

Cheers, have cleaned out the table.
voods
· 1 		voods
Wednesday, March 18, 2009, 2:29:01 PM