# very high CPU usage in mysql server

**URL:** <https://forums.percona.com/t/very-high-cpu-usage-in-mysql-server/6108>\
**Category:** Other MySQL® Questions\
**Created:** [January 8, 2018, 8:33am UTC](https://forums.percona.com/t/very-high-cpu-usage-in-mysql-server/6108 "2018-01-08T08:33:57Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![satheesh](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/satheesh/32/1205_2.png) [@satheesh](https://forums.percona.com/u/satheesh)\
**Post date:** [January 9, 2018, 11:49pm UTC](https://forums.percona.com/t/very-high-cpu-usage-in-mysql-server/6108/3 "2018-01-09T23:49:41Z")

</div>

> [@lorraine.pocklington;50465](#):
>
> For example, did you miss an index in the migration, what are the slow queries, what does an explain on the slow queries tell you about the activity, are there mixed data types on joins etc. Did you change the database configuration as well as make schema changes? .

Thanks Lorraine for your inputs. Given that it was my first post, I had to be brief in my earlier post.

We have been meticulously pouring into the mysql slow query log and compared with our earlier slow queries and there are many queries which are indeed slow in the order of 20-80seconds. But all these slow queries were there even before migration and thankfully we do not see any new hits there. Also indexes look ok and we did add 2 indexes to 2 our huge tables which helped a bit.  
Our ibdata1 file size used to be 5 GB which has since the migration has grown to about 14 GB. Should this be a cause of concern ? Can you please suggest some tools that can be run immediately on the database to check for data integrity and to check if innodb internals look healthy.

Once again thanks for your response and do ask if you need any more metrics.

---

_[View the full topic](https://forums.percona.com/t/very-high-cpu-usage-in-mysql-server/6108)._