-
Type:
Maintenance
-
Status:
Done
-
Priority:
Medium
-
Resolution:
Done
-
Affects Version/s:
None
-
-
-
Company:
All Clients/Multiple Clients
-
We have observed large file growth for the database.
The following folders\files probably need to be looked at as they are the largest:
C:\ProgramData\MySQL\MySQL Server 8.0\Data - 92 GB.
C:\ProgramData\MySQL\MySQL Server 8.0\Data\dms_master\emaillog.ibd - Almost 49GB for this file alone.
{"report":{"apdex":1,"isInitial":true,"journeyId":"d72fa389-64e5-4657-9996-e962fa626d8a","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":915.7999999523163,"redirectCount":0,"resourceLoadedEnd":685.2999999523163,"resourceLoadedStart":321.5,"resourceTiming":[{"duration":35,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":321.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":321.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":356.5,"responseStart":0,"secureConnectionStart":0},{"duration":35,"initiatorType":"link","name":"https://jira.workterra.net/s/dd6a0911920485696ac20493290df627-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/css/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":321.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":321.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":356.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":35.30000001192093,"initiatorType":"link","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":322.0999999642372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":322.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":357.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":35.80000001192093,"initiatorType":"link","name":"https://jira.workterra.net/s/bd548f27bbf8f278bd83b60dd3284ed8-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":322.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":322.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":358,"responseStart":0,"secureConnectionStart":0},{"duration":37.60000002384186,"initiatorType":"link","name":"https://jira.workterra.net/s/70725731a158a7140f19ddbd4201ba27-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":322.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":322.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":360,"responseStart":0,"secureConnectionStart":0},{"duration":228.89999997615814,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":322.5,"connectEnd":322.5,"connectStart":322.5,"domainLookupEnd":322.5,"domainLookupStart":322.5,"fetchStart":322.5,"redirectEnd":0,"redirectStart":0,"requestStart":361,"responseEnd":551.3999999761581,"responseStart":403,"secureConnectionStart":322.5},{"duration":362,"initiatorType":"script","name":"https://jira.workterra.net/s/6ce676f2a5bcc9651cef6e7956f05def-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/js/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":323.2999999523163,"connectEnd":323.2999999523163,"connectStart":323.2999999523163,"domainLookupEnd":323.2999999523163,"domainLookupStart":323.2999999523163,"fetchStart":323.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":362,"responseEnd":685.2999999523163,"responseStart":429.5999999642372,"secureConnectionStart":323.2999999523163},{"duration":107.89999997615814,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/4.1.5/_/download/resources/com.atlassian.plugins.atlassian-chaperone:hotspot-tour/hotspot-tour.js?batch=false&locale=en-US","startTime":323.5,"connectEnd":323.5,"connectStart":323.5,"domainLookupEnd":323.5,"domainLookupStart":323.5,"fetchStart":323.5,"redirectEnd":0,"redirectStart":0,"requestStart":363.19999998807907,"responseEnd":431.39999997615814,"responseStart":430.7999999523163,"secureConnectionStart":323.5},{"duration":108.40000003576279,"initiatorType":"script","name":"https://jira.workterra.net/s/6aa3fcf1fac5fd551eee0b69077524e6-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":323.5999999642372,"connectEnd":323.5999999642372,"connectStart":323.5999999642372,"domainLookupEnd":323.5999999642372,"domainLookupStart":323.5999999642372,"fetchStart":323.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":364.7999999523163,"responseEnd":432,"responseStart":431.5,"secureConnectionStart":323.5999999642372},{"duration":108.90000003576279,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":323.5999999642372,"connectEnd":323.5999999642372,"connectStart":323.5999999642372,"domainLookupEnd":323.5999999642372,"domainLookupStart":323.5999999642372,"fetchStart":323.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":365.89999997615814,"responseEnd":432.5,"responseStart":432.0999999642372,"secureConnectionStart":323.5999999642372},{"duration":109.10000002384186,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":323.89999997615814,"connectEnd":323.89999997615814,"connectStart":323.89999997615814,"domainLookupEnd":323.89999997615814,"domainLookupStart":323.89999997615814,"fetchStart":323.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":366.5,"responseEnd":433,"responseStart":432.5999999642372,"secureConnectionStart":323.89999997615814},{"duration":109.59999996423721,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":324,"connectEnd":324,"connectStart":324,"domainLookupEnd":324,"domainLookupStart":324,"fetchStart":324,"redirectEnd":0,"redirectStart":0,"requestStart":367.19999998807907,"responseEnd":433.5999999642372,"responseStart":433.19999998807907,"secureConnectionStart":324},{"duration":42.69999998807907,"initiatorType":"link","name":"https://jira.workterra.net/s/05c862146699bb029ceb0a489075e63b-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/bcd66e9a133a1b9f5fd14b56841e1c5b/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":324.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":324.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":366.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":110.09999996423721,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/d86515d5f85e345261e03597bd3941f3/shortcuts.js?context=issuenavigation&context=issueaction","startTime":324.19999998807907,"connectEnd":324.19999998807907,"connectStart":324.19999998807907,"domainLookupEnd":324.19999998807907,"domainLookupStart":324.19999998807907,"fetchStart":324.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":369.7999999523163,"responseEnd":434.2999999523163,"responseStart":433.69999998807907,"secureConnectionStart":324.19999998807907},{"duration":43.69999998807907,"initiatorType":"link","name":"https://jira.workterra.net/s/9095228fa10daa2d3e3d7d5760c95e91-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":324.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":324.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":368.0999999642372,"responseStart":0,"secureConnectionStart":0},{"duration":113.19999998807907,"initiatorType":"script","name":"https://jira.workterra.net/s/c19a1b46e985d7fb85efaf27c8febfdd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":324.5,"connectEnd":324.5,"connectStart":324.5,"domainLookupEnd":324.5,"domainLookupStart":324.5,"fetchStart":324.5,"redirectEnd":0,"redirectStart":0,"requestStart":370.5999999642372,"responseEnd":437.69999998807907,"responseStart":434.2999999523163,"secureConnectionStart":324.5},{"duration":192.20000004768372,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":348.2999999523163,"connectEnd":348.2999999523163,"connectStart":348.2999999523163,"domainLookupEnd":348.2999999523163,"domainLookupStart":348.2999999523163,"fetchStart":348.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":438.0999999642372,"responseEnd":540.5,"responseStart":540.0999999642372,"secureConnectionStart":348.2999999523163},{"duration":192.69999998807907,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":348.39999997615814,"connectEnd":348.39999997615814,"connectStart":348.39999997615814,"domainLookupEnd":348.39999997615814,"domainLookupStart":348.39999997615814,"fetchStart":348.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":438.19999998807907,"responseEnd":541.0999999642372,"responseStart":540.5999999642372,"secureConnectionStart":348.39999997615814},{"duration":66.29999995231628,"initiatorType":"xmlhttprequest","name":"https://jira.workterra.net/rest/webResources/1.0/resources","startTime":692.5,"connectEnd":692.5,"connectStart":692.5,"domainLookupEnd":692.5,"domainLookupStart":692.5,"fetchStart":692.5,"redirectEnd":0,"redirectStart":0,"requestStart":717.7999999523163,"responseEnd":758.7999999523163,"responseStart":758,"secureConnectionStart":692.5}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":73,"connectEnd":205,"secureConnectionStart":173,"requestStart":206,"responseStart":292,"responseEnd":347,"domLoading":295,"domInteractive":957,"domContentLoadedEventStart":957,"domContentLoadedEventEnd":1001,"domComplete":1220,"loadEventStart":1220,"loadEventEnd":1223,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"bb636bce7fde1f","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":62,"dbReadsTimeInMs":4,"dbConnsTimeInMs":11,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
