Database Size Continues to Grow and Performance Continues to Degrade
We have been using YouTrack heavily at our company for sometime now and the database size continues to grow and performance continues to suffer.
I have seen a few startup flags mentioned before to help reduce the size of the database, but it is unclear from the existing threads what the plan of action should be for users in our position.
We are using JetBrains Bug & Issue Tracker YouTrack 5.2 Build 8723 [16-Apr-2014 17:21]. Here are our stats:
I have seen a few startup flags mentioned before to help reduce the size of the database, but it is unclear from the existing threads what the plan of action should be for users in our position.
We are using JetBrains Bug & Issue Tracker YouTrack 5.2 Build 8723 [16-Apr-2014 17:21]. Here are our stats:
| Available processors | 4 |
| Available memory | 2730.6 MB |
| Allocated memory | 2391.9 MB |
| Used memory | 2107.1 MB |
| Uptime | 77 hours, 50 minutes, 28 seconds and 882 milliseconds |
| Online users | Users: 33 (max is 33, 4 minutes ago (08:04)) Sessions: 43 Windows: 73 |
| Database size (without blobs) | 10.1 GB |
| Text index size | 24.0 MB |
| Database background threads | 2 |
| Pending asynchronous jobs | 0 |
| Number of cached results in the database queries cache | 4017 |
| Database queries cache hit rate | 92.66% |
| Blob strings cache hit rate | 76.37% |
| Total transactions | 132477 |
| Transactions per second | 0.47 |
| Requests per second | 2.60 |
Please sign in to leave a comment.
Are there any other things we should be trying?
Here are our updated stats: