[10:17:54] 6Phabricator: Delete user Glavagetto - https://phabricator.wikimedia.org/T106322#1636605 (10Joe) 5Open>3Resolved [11:08:12] 6Project-Creators: Create Phabricator project #MediaWiki-Extensions-ImportArticles - https://phabricator.wikimedia.org/T112252#1636749 (10hashar) [11:48:03] 6Project-Creators: Dumps-generation - https://phabricator.wikimedia.org/T112516#1636875 (10ArielGlenn) 3NEW [15:38:05] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1637628 (10jcrespo) [15:42:33] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1637656 (10jcrespo) I've reopened T110913 to include the profiling I did on phabricator during the weekend. Some scary things there (in terms of performance). [16:10:14] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1637794 (10mmodell) Doesn't look too scary to me, can you elaborate? [17:28:19] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1638205 (10jcrespo) Maybe inserting all the commits on the 16GB blob table is one of the reason of slowdowns (pure speculation). [18:05:22] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1638365 (10mmodell) jcsrespo: I see. I don't have a very good understanding of mysql blob performance. I would have assumed that it handles large blobs fairly wel... [18:06:51] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1638376 (10jcrespo) > I would have assumed that it handles large blobs fairly well. It generally does, I wonder if large data movement can cause stalls, because... [18:10:17] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1638392 (10mmodell) There is quite a lot of activity on repositories but I didn't think the volume had changed very much in the past several weeks. There has bee... [18:14:08] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1638411 (10chasemp) Just for historical perspective, when we first implemented we knew that MySQL was a stopgap store (for how long we didn't know), and decided t... [18:33:11] 6Project-Creators: Create new project for Blog-Content - https://phabricator.wikimedia.org/T112419#1638485 (10Aklapper) @jrbs: Makes a lot of sense. :) If the Communications team agrees (I guess you've talked with them :) and would like to have a Phabricator project for WM blog content, I (or anybody else in #P... [18:47:48] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1638593 (10jcrespo) Well, we have the closest thing to amazon s3, which is Swift... I do not thing MySQL is a great place to store large files. Any relational da... [19:44:57] 6Phabricator, 10Phabricator-Upstream: Add fields to support bug specific information - https://phabricator.wikimedia.org/T92708#1638826 (10Fjalapeno) [19:51:05] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1638840 (10mmodell) So we could potentially have phabricator store it's files in swift? [20:03:04] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1638894 (10chasemp) >>! In T109279#1638840, @mmodell wrote: > So we could potentially have phabricator store it's files in swift? 1. Yes, but not sure how much w... [20:05:51] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1638902 (10mmodell) @chasemp: upstream phabricator is almost certainly storing things in s3. 1. Swift should be similar enough to s3 to make it an easy integrati... [20:07:55] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1638915 (10chasemp) I think there is some difference in API for swift vs s3, as in swift has a subset. paging @fgiunchedi who should know offhand. [20:25:36] 6Phabricator, 3Discovery-Cirrus-Sprint, 7WorkType-Maintenance: Drop the `phabricatormain` index in production - https://phabricator.wikimedia.org/T111471#1639010 (10EBernhardson) 5Open>3Resolved [21:34:15] 6Phabricator, 6operations, 7Database, 5Patch-For-Review: Phabricator creates MySQL connection spikes - https://phabricator.wikimedia.org/T109279#1639306 (10mmodell) we wouldn't be the only ones using swift: https://secure.phabricator.com/T5843 [23:31:52] andre__, is there some policy about the use of MediaWiki- prefixes in project names? [23:35:41] I've been told there is some, but all I could find was https://www.mediawiki.org/wiki/Phabricator/Creating_and_renaming_projects#Name