Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Read optmized db instance class for Maridb

0

I have changed db class for one of db instance to read optimized 'db.r6gd.large' but still see there is no use of local storage for temp table since there is local storage xxG NVMe SSD inbuilt.

Please suggest if any parameters settings to be updated.

JAY

Topics
Database
Tags
MariaDBDatabase
Language
English
asked a year ago157 views
1 Answer
0

To optimize your MariaDB instance with db.r6gd.large for read performance and ensure it's utilizing local NVMe SSD effectively:

  1. Configure tmpdir to use local SSD storage.
  2. Size the InnoDB buffer pool appropriately.
  3. Adjust query cache and temporary table parameters.
  4. Monitor instance performance through AWS CloudWatch and MariaDB's Performance Schema.
AWS
EXPERT
answered a year ago
  • Jaydev P
    a year ago

    Thanks for suggestions. tmpdir is already set to tmpdir /rdslocalstorage/tmp and parameters are set appropriate.

    I believe the tmp table created prior move the workload still uses same location : /rdsdbdata/tmp. Could you suggest any chance to clear those existing tables.

    JAY

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content