Re: equivalent thing of mtr in mysql

2022-07-18 Thread Christophe Pettus
> On Jul 18, 2022, at 20:03, merryok wrote: > > I've read the doc, and it doesn't help too much. > Finally I've found START_CRIT_SECTION and END_CRIT_SECTION. It's like > mtr.start(), mtr.commit() in mysql. May I ask why many places are wrapped > into START_CRIT_SECTION/END_CRIT_SECTION duri

Re: equivalent thing of mtr in mysql

2022-07-18 Thread merryok
I've read the doc, and it doesn't help too much. Finally I've found START_CRIT_SECTION and END_CRIT_SECTION. It's like mtr.start(), mtr.commit() in mysql. May I ask why many places are wrapped into START_CRIT_SECTION/END_CRIT_SECTION during a single dml operation ? And if Assert(CritSectionCount >

Re: equivalent thing of mtr in mysql

2022-07-16 Thread Adrian Klaver
On 7/15/22 18:31, merryok wrote: I'm sorry, first time to post a thread. mtr is short for mini-transaction. About mtr in mysql, we can refer to https://dev.mysql.com/doc/refman/8.0/en/glossary.html  or https://dev.mysql.com/blog-archive/mys

Re:Re: equivalent thing of mtr in mysql

2022-07-15 Thread merryok
them are written. At 2022-07-13 02:57:28, "Peter J. Holzer" wrote: >On 2022-07-12 22:39:31 +0800, merryok wrote: >> Hi, guys. I'm new here. >> >> I'm eager to figure out what is the equivalent thing of mtr in mysql in PG. > >What is MTR?

Re: equivalent thing of mtr in mysql

2022-07-12 Thread Peter J. Holzer
On 2022-07-12 13:07:41 -0600, Rob Sargent wrote: > I thought OP was hinting at WAL stuff defn here So did I. hp -- _ | Peter J. Holzer| Story must make more sense than reality. |_|_) || | | | h...@hjp.at |-- Charles Stross, "Creative writing __/

Re: equivalent thing of mtr in mysql

2022-07-12 Thread Rob Sargent
On 7/12/22 12:57, Peter J. Holzer wrote: On 2022-07-12 22:39:31 +0800, merryok wrote: Hi, guys. I'm new here. I'm eager to figure out what is the equivalent thing of mtr in mysql in PG. What is MTR? A search for "mtr mysql" yields "mysql test run" and "mult

Re: equivalent thing of mtr in mysql

2022-07-12 Thread Peter J. Holzer
On 2022-07-12 22:39:31 +0800, merryok wrote: > Hi, guys. I'm new here. > > I'm eager to figure out what is the equivalent thing of mtr in mysql in PG. What is MTR? A search for "mtr mysql" yields "mysql test run" and "multi-threaded replication",

equivalent thing of mtr in mysql

2022-07-12 Thread merryok
Hi, guys. I'm new here. I'm eager to figure out what is the equivalent thing of mtr in mysql in PG. When a dml operation occurs, it may modify multiple pages and gererate multiple redo log records. mtr can make those logs atomically be transferred to log buffer and written to disk