Logical backup duration
ActivePublic
Actions

Authored by jcrespo on May 8 2019, 8:24 AM.

Tags

None

Referenced Files

	F28965224: raw.txt
	May 8 2019, 8:24 AM

Subscribers

None

	root@db1115.eqiad.wmnet[zarcillo]> select name, IF(LOCATE('eqiad', source), 'eqiad', 'codfw') as dc, section, timediff(end_date, start_date) as duration FROM backups WHERE start_date > now() - INTERVAL 1 day and `type` = 'dump' ORDER BY dc, section;
	+-----------------------------------+-------+---------+----------+
	\| name \| dc \| section \| duration \|
	+-----------------------------------+-------+---------+----------+
	\| dump.m1.2019-05-07--20-00-29 \| codfw \| m1 \| 00:31:08 \|
	\| dump.m2.2019-05-07--17-16-42 \| codfw \| m2 \| 04:43:55 \|
	\| dump.m3.2019-05-07--20-31-37 \| codfw \| m3 \| 00:35:59 \|
	\| dump.m5.2019-05-07--17-00-01 \| codfw \| m5 \| 00:16:41 \|
	\| dump.s1.2019-05-07--17-00-02 \| codfw \| s1 \| 01:28:03 \|
	\| dump.s2.2019-05-07--17-00-02 \| codfw \| s2 \| 01:22:15 \|
	\| dump.s3.2019-05-07--18-28-05 \| codfw \| s3 \| 03:07:39 \|
	\| dump.s4.2019-05-07--21-36-33 \| codfw \| s4 \| 02:35:56 \|
	\| dump.s5.2019-05-07--18-55-50 \| codfw \| s5 \| 01:48:23 \|
	\| dump.s6.2019-05-07--20-44-13 \| codfw \| s6 \| 00:52:20 \|
	\| dump.s7.2019-05-07--18-22-18 \| codfw \| s7 \| 01:38:10 \|
	\| dump.s8.2019-05-07--17-00-01 \| codfw \| s8 \| 01:55:48 \|
	\| dump.x1.2019-05-07--22-00-37 \| codfw \| x1 \| 00:36:58 \|
	\| dump.m1.2019-05-07--18-17-23 \| eqiad \| m1 \| 00:40:56 \|
	\| dump.m2.2019-05-07--18-02-38 \| eqiad \| m2 \| 04:14:03 \|
	\| dump.m3.2019-05-07--18-14-03 \| eqiad \| m3 \| 00:41:47 \|
	\| dump.m5.2019-05-07--17-00-01 \| eqiad \| m5 \| 00:13:58 \|
	\| dump.s1.2019-05-07--18-58-19 \| eqiad \| s1 \| 02:06:50 \|
	\| dump.s2.2019-05-07--17-00-02 \| eqiad \| s2 \| 01:14:01 \|
	\| dump.s3.2019-05-07--18-55-51 \| eqiad \| s3 \| 01:48:08 \|
	\| dump.s4.2019-05-07--17-00-01 \| eqiad \| s4 \| 02:30:33 \|
	\| dump.s5.2019-05-07--21-50-46 \| eqiad \| s5 \| 01:46:39 \|
	\| dump.s6.2019-05-07--17-14-00 \| eqiad \| s6 \| 00:48:38 \|
	\| dump.s7.2019-05-07--17-00-02 \| eqiad \| s7 \| 01:16:42 \|
	\| dump.s8.2019-05-07--19-30-35 \| eqiad \| s8 \| 01:52:22 \|
	\| dump.tendril.2019-05-07--18-16-44 \| eqiad \| tendril \| 00:00:39 \|
	\| dump.x1.2019-05-07--21-22-57 \| eqiad \| x1 \| 00:27:49 \|
	+-----------------------------------+-------+---------+----------+
	27 rows in set (0.00 sec)

Event Timeline

jcrespo created this paste.May 8 2019, 8:24 AM

Snapshot duration:

root@db1115.eqiad.wmnet[zarcillo]> select IF(LOCATE('eqiad', source), 'eqiad', 'codfw') as dc, section, timediff(end_date, STR_TO_date(SUBSTRING_INDEX(name, '.', -1), '%Y-%m-%d--%H-%i-%S')) as `duration (incl. transfer and compression)` FROM backups WHERE start_date > now() - INTERVAL 1 day and `type` = 'snapshot' ORDER BY dc, section;
+-------+---------+-------------------------------------------+
| dc    | section | duration (incl. transfer and compression) |
+-------+---------+-------------------------------------------+
| codfw | m5      | 01:44:53                                  |
| codfw | s6      | 02:28:31                                  |
| eqiad | m5      | 01:09:49                                  |
| eqiad | s6      | 02:04:04                                  |
| eqiad | x1      | 00:39:05                                  |
+-------+---------+-------------------------------------------+
5 rows in set (0.01 sec)

	root@db1115.eqiad.wmnet[zarcillo]> select name, IF(LOCATE('eqiad', source), 'eqiad', 'codfw') as dc, section, timediff(end_date, start_date) as duration FROM backups WHERE start_date > now() - INTERVAL 1 day and `type` = 'dump' ORDER BY dc, section;
	+-----------------------------------+-------+---------+----------+
	\| name \| dc \| section \| duration \|
	+-----------------------------------+-------+---------+----------+
	\| dump.m1.2019-05-07--20-00-29 \| codfw \| m1 \| 00:31:08 \|
	\| dump.m2.2019-05-07--17-16-42 \| codfw \| m2 \| 04:43:55 \|
	\| dump.m3.2019-05-07--20-31-37 \| codfw \| m3 \| 00:35:59 \|
	\| dump.m5.2019-05-07--17-00-01 \| codfw \| m5 \| 00:16:41 \|
	\| dump.s1.2019-05-07--17-00-02 \| codfw \| s1 \| 01:28:03 \|
	\| dump.s2.2019-05-07--17-00-02 \| codfw \| s2 \| 01:22:15 \|
	\| dump.s3.2019-05-07--18-28-05 \| codfw \| s3 \| 03:07:39 \|
	\| dump.s4.2019-05-07--21-36-33 \| codfw \| s4 \| 02:35:56 \|
	\| dump.s5.2019-05-07--18-55-50 \| codfw \| s5 \| 01:48:23 \|
	\| dump.s6.2019-05-07--20-44-13 \| codfw \| s6 \| 00:52:20 \|
	\| dump.s7.2019-05-07--18-22-18 \| codfw \| s7 \| 01:38:10 \|
	\| dump.s8.2019-05-07--17-00-01 \| codfw \| s8 \| 01:55:48 \|
	\| dump.x1.2019-05-07--22-00-37 \| codfw \| x1 \| 00:36:58 \|
	\| dump.m1.2019-05-07--18-17-23 \| eqiad \| m1 \| 00:40:56 \|
	\| dump.m2.2019-05-07--18-02-38 \| eqiad \| m2 \| 04:14:03 \|
	\| dump.m3.2019-05-07--18-14-03 \| eqiad \| m3 \| 00:41:47 \|
	\| dump.m5.2019-05-07--17-00-01 \| eqiad \| m5 \| 00:13:58 \|
	\| dump.s1.2019-05-07--18-58-19 \| eqiad \| s1 \| 02:06:50 \|
	\| dump.s2.2019-05-07--17-00-02 \| eqiad \| s2 \| 01:14:01 \|
	\| dump.s3.2019-05-07--18-55-51 \| eqiad \| s3 \| 01:48:08 \|
	\| dump.s4.2019-05-07--17-00-01 \| eqiad \| s4 \| 02:30:33 \|
	\| dump.s5.2019-05-07--21-50-46 \| eqiad \| s5 \| 01:46:39 \|
	\| dump.s6.2019-05-07--17-14-00 \| eqiad \| s6 \| 00:48:38 \|
	\| dump.s7.2019-05-07--17-00-02 \| eqiad \| s7 \| 01:16:42 \|
	\| dump.s8.2019-05-07--19-30-35 \| eqiad \| s8 \| 01:52:22 \|
	\| dump.tendril.2019-05-07--18-16-44 \| eqiad \| tendril \| 00:00:39 \|
	\| dump.x1.2019-05-07--21-22-57 \| eqiad \| x1 \| 00:27:49 \|
	+-----------------------------------+-------+---------+----------+
	27 rows in set (0.00 sec)

Logical backup durationActivePublicActions

Event Timeline

Logical backup duration
ActivePublic
Actions