MariaDB 10.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


10.4.26-MariaDB-1:10.4.26+maria~deb10-log


create table tbl (id bigint unsigned auto_increment not null, user_id bigint unsigned not null, comment varchar(30) not null, primary key (user_id, id), key(id))
PARTITION BY RANGE (user_id)
(
	PARTITION p0 VALUES LESS THAN (500),
	PARTITION p1 VALUES LESS THAN (1000),
	PARTITION p2 VALUES LESS THAN (2000),
	PARTITION p3 VALUES LESS THAN (3000)
);
show create table tbl


Table
Create Table


tbl
CREATE TABLE `tbl` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `comment` varchar(30) NOT NULL,
  PRIMARY KEY (`user_id`,`id`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
 PARTITION BY RANGE (`user_id`)
(PARTITION `p0` VALUES LESS THAN (500) ENGINE = InnoDB,
 PARTITION `p1` VALUES LESS THAN (1000) ENGINE = InnoDB,
 PARTITION `p2` VALUES LESS THAN (2000) ENGINE = InnoDB,
 PARTITION `p3` VALUES LESS THAN (3000) ENGINE = InnoDB)