[01:02:41] 2014/02/17 00:56 WARN rosemary MySQL slave SLOW_SLAVE WARNING: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2120 [01:04:41] 2014/02/17 01:02 WARN rosemary s1 replag QUERY WARNING: 'SELECT ts_rc_age()' returned 2146.000000 [03:07:47] 2014/02/17 03:06 OK wolfsbane / DISK OK - free space: / 7605 MB (25% inode=93%): [03:07:47] 2014/02/17 03:06 OK wolfsbane /tmp DISK OK - free space: / 7616 MB (25% inode=93%): [03:14:48] 2014/02/17 03:14 OK rosemary MySQL slave Uptime: 314493 Threads: 42 Questions: 176938243 Slow queries: 98360 Opens: 15239 Flush tables: 1 Open tables: 632 Queries per second avg: 562.614 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1737 [03:14:48] 2014/02/17 03:13 OK rosemary s1 replag QUERY OK: 'SELECT ts_rc_age()' returned 1743.000000 [05:47:57] 2014/02/17 05:47 CRIT z-dat-s5-b APT APT CRITICAL: 6 packages available for upgrade (2 critical updates). [09:22:10] 2014/02/17 09:21 OK cassia /sql/data/dewiki DISK OK - free space: /sql 387069 MB (32% inode=99%): [09:40:11] 2014/02/17 09:39 OK damiana NTP NTP OK: Offset -0.062558 secs [09:56:12] 2014/02/17 09:55 OK nightshade aliasd TCP OK - 0.001 second response time on port 984 [500 Not found.] [10:12:13] 2014/02/17 10:10 CRIT z-dat-s7-a /sql CHECK_NRPE: Socket timeout after 30 seconds. [10:14:13] 2014/02/17 10:13 WARN z-dat-s7-a /sql DISK WARNING - free space: /sql 62619 MB (8% inode=99%): [19:17:59] anyone here with tool server access? [19:29:17] Admin or regular user? [19:30:50] Saqib: What do you need? [19:34:46] 2014/02/17 19:34 WARN cassia MySQL slave SLOW_SLAVE WARNING: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 3107 [19:35:47] 2014/02/17 19:35 OK cassia MySQL slave Uptime: 5435897 Threads: 3 Questions: 6173497067 Slow queries: 427793 Opens: 350369 Flush tables: 2 Open tables: 194 Queries per second avg: 1135.690 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1152 [19:39:17] Dispenser [19:39:27] i just sent an email to mailing list. you saw [19:39:28] ? [19:39:51] Not yet [19:40:40] I'm from Wikivoyage. We don't have DPL extension installed on-wiki. Is it possible if you guys can generate a list of articles fall under particular categories for me please? I'm preparing a report for upcoming Wikimania… [19:41:31] Could you use catscan? [19:42:09] http://tools.wmflabs.org/catscan2/catscan2.php [19:42:37] hmmm [19:42:43] i didn't thought about it [19:42:51] let me try [19:44:50] how to call articles from 2 particular categories [19:45:29] separate category by comma not works [19:45:50] | [19:45:54] pipe [19:46:09] or (IIRC) newline [19:46:17] ok [19:46:20] and one more thing [19:46:42] how can i display articles from sub cats as well of the cats i mention [19:47:14] Depth option? [19:51:44] hmm still loading [19:52:12] dont know why it taking so time [19:52:58] Because it works around MySQL's optimizer and expands all categories then find matches [19:53:31] ok great [19:53:34] many thanks [19:53:38] it worked [19:53:48] 2014/02/17 19:46 WARN wolfsbane / DISK WARNING - free space: / 6274 MB (20% inode=93%): [19:53:48] 2014/02/17 19:46 WARN wolfsbane /tmp DISK WARNING - free space: / 6276 MB (20% inode=93%): [19:53:53] Try http://tools.wmflabs.org/catscan2/quick_intersection.php [19:54:46] good [19:54:48] again thanks [19:54:54] you solved my headache [19:57:28] bye dispensor