# How can I used pt-summary on AWS RDS

**URL:** <https://forums.percona.com/t/how-can-i-used-pt-summary-on-aws-rds/23856>\
**Category:** General Questions\
**Tags:** percona\
**Created:** [July 24, 2023, 1:19pm UTC](https://forums.percona.com/t/how-can-i-used-pt-summary-on-aws-rds/23856 "2023-07-24T13:19:23Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gabe](https://avatars.discourse-cdn.com/v4/letter/g/5daacb/32.png) [@Gabe](https://forums.percona.com/u/Gabe)\
**Post date:** [July 24, 2023, 1:19pm UTC](https://forums.percona.com/t/how-can-i-used-pt-summary-on-aws-rds/23856/1 "2023-07-24T13:19:23Z")

</div>

Hi,  
I want to run your pt-summary on a MySQL database on AWS RDS. Is this possible? If so, could you explain what I need to do in order to be successful?

Thanks!

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [July 24, 2023, 1:22pm UTC](https://forums.percona.com/t/how-can-i-used-pt-summary-on-aws-rds/23856/2 "2023-07-24T13:22:49Z")

</div>

Hello Gabe,

AWS RDS will not give you access to underlying OS and hence it is not possible to grab the system stats by running pt-summary. You will have to depend on system metric exposed by enhanced monitoring and cloud metrics charts. It goes without saying, ofcourse you won’t be able to tweak them.

Thanks,  
K.

---

<div class="post-metadata">

**Author:** ![Gabe](https://avatars.discourse-cdn.com/v4/letter/g/5daacb/32.png) [@Gabe](https://forums.percona.com/u/Gabe)\
**Post date:** [July 24, 2023, 1:40pm UTC](https://forums.percona.com/t/how-can-i-used-pt-summary-on-aws-rds/23856/3 "2023-07-24T13:40:23Z")

</div>

Unfortunately, that’s what I expected.

Are any of these tools possible?

- pt-mysql-summary
- pt-duplicate-key-checker
- pt-query-digest
- pt-variable-advisor

Thanks

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [July 24, 2023, 1:51pm UTC](https://forums.percona.com/t/how-can-i-used-pt-summary-on-aws-rds/23856/4 "2023-07-24T13:51:38Z")

</div>

hmmm can’t help it Gabe! About other tools I’d suggest you to go through the documentation and explore the options. I have used first 3 tools for RDS and they work flawlessly but the 4th tool I have never used against RDS. Though pt-variable-advisor should still work as the option also allow `--source-of-variables` option.

Thanks,  
K

---

<div class="post-metadata">

**Author:** ![Gabe](https://avatars.discourse-cdn.com/v4/letter/g/5daacb/32.png) [@Gabe](https://forums.percona.com/u/Gabe)\
**Post date:** [July 24, 2023, 1:52pm UTC](https://forums.percona.com/t/how-can-i-used-pt-summary-on-aws-rds/23856/5 "2023-07-24T13:52:45Z")

</div>

Appreciate it - thanks!

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [July 24, 2023, 6:54pm UTC](https://forums.percona.com/t/how-can-i-used-pt-summary-on-aws-rds/23856/6 "2023-07-24T18:54:55Z")

</div>

Hello @Gabe,  
pt-mysql-summary, pt-duplicate-key-checker, and pt-variable-advisor will all work against RDS as they just connect and run some typical SQL. pt-query-digest on the other hand, typically reads a MySQL server slow-query-log and digests the information. You can download the slow log from the RDS console to your local machine and then run pt-q-d. I would recommend instead that you setup and use PMM, as you will get the same benefits of pt-q-d plus a lot more including historical stats.
