DBQ-159 Total size of all the files on Wikimedia Commons
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 4:06 PM

Description

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.

Version: unspecified
Severity: minor

Details

Reference: bz59424

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:30 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59424.

JiraBugConverter created this task.Jan 3 2014, 4:06 PM

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

DBQ-159 Total size of all the files on Wikimedia CommonsClosed, ResolvedPublicActions