# Tuning/optimization of "SHOW FULL TABLES" and "SHOW FULL COLUMNS"

**URL:** <https://forums.percona.com/t/tuning-optimization-of-show-full-tables-and-show-full-columns/5150>\
**Category:** General Questions\
**Created:** [October 14, 2016, 8:55am UTC](https://forums.percona.com/t/tuning-optimization-of-show-full-tables-and-show-full-columns/5150 "2016-10-14T08:55:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![holala](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@holala](https://forums.percona.com/u/holala)\
**Post date:** [October 14, 2016, 8:55am UTC](https://forums.percona.com/t/tuning-optimization-of-show-full-tables-and-show-full-columns/5150/1 "2016-10-14T08:55:27Z")

</div>

Hello, we’re experiencing issues with excessive SHOW FULL TABLES and SHOW FULL COLUMNS statements after upgrading to latest version of Hibernate.

Is there any way to tune or optimise MySQL/Percona to improve performance of these? It’s affecting startup time quite a lot.