search

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.18k stars 323 forks source link

The rows stat on the Html Format of the Info tab is being divided in base 2 instead of base 10. #1708

Open atulwy opened 9 years ago

atulwy commented 9 years ago

Original issue 1708 created by webyog on 2011-09-01T18:12:23.000Z:

What steps will reproduce the problem?

  1. select a database
  2. click the Info tab
  3. compare the Rows stats in the Html & Text/Detailed formats

What is the expected output? What do you see instead? 11078501 in the Text/Detailed format is showing as 10.57M when it should show 11.07M

What version of the product are you using? On what operating system? Using v9.20 Beta1 on Windows XP Service Pack 3

atulwy commented 9 years ago

Comment #1 originally posted by webyog on 2011-09-02T08:02:09.000Z:

this is correct atcually according to modern standards!

Refer: http://en.wikipedia.org/wiki/Mebibyte

1 MiB = 1024 kibibytes = 1048576 bytes but 1 MB = 1000 KB = 1000000 bytes

(but what we are doing her is not unusual. Lots of programs do. It has always been a confusion and inconsistence in the IT world)

atulwy commented 9 years ago

Comment #2 originally posted by webyog on 2011-09-02T13:29:42.000Z:

This isn't for the data size, but the total number of rows in the table.

atulwy commented 9 years ago

Comment #3 originally posted by webyog on 2011-09-21T13:31:14.000Z:

OK .. missed your point here. But actually Data Size should also use base-10 or we should use the term 'MiB' instead of 'MB' if we want to use base-2.

dehrk commented 8 years ago

Additionally, the abbreviated row counts are using the wrong suffixes. 1145045242 rows is getting translated to 1.07G.

peterwy commented 7 years ago

Agreed. There is no "bit" nor "byte" involved here. iIt is a plain number/integer ("1145045242 rows"). This should use base-10 number system. Standards' ambiguity and different historical practices for conversion of bit/byte does not apply to such plain numbers.

A low-priority fix, though.

wyaadarsh commented 7 years ago

We will be fixing it in the next release