Size: separate data_length and index_length
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 65/100
Research direction
Start at the database size reporting path used by the --human-readable output and inspect how data and index sizes are currently combined and rounded. Done means the output separates Data, Index, and Total while preserving the combined total and avoiding the demonstrated rounding discrepancy.
Written by the indexing model from the issue text.
Description
Feature Request
- Yes, I reviewed the contribution guidelines.
Especially on larger sites, and with DB optimization (i.e. additional indexes), indexes can be quite big already on its own. Calculating data and index sizes together skew things slightly.
Here's an example of one site
Data total: ~3.43 GB
Index total: ~2.80 GB
Grand total: ~6.23 GB
Describe the solution you'd like
At least when using an output format that doesn't just give the size as a number, data and index should be displayed separately. At least it should be clearly documented that index sizes are counted to tally.
For example with --human-readable instead of
+------+------+
| Name | Size |
+------+------+
| wdb | 7 GB |
+------+------+
return could be
| Name | Data | Index | Total |
|------|---------|---------|---------|
| wdb | 3.43 GB | 2.80 GB | 6.23 GB |
There's currently also slight rounding issue where 6.23 GB becomes 7 GB.
- Dominant language
- PHP
- Stars
- 76
- Forks
- 73
- Avg merge
- 9h 31m
- Merged PRs (30d)
- 2
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from wp-cli/db-command
-
bug command:db-query
wp-cli/db-command#319 · 5 comments · 1 reaction · 2 assignees ·
-
command:db scope:distribution state:unconfirmed
wp-cli/db-command#306 · 5 comments · 1 reaction · 2 assignees ·
-
bug command:db-export
Difficulty 3/5 1-2 days Newbie friendliness 45/100
wp-cli/db-command#289 · 2 comments ·
-
command:db-export command:db-import scope:distribution state:unconfirmed
Difficulty 5/5 Over a week Newbie friendliness 25/100
wp-cli/db-command#327 · 8 comments · 2 reactions ·
-
command:db command:db-search
Difficulty 3/5 1-2 days Newbie friendliness 35/100
wp-cli/db-command#156 · 1 comment · 20 reactions ·
All issues in wp-cli/db-command
Similar issues
-
priority: p3
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
googleapis/librarian#7636 ·
-
0. Needs triage bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
nextcloud/fulltextsearch#1011 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
phpstan/phpstan-doctrine#794 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
Automattic/static-site-importer#1767 ·