Number of rows per partition in a MySQL table

November 4, 2019 / Shashank vivek

You can use the below query to get number of rows per partition in a MySQL table.

SELECT PARTITION_NAME, TABLE_ROWS
FROM INFORMATION_SCHEMA.PARTITIONS
WHERE TABLE_NAME = 'your table name';

Share this:
Share
Facebook
Twitter
LinkedIn
Like this:
Like Loading...

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

%d bloggers like this: