https://bugzilla.wikimedia.org/show_bug.cgi?id=69088
Bug ID: 69088
Summary: Queries of commonswiki_p.filearchive for fa_sha1 are
slow
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Infrastructure
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected],
[email protected], [email protected],
[email protected], [email protected],
[email protected], [email protected],
[email protected], [email protected],
[email protected]
Blocks: 48930
Web browser: ---
Mobile Platform: ---
Cloned from bug #57697, comment #10:
| MariaDB [commonswiki_p]> SELECT * FROM image WHERE img_sha1 =
'qtexhtbcwt0tnkuxb2wf3xs7d7j761u' LIMIT 0, 1000;
|
+-----------------------------+----------+-----------+------------+------------------------------------------+----------+----------------+----------------+----------------+------------------------------------------------------+----------+---------------+----------------+---------------------------------+
| | img_name | img_size | img_width | img_height |
img_metadata | img_bits | img_media_type |
img_major_mime | img_minor_mime | img_description
| img_user | img_user_text | img_timestamp | img_sha1
|
|
+-----------------------------+----------+-----------+------------+------------------------------------------+----------+----------------+----------------+----------------+------------------------------------------------------+----------+---------------+----------------+---------------------------------+
| | !!!!古市公威像0103.JPG | 492465 | 1536 | 1024 |
a:1:{s:22:"MEDIAWIKI_EXIF_VERSION";i:2;} | 8 | BITMAP | image
| jpeg | Ich machte dieses Foto von mir in 2006.{{GFDL-self}} |
81053 | Tokyo Watcher | 20070305091405 | qtexhtbcwt0tnkuxb2wf3xs7d7j761u |
|
+-----------------------------+----------+-----------+------------+------------------------------------------+----------+----------------+----------------+----------------+------------------------------------------------------+----------+---------------+----------------+---------------------------------+
| 1 row in set (0.00 sec)
| MariaDB [commonswiki_p]> SELECT * FROM oldimage WHERE oi_sha1 =
'0mpoldytyxspxrdbf44r1kc7m8vtbq67' LIMIT 0, 1000;
| Empty set (0.00 sec)
| MariaDB [commonswiki_p]> SELECT * FROM filearchive WHERE fa_sha1 =
'0mpoldytyxspxrdbf44r1kc7m8vtbq67' LIMIT 0, 1000;
|
+-------+-----------------------+-----------------+------------------+----------------+-----------------+----------------------+-------------------+---------+----------+-----------+-------------+---------+---------------+---------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------+----------------+------------+----------------------------------+
| | fa_id | fa_name | fa_archive_name | fa_storage_group |
fa_storage_key | fa_deleted_user | fa_deleted_timestamp | fa_deleted_reason |
fa_size | fa_width | fa_height | fa_metadata | fa_bits | fa_media_type |
fa_major_mime | fa_minor_mime | fa_description
| fa_user | fa_user_text | fa_timestamp |
fa_deleted | fa_sha1 |
|
+-------+-----------------------+-----------------+------------------+----------------+-----------------+----------------------+-------------------+---------+----------+-----------+-------------+---------+---------------+---------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------+----------------+------------+----------------------------------+
| | 8 | Perreo-logo-black.jpg | NULL | deleted |
NULL | 123 | 20060616034833 | logo | 26447
| 400 | 194 | 0 | 8 | BITMAP | image
| jpeg | {{Information
| |Description= Logo for PerreoRadio.com
| |Source= http://www.PerreoRadio.com
| |Date= 6/12/2006
| |Author= PerreoRadio.com
| |Permission=
| |other_versions=
| }} | 47161 | Ameno13 | 20060612221349 | 0 |
0mpoldytyxspxrdbf44r1kc7m8vtbq67 |
|
+-------+-----------------------+-----------------+------------------+----------------+-----------------+----------------------+-------------------+---------+----------+-----------+-------------+---------+---------------+---------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------+----------------+------------+----------------------------------+
| 1 row in set (4.94 sec)
| MariaDB [commonswiki_p]>
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
