Unusual Memory Usage Metrics for Small MySQL Database
Anonymous
TRIALOP

a year ago

Hi Railway Community!

Appreciate help/insights on this one. I'm seeing some unusual memory usage metrics in my dashboard that seem incorrect:

Current Dashboard Metrics:

- Memory: 74.09 minutely GB

- Volume: 267.20 minutely GB

However, my actual database metrics show:

- Database size: 1.36 MB (verified via MySQL query)

- InnoDB buffer pool size: 128 MB (134,217,728 bytes)

MySQL verification queries used:

1. Database size:

SELECT table_schema AS 'Database',

ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS 'Size (MB)'

FROM information_schema.tables

WHERE table_schema='railway'

GROUP BY table_schema;

2. Buffer pool size:

SHOW VARIABLES LIKE 'innodb_buffer_pool_size';

Could you help explain:

1. Why the dashboard shows such high memory usage (75GB/minute) for a 1.36MB database?

2. How the volume metric is calculated?

3. If this affects actual billing?

Thanks for your help!

Solved

3 Replies

Anonymous
TRIALOP

a year ago

project is truthful-emotion, thank you!


jake
EMPLOYEE

a year ago

MySQL usually uses about 250mb of memory. This seems correct here based on what I've seen in the past.

As for the data in the instance, that's calculated based on the disk sizing. We've validated this on our side and it is accurate (we have tests for it)


Status changed to Awaiting User Response Railway about 1 year ago


Anonymous
TRIALOP

a year ago

Thanks for looking - appreciate


Status changed to Awaiting Railway Response Railway about 1 year ago


Status changed to Solved jake about 1 year ago


Loading...