Shashank's Blog

Skip to content
  • General
  • Programming Language
    • Python
  • Database
    • SQL
    • MySQL
    • Postgresql
  • Web Framework
    • Django
  • Linux/Unix
    • Linux Commands
Search

mysql partition

Number of rows per partition in a MySQL table

November 4, 2019 / Shashank vivek / Leave a comment

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';

Translate

Recent Posts

  • Dump only Data in PostgreSQL table backup April 6, 2020
  • Number of rows per partition in a MySQL table November 4, 2019
  • What is GIPSA ? November 2, 2019
  • Difference between two dates in mysql July 20, 2018
  • Reading CSV file in python February 24, 2018

RSS Feed

  • RSS - Posts

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy