Last modified: 2014-01-03 16:06:20 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-159. Summary: Total size of all the files on Wikimedia Commons Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: John Smith <internet@ju.gg> Date: Mon, 26 Sep 2011 21:55:34 ------------------------------------------------------------------------------- The query you could use to get this information: SELECT SUM(img_size) AS total_size FROM `image` on commons.wikimedia.org I'm really curious as to how much space is needed to store 11 million files, it's probably mind boggling but I've always wanted to know an exact number.
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Mon, 26 Sep 2011 22:46:52 ------------------------------------------------------------------------------- Result: total_size 12814901164044 Please notice that only current and not deleted images are included in that count.
------------------------------------------------------------------------------- From: John Smith <internet@ju.gg> Date: Mon, 26 Sep 2011 23:34:56 ------------------------------------------------------------------------------- Thank you! So, 12,814,901,164,044 bytes is 12.81 terabytes, or 12,815 gigabytes. That's pretty big!
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Tue, 27 Sep 2011 22:19:43 ------------------------------------------------------------------------------- Well, you have divided by 1000, haven't you? In fact it's more common to divide by 1024 (see http://en.wikipedia.org/wiki/Binary_prefix#Deviation_between_powers_of_1024_and_powers_of_1000) Bytes KiB MiB GiB TiB 12814901164044 12514551918 12221242,11 11934,80675 11,65508471
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: hoo@online.de CC list: hoo@online.de