CREATE TABLE Statement the same table raises the error  ERROR 1469 (HY000): The mix of handlers in the partitions is not permitted in this version of MySQL . • COMMENT An optional  COMMENT  clause may be used to specify a string that describes the partition. Example: COMMENT = ’Data for the years previous to 1999’ The maximum length for a partition comment is 1024 characters. DATA DIRECTORY  and  INDEX DIRECTORY  may be used to indicate the directory where, respectively, the data and indexes for this partition are to be stored. Both the  data_dir  and the  index_dir  must be absolute system path names. As of MySQL 8.0.21, the directory specified in a  DATA DIRECTORY  clause must be known to  InnoDB . For more information, see Using the DATA DIRECTORY Clause. You must have the  FILE  privilege to use the  DATA DIRECTORY  or  INDEX DIRECTORY  partition option. Example: • DATA DIRECTORY  and  INDEX DIRECTORY CREATE TABLE th (id INT, name VARCHAR(30), adate DATE) PARTITION BY LIST(YEAR(adate)) ( PARTITION p1999 VALUES IN (1995, 1999, 2003) DATA DIRECTORY = ’/var/appdata/95/data’ INDEX DIRECTORY = ’/var/appdata/95/idx’, PARTITION p2000 VALUES IN (1996, 2000, 2004) DATA DIRECTORY = ’/var/appdata/96/data’ INDEX DIRECTORY = ’/var/appdata/96/idx’, PARTITION p2001 VALUES IN (1997, 2001, 2005) DATA DIRECTORY = ’/var/appdata/97/data’ INDEX DIRECTORY = ’/var/appdata/97/idx’, PARTITION p2002 VALUES IN (1998, 2002, 2006) DATA DIRECTORY = ’/var/appdata/98/data’ INDEX DIRECTORY = ’/var/appdata/98/idx’ ); DATA DIRECTORY  and  INDEX DIRECTORY  behave in the same way as in the  CREATE TABLE statement’s  table_option  clause as used for  MyISAM  tables. One data directory and one index directory may be specified per partition. If left unspecified, the data and indexes are stored by default in the table’s database directory. The  DATA DIRECTORY  and  INDEX DIRECTORY  options are ignored for creating partitioned tables if NO_DIR_IN_CREATE  is in effect. May be used to specify, respectively, the maximum and minimum number of rows to be stored in the partition. The values for  max_number_of_rows  and  min_number_of_rows  must be positive • MAX_ROWS  and  MIN_ROWS 2567