Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-11-02 Thread Nikita Malyavin
Sergei, I made it as we agreed, please see the new commit: 9d04b702 -- Yours truly, Nikita Malyavin ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe :

Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-11-01 Thread Sergei Golubchik
Hi, Nikita, On Nov 01, Nikita Malyavin wrote: > On Mon, 31 Oct 2022 at 21:22, Sergei Golubchik wrote: > > > > I hope RPL_TABLE_LIST can be preserved between the events. Is it > > > so? > > > > Yes, it appears to be created in Table_map_log_event and removed on > > commit. That is, it survives

Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-11-01 Thread Nikita Malyavin
On Mon, 31 Oct 2022 at 21:22, Sergei Golubchik wrote: > > I hope RPL_TABLE_LIST can be preserved between the events. Is it so? > > Yes, it appears to be created in Table_map_log_event and removed on > commit. That is, it survives multiple row events. > > Still, there are only two possibilities:

Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-10-31 Thread Sergei Golubchik
Hi, Nikita, On Oct 31, Nikita Malyavin wrote: > On Mon, 31 Oct 2022 at 14:08, Sergei Golubchik wrote: > > On Oct 31, Nikita Malyavin wrote: > > > > > > > Also, I've looked at your latest branch. What were you > > > > optimizing with the commit 3afa3288221 (the one with > > > > usable_keys_data)?

Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-10-31 Thread Nikita Malyavin
On Mon, 31 Oct 2022 at 14:08, Sergei Golubchik wrote: > Hi, Nikita, > > On Oct 31, Nikita Malyavin wrote: > > > > > Also, I've looked at your latest branch. What were you optimizing > > > with the commit 3afa3288221 (the one with usable_keys_data)? > > > > > > It's complex and I don't quite see

Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-10-31 Thread Sergei Golubchik
Hi, Nikita, On Oct 31, Nikita Malyavin wrote: > > > Also, I've looked at your latest branch. What were you optimizing > > with the commit 3afa3288221 (the one with usable_keys_data)? > > > > It's complex and I don't quite see what's the purpose of it. It > > looks like all you need to do is to

Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-10-31 Thread Nikita Malyavin
Hi! On Sun, 30 Oct 2022 at 18:20, Sergei Golubchik wrote: > still, you didn't use `f == f->table->next_number_field` > but we concluded it's safe, didn't we? > > Yes, I just think I only fixed it in the last commit "improve DEFAULT rules" (13222947) > Also, I've looked at your latest branch.

Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-10-30 Thread Sergei Golubchik
Hi, Nikita, On Oct 18, Nikita Malyavin wrote: > On Tue, 18 Oct 2022 at 01:01, Sergei Golubchik wrote: > > > > > > diff --git a/sql/log_event_server.cc b/sql/log_event_server.cc > > > > > index 422d496d5c3..25705d13641 100644 > > > > > --- a/sql/log_event_server.cc > > > > > +++

Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-10-17 Thread Nikita Malyavin
On Tue, 18 Oct 2022 at 01:01, Sergei Golubchik wrote: > > > > diff --git a/sql/log_event_server.cc b/sql/log_event_server.cc > > > > index 422d496d5c3..25705d13641 100644 > > > > --- a/sql/log_event_server.cc > > > > +++ b/sql/log_event_server.cc > > > > @@ -6062,7 +6065,7 @@ int >

Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-10-17 Thread Sergei Golubchik
Hi, Nikita, On Oct 17, Nikita Malyavin wrote: > Hello Sergei! > > On Tue, 4 Oct 2022 at 21:02, Sergei Golubchik wrote: > > > Hi, Nikita, > > > > This review applies to the combined diff e2f8dff^..52f489e > > > > On Oct 04, Nikita Malyavin wrote: > > > > > diff --git a/sql/log_event.h

Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-10-17 Thread Nikita Malyavin
Hello Sergei! On Tue, 4 Oct 2022 at 21:02, Sergei Golubchik wrote: > Hi, Nikita, > > This review applies to the combined diff e2f8dff^..52f489e > > On Oct 04, Nikita Malyavin wrote: > > > diff --git a/sql/log_event.h b/sql/log_event.h > > index 91a910f..8452e665c98 100644 > > ---

Re: [Maria-developers] 52f489ebccb: MDEV-29069 follow-up: support partially suitable keys

2022-10-04 Thread Sergei Golubchik
Hi, Nikita, This review applies to the combined diff e2f8dff^..52f489e On Oct 04, Nikita Malyavin wrote: > diff --git a/sql/log_event.h b/sql/log_event.h > index 91a910f..8452e665c98 100644 > --- a/sql/log_event.h > +++ b/sql/log_event.h > @@ -5275,8 +5278,11 @@ class Rows_log_event :