This repository has been archived by the owner on Jul 26, 2022. It is now read-only.
get correct row counts into SHOW TABLE STATUS #11
Assignees
Comments
maykov
added a commit
that referenced
this issue
Feb 13, 2015
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. #11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
Closed
spetrunia
added a commit
that referenced
this issue
Aug 27, 2015
- Basic support for Column Families (writes/reads go the right column family). - CFs are specified per-index in the index comment: INDEX (col1,col2) COMMENT 'cf_name'
spetrunia
added a commit
that referenced
this issue
Aug 27, 2015
spetrunia
added a commit
that referenced
this issue
Aug 27, 2015
maykov
added a commit
that referenced
this issue
Aug 27, 2015
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. #11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
maykov
added a commit
to facebook/mysql-5.6
that referenced
this issue
Sep 14, 2015
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
jtolmer
pushed a commit
to facebook/mysql-5.6
that referenced
this issue
Jan 5, 2016
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
george-lorch
pushed a commit
to george-lorch/percona-server
that referenced
this issue
May 7, 2016
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB/mysql-5.6#11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
george-lorch
pushed a commit
to george-lorch/percona-server
that referenced
this issue
May 7, 2016
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB/mysql-5.6#11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
george-lorch
pushed a commit
to george-lorch/percona-server
that referenced
this issue
May 9, 2016
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB/mysql-5.6#11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
george-lorch
pushed a commit
to george-lorch/percona-server
that referenced
this issue
May 9, 2016
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB/mysql-5.6#11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
hermanlee
pushed a commit
to facebook/mysql-5.6
that referenced
this issue
Jan 31, 2017
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
VitaliyLi
pushed a commit
to VitaliyLi/mysql-5.6
that referenced
this issue
Feb 9, 2017
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
gunnarku
pushed a commit
to facebook/mysql-8.0
that referenced
this issue
Jul 21, 2017
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB/mysql-5.6#11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
gunnarku
pushed a commit
to facebook/mysql-8.0
that referenced
this issue
Jul 25, 2017
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB/mysql-5.6#11 Test Plan: see the enclosed test Reviewers: yoshinorim Subscribers: hermanlee4, jonahcohen, spetrunia Differential Revision: https://reviews.facebook.net/D33189
facebook-github-bot
pushed a commit
to facebook/mysql-5.6
that referenced
this issue
Dec 23, 2019
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189 fbshipit-source-id: ab2cc9c
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Aug 12, 2020
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189 fbshipit-source-id: ab2cc9c
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Sep 9, 2020
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189 fbshipit-source-id: ab2cc9c
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Sep 16, 2020
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189 fbshipit-source-id: ab2cc9c
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Oct 5, 2020
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189 fbshipit-source-id: ab2cc9c
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Nov 11, 2020
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189 fbshipit-source-id: ab2cc9c
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Mar 11, 2021
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189 fbshipit-source-id: 10dc8e13a65
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Aug 16, 2021
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189 fbshipit-source-id: 10dc8e13a65
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Aug 30, 2021
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189 fbshipit-source-id: 10dc8e13a65
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Sep 1, 2021
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189 fbshipit-source-id: 10dc8e13a65
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Sep 2, 2021
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189 fbshipit-source-id: 10dc8e13a65
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Jan 17, 2022
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189
ldonoso
pushed a commit
to ldonoso/percona-server
that referenced
this issue
Mar 15, 2022
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB/mysql-5.6#11 Differential Revision: https://reviews.facebook.net/D33189
inikep
pushed a commit
to inikep/mysql-5.6
that referenced
this issue
Apr 26, 2022
Summary: This diff introduces the usage of GetAproximateSizes function to measure the aproximate size of the primary index and the aproximate size of secondary indexes per table. MySQLOnRocksDB#11 Differential Revision: https://reviews.facebook.net/D33189
Sign up for free
to subscribe to this conversation on GitHub.
Already have an account?
Sign in.
From @mdcallag:
We can get an estimate for the row count via ('Rows:' below is always 10,000 today) via RocksDB property "rocksdb.estimate-num-keys".
Data_length and index_length are best defined when not using an index-organized table. For an index-organized table like InnoDB, the data_length column includes the size of the PK index (including all columns) and the index_length column has the size of all secondary indexes. We can treat RocksDB in the same way. However, we aren't using file-per-table or file-per-index for RocksDB so we need to determine whether we can get estimates on index sizes.
mysql -e 'show table status\G' iok1
*************************** 1. row ***************************
Name: ai
Engine: ROCKSDB
Version: 10
Row_format: Dynamic
Rows: 1000
Avg_row_length: 0
Data_length: 0
Max_data_length: 0
Index_length: 0
Data_free: 0
Auto_increment: NULL
Create_time: NULL
Update_time: NULL
Check_time: NULL
Collation: latin1_swedish_ci
Checksum: NULL
Create_options:
Comment:
The text was updated successfully, but these errors were encountered: