# Table partitioning takes too long on 16 cores server

**URL:** <https://forums.percona.com/t/table-partitioning-takes-too-long-on-16-cores-server/4595>\
**Category:** Other MySQL® Questions\
**Created:** [December 13, 2015, 4:16pm UTC](https://forums.percona.com/t/table-partitioning-takes-too-long-on-16-cores-server/4595 "2015-12-13T16:16:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![eranhazout](https://avatars.discourse-cdn.com/v4/letter/e/eb8c5e/32.png) [@eranhazout](https://forums.percona.com/u/eranhazout)\
**Post date:** [December 13, 2015, 4:16pm UTC](https://forums.percona.com/t/table-partitioning-takes-too-long-on-16-cores-server/4595/1 "2015-12-13T16:16:19Z")

</div>

I’m trying to create a new partition (LIST) on an existing table (innodb) with 30copy to tmp table" state.  
I have used the percona mysql performance wizard to improve and I don’t see any differences. The server is with no traffic at all.  
Running on Ubuntu server with 16cores, 30GB memory and SSD 300/3000 IO. it looks like the mysql is not using all resources. the memory usage is on 9GB and only 3 cores are running on very low load.  
Is there a way to improve setting to use more resources and speed up the query?

Thanks