Телеграмм чат группы mysql

2020-11-03 19:49:13 0 [Note] InnoDB: To roll back: 1 transactions, 12324601 rows
2020-11-03 19:49:19 0 [Note] InnoDB: Buffer pool(s) load completed at 201103 19:49:19
2020-11-03 19:49:28 0 [Note] InnoDB: To roll back: 1 transactions, 10847780 rows
2020-11-03 19:49:43 0 [Note] InnoDB: To roll back: 1 transactions, 9293520 rows
2020-11-03 19:49:58 0 [Note] InnoDB: To roll back: 1 transactions, 7595028 rows
2020-11-03 19:50:13 0 [Note] InnoDB: To roll back: 1 transactions, 5946164 rows
2020-11-03 19:50:28 0 [Note] InnoDB: To roll back: 1 transactions, 4500679 rows
2020-11-03 19:50:43 0 [Note] InnoDB: To roll back: 1 transactions, 3030412 rows
2020-11-03 19:50:58 0 [Note] InnoDB: To roll back: 1 transactions, 1524630 rows
2020-11-03 19:51:13 0 [Note] InnoDB: To roll back: 1 transactions, 20531 rows
2020-11-03 19:51:13 0 [Note] InnoDB: Rolled back recovered transaction 66522998909
2020-11-03 19:51:13 0 [Note] InnoDB: Rollback of non-prepared transactions completed

источник

20:53пожаловаться #9

Syntax Highlight Bot in MySQL

Vova

почему я такое получаю?

2020-11-03 19:49:13 0 [Note] InnoDB: To roll back: 1 transactions, 12324601 rows
2020-11-03 19:49:19 0 [Note] InnoDB: Buffer pool(s) load completed at 201103 19:49:19
2020-11-03 19:49:28 0 [Note] InnoDB: To roll back: 1 transactions, 10847780 rows
2020-11-03 19:49:43 0 [Note] InnoDB: To roll back: 1 transactions, 9293520 rows
2020-11-03 19:49:58 0 [Note] InnoDB: To roll back: 1 transactions, 7595028 rows
2020-11-03 19:50:13 0 [Note] InnoDB: To roll back: 1 transactions, 5946164 rows
2020-11-03 19:50:28 0 [Note] InnoDB: To roll back: 1 transactions, 4500679 rows
2020-11-03 19:50:43 0 [Note] InnoDB: To roll back: 1 transactions, 3030412 rows
2020-11-03 19:50:58 0 [Note] InnoDB: To roll back: 1 transactions, 1524630 rows
2020-11-03 19:51:13 0 [Note] InnoDB: To roll back: 1 transactions, 20531 rows
2020-11-03 19:51:13 0 [Note] InnoDB: Rolled back recovered transaction 66522998909
2020-11-03 19:51:13 0 [Note] InnoDB: Rollback of non-prepared transactions completed

источник

20:53пожаловаться #10

Ꮓ

ᏃᏞᎪᎽᎬᏒ in MySQL

Vlad Sobenko

Сходи проспись, чушь несёшь.

источник

21:23пожаловаться #11

Denis Efremov in MySQL

Vova

почему я такое получаю?

2020-11-03 19:49:13 0 [Note] InnoDB: To roll back: 1 transactions, 12324601 rows
2020-11-03 19:49:19 0 [Note] InnoDB: Buffer pool(s) load completed at 201103 19:49:19
2020-11-03 19:49:28 0 [Note] InnoDB: To roll back: 1 transactions, 10847780 rows
2020-11-03 19:49:43 0 [Note] InnoDB: To roll back: 1 transactions, 9293520 rows
2020-11-03 19:49:58 0 [Note] InnoDB: To roll back: 1 transactions, 7595028 rows
2020-11-03 19:50:13 0 [Note] InnoDB: To roll back: 1 transactions, 5946164 rows
2020-11-03 19:50:28 0 [Note] InnoDB: To roll back: 1 transactions, 4500679 rows
2020-11-03 19:50:43 0 [Note] InnoDB: To roll back: 1 transactions, 3030412 rows
2020-11-03 19:50:58 0 [Note] InnoDB: To roll back: 1 transactions, 1524630 rows
2020-11-03 19:51:13 0 [Note] InnoDB: To roll back: 1 transactions, 20531 rows
2020-11-03 19:51:13 0 [Note] InnoDB: Rolled back recovered transaction 66522998909
2020-11-03 19:51:13 0 [Note] InnoDB: Rollback of non-prepared transactions completed

Ну почему бы и нет?

источник

23:10пожаловаться #12

Denis Efremov in MySQL

Vova

почему я такое получаю?

2020-11-03 19:49:13 0 [Note] InnoDB: To roll back: 1 transactions, 12324601 rows
2020-11-03 19:49:19 0 [Note] InnoDB: Buffer pool(s) load completed at 201103 19:49:19
2020-11-03 19:49:28 0 [Note] InnoDB: To roll back: 1 transactions, 10847780 rows
2020-11-03 19:49:43 0 [Note] InnoDB: To roll back: 1 transactions, 9293520 rows
2020-11-03 19:49:58 0 [Note] InnoDB: To roll back: 1 transactions, 7595028 rows
2020-11-03 19:50:13 0 [Note] InnoDB: To roll back: 1 transactions, 5946164 rows
2020-11-03 19:50:28 0 [Note] InnoDB: To roll back: 1 transactions, 4500679 rows
2020-11-03 19:50:43 0 [Note] InnoDB: To roll back: 1 transactions, 3030412 rows
2020-11-03 19:50:58 0 [Note] InnoDB: To roll back: 1 transactions, 1524630 rows
2020-11-03 19:51:13 0 [Note] InnoDB: To roll back: 1 transactions, 20531 rows
2020-11-03 19:51:13 0 [Note] InnoDB: Rolled back recovered transaction 66522998909
2020-11-03 19:51:13 0 [Note] InnoDB: Rollback of non-prepared transactions completed

А что конкретно тебя бесит?

источник

23:11пожаловаться #13

Ilia Zviagin in MySQL

Vova

почему я такое получаю?

2020-11-03 19:49:13 0 [Note] InnoDB: To roll back: 1 transactions, 12324601 rows
2020-11-03 19:49:19 0 [Note] InnoDB: Buffer pool(s) load completed at 201103 19:49:19
2020-11-03 19:49:28 0 [Note] InnoDB: To roll back: 1 transactions, 10847780 rows
2020-11-03 19:49:43 0 [Note] InnoDB: To roll back: 1 transactions, 9293520 rows
2020-11-03 19:49:58 0 [Note] InnoDB: To roll back: 1 transactions, 7595028 rows
2020-11-03 19:50:13 0 [Note] InnoDB: To roll back: 1 transactions, 5946164 rows
2020-11-03 19:50:28 0 [Note] InnoDB: To roll back: 1 transactions, 4500679 rows
2020-11-03 19:50:43 0 [Note] InnoDB: To roll back: 1 transactions, 3030412 rows
2020-11-03 19:50:58 0 [Note] InnoDB: To roll back: 1 transactions, 1524630 rows
2020-11-03 19:51:13 0 [Note] InnoDB: To roll back: 1 transactions, 20531 rows
2020-11-03 19:51:13 0 [Note] InnoDB: Rolled back recovered transaction 66522998909
2020-11-03 19:51:13 0 [Note] InnoDB: Rollback of non-prepared transactions completed

Это database recovery

источник

23:34пожаловаться #14

Ilia Zviagin in MySQL

Vova

почему я такое получаю?

2020-11-03 19:49:13 0 [Note] InnoDB: To roll back: 1 transactions, 12324601 rows
2020-11-03 19:49:19 0 [Note] InnoDB: Buffer pool(s) load completed at 201103 19:49:19
2020-11-03 19:49:28 0 [Note] InnoDB: To roll back: 1 transactions, 10847780 rows
2020-11-03 19:49:43 0 [Note] InnoDB: To roll back: 1 transactions, 9293520 rows
2020-11-03 19:49:58 0 [Note] InnoDB: To roll back: 1 transactions, 7595028 rows
2020-11-03 19:50:13 0 [Note] InnoDB: To roll back: 1 transactions, 5946164 rows
2020-11-03 19:50:28 0 [Note] InnoDB: To roll back: 1 transactions, 4500679 rows
2020-11-03 19:50:43 0 [Note] InnoDB: To roll back: 1 transactions, 3030412 rows
2020-11-03 19:50:58 0 [Note] InnoDB: To roll back: 1 transactions, 1524630 rows
2020-11-03 19:51:13 0 [Note] InnoDB: To roll back: 1 transactions, 20531 rows
2020-11-03 19:51:13 0 [Note] InnoDB: Rolled back recovered transaction 66522998909
2020-11-03 19:51:13 0 [Note] InnoDB: Rollback of non-prepared transactions completed

В чем проблема то? Это все нормально

источник

23:38пожаловаться #15

Denis Efremov in MySQL

sticker.webp

(25.35 Кб)

источник

23:58пожаловаться #16

2020 November 04

Vova in MySQL

Ilia Zviagin

В чем проблема то? Это все нормально

В том что это бэкап на который делался prepare. То есть рекавери прошло и база по идее консистентная.

источник

00:15пожаловаться #17

Богдан in MySQL

Господа, а не подскажите есть ли возможность использовать filter в оконных функциях?

источник

02:26пожаловаться #18

Богдан in MySQL

Вот есть такой запрос

SELECT
  c1.category_id,
  JSON_ARRAYAGG(JSON_OBJECT('id', c2.category_id, 'child', c2.child)) AS child
FROM oc_category c1
LEFT JOIN LATERAL (
  SELECT
    c2.category_id,
    JSON_ARRAYAGG(JSON_OBJECT('id', c3.category_id)) AS child
  FROM oc_category c2
  LEFT JOIN LATERAL (
    SELECT c3.category_id FROM oc_category c3
    where c3.parent_id = c2.category_id
    ORDER BY c3.sort_order DESC
  )
  AS c3 ON true
  where c2.parent_id = c1.category_id
  GROUP BY c2.category_id
  ORDER BY c2.sort_order DESC
)
AS c2 ON true
WHERE c1.parent_id = 0
GROUP BY c1.category_id
ORDER BY c1.sort_order

источник

02:27пожаловаться #19

Syntax Highlight Bot in MySQL

Богдан

Вот есть такой запрос

SELECT
  c1.category_id,
  JSON_ARRAYAGG(JSON_OBJECT('id', c2.category_id, 'child', c2.child)) AS child
FROM oc_category c1
LEFT JOIN LATERAL (
  SELECT
    c2.category_id,
    JSON_ARRAYAGG(JSON_OBJECT('id', c3.category_id)) AS child
  FROM oc_category c2
  LEFT JOIN LATERAL (
    SELECT c3.category_id FROM oc_category c3
    where c3.parent_id = c2.category_id
    ORDER BY c3.sort_order DESC
  )
  AS c3 ON true
  where c2.parent_id = c1.category_id
  GROUP BY c2.category_id
  ORDER BY c2.sort_order DESC
)
AS c2 ON true
WHERE c1.parent_id = 0
GROUP BY c1.category_id
ORDER BY c1.sort_order

источник

02:27пожаловаться #20