# MySQL Create Table with Partition Very Slow on server machine

**URL:** <https://forums.percona.com/t/mysql-create-table-with-partition-very-slow-on-server-machine/4056>\
**Category:** Percona Server for MySQL 5.6\
**Created:** [February 16, 2015, 3:15am UTC](https://forums.percona.com/t/mysql-create-table-with-partition-very-slow-on-server-machine/4056 "2015-02-16T03:15:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![anisar](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@anisar](https://forums.percona.com/u/anisar)\
**Post date:** [February 16, 2015, 3:15am UTC](https://forums.percona.com/t/mysql-create-table-with-partition-very-slow-on-server-machine/4056/1 "2015-02-16T03:15:16Z")

</div>

[TABLE]  
[TR]  
[TD=“class: votecell”] [CENTER][COLOR=#707070 !important]0down vote[favorite](http://dba.stackexchange.com/questions/91948/mysql-create-table-with-partition-very-slow-on-server-machine#)  
[/CENTER]  
[/TD]  
[TD=“class: postcell”] MySQL version 5.6 InnoDB engine

```
		Following create table statement with Partition
		runs in 10 Second on My Development Machine windows 7, i5 , 8GBRam, single disk
		runs in 16 Second on Virtual Machine windows server 2012 , xeon 2GHz , 615MB Ram, single disk
		While takes 100 Seconds on my server machine Windows server 2008 R2 Standard, xeon 2.4 2 Processors, 32 GB Ram, ATA SCSI Mirror drives
		I am not able to understand why there is so much performance difference ..
		Related question on MySql forum [URL]http://forums.mysql.com/read.php?24,392502,392502[/URL]

```

[COLOR=#8A4A0B]CREATE [COLOR=#8A4A0B]TABLE [COLOR=#8A4A0B]IF [COLOR=#8A4A0B]NOT [COLOR=#8A4A0B]EXISTS `TestSpeed`.`CTM` ( `ServerID` BIGINT [COLOR=#8A4A0B]NOT [COLOR=#8A4A0B]NULL, `ClientID` BIGINT [COLOR=#8A4A0B]NOT [COLOR=#8A4A0B]NULL, `CommunityID` INT [COLOR=#8A4A0B]NOT [COLOR=#8A4A0B]NULL, [COLOR=#8A4A0B]PRIMARY [COLOR=#8A4A0B]KEY (`ClientID`,`CommunityID`), [COLOR=#8A4A0B]UNIQUE [COLOR=#8A4A0B]INDEX `IX_CTM` (`ServerID` [COLOR=#8A4A0B]ASC,`CommunityID`), [COLOR=#8A4A0B]INDEX `IX_CTM_ClientID` (`ClientID` [COLOR=#8A4A0B]ASC)) [COLOR=#8A4A0B]PARTITION [COLOR=#8A4A0B]BY HASH (CommunityID) PARTITIONS 300;

```
		[/TD]
	[/TR]
 [/TABLE]

```