About instance DB utilization at 95%.

Ajay95
Tera Contributor

‎08-25-2023 04:11 AM

Hi,

We have QA instance for which Maria DB is getting utilized more than 95%. And we are also able to see some huge size of files with .IBD extension. For example sys_attachment_doc_345345.ibd.

 

Can we access those .ibd files and from where?

 

Can we delete those files or is there any other way to minimize the DB utilization?

0 Helpfuls
  • 273 Views
2 REPLIES 2

Maik Skoddow
Tera Patron
Tera Patron

‎08-25-2023 04:28 AM

Hi

at table  sys_attachment_doc the chunks of an attachment are stored and if in your instance many attachments are stored your only chance to reduce the DB utilization is checking why so many attachments have been added. Unfortunately many users/customers forget that ServiceNow is no file store and thus should find alternatives for storing many files.

Maik

0 Helpfuls

Ajay95
Tera Contributor
In response to Maik Skoddow

‎08-25-2023 06:10 AM

Thanks Maik for your input.

 

But if customer does not want to store attachment other than sys_attachment. Then what would be the option can we delete those .ibd files?

0 Helpfuls