Not the answer you need?
Register and ask your own question!

MySQL Create Table with Partition Very Slow on server machine

anisaranisar EntrantCurrent User Role Beginner


[COLOR=#707070 !important]0down votefavorite

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 http://forums.mysql.com/read.php?24,392502,392502

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



Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.