[TABLE]
[TR]
[TD=“class: votecell”] [CENTER][COLOR=#707070 !important]0down votefavorite
[/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]