Re: Partition problem (Data striping)
Thanks, this will execute, but the 6 partition files still remain in the main drive, they aren't on any of the specified disks. Am I missing something? partitioning is enabled,
...
ENGINE = MyISAM
PARTITION BY HASH( idx )
(PARTITION p0 DATA DIRECTORY = 'c:\\mysql_p0' INDEX DIRECTORY = 'c:\\mysql_p0',
PARTITION p1 DATA DIRECTORY = 'd:\\mysql_p1' INDEX DIRECTORY = 'd:\\mysql_p1',
PARTITION p2 DATA DIRECTORY = 'e:\\mysql_p2' INDEX DIRECTORY = 'e:\\mysql_p2',
PARTITION p3 DATA DIRECTORY = 'h:\\mysql_p3' INDEX DIRECTORY = 'h:\\mysql_p3',
PARTITION p4 DATA DIRECTORY = 'j:\\mysql_p4' INDEX DIRECTORY = 'e:\\mysql_p4',
PARTITION p5 DATA DIRECTORY = 'k:\\mysql_p5' INDEX DIRECTORY = 'e:\\mysql_p5');
mysql 5.5.22
the resulting table, mysql reports as
...
ENGINE=MyISAM DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH ( idx)
(PARTITION p0 ENGINE = MyISAM,
PARTITION p1 ENGINE = MyISAM,
PARTITION p2 ENGINE = MyISAM,
PARTITION p3 ENGINE = MyISAM,
PARTITION p4 ENGINE = MyISAM,
PARTITION p5 ENGINE = MyISAM) */;
Edited 1 time(s). Last edit at 04/13/2012 03:25PM by Randy Roadax.