[MDEV-11380] AliSQL: [Perf] Issue#24 SPLIT LOG BUFFER TO ROTATE LOG WRITE Created: 2016-11-29  Updated: 2017-11-17  Resolved: 2017-11-17

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Sergey Vojtovich Assignee: Marko Mäkelä
Resolution: Incomplete Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-14425 Change the InnoDB redo log format to ... Closed
Epic Link: AliSQL patches

 Description   

Description:
------------
It included two kinds of optimization for log write:
 
1. Split the log buffer into the two buffer that has the same size with innodb_log_buffer_size.
   So that when log_write_up_to_lsn occured, the mtr commit can write private log into
   another global log buffer.
2. Split log_sys->mutex into two mutex.
   log_sys->mutex protect the log buffer.
   log_sys->w_mutex protect log file.
 
Those optimization can reduce the log write conflict and improve throughout.

https://github.com/alibaba/AliSQL/commit/959e2d3ebe43012c3c05374aa5cd79b7f9cac2ef



 Comments   
Comment by Marko Mäkelä [ 2017-11-17 ]

I think that we should aim a bit higher and do MDEV-14425.

Generated at Thu Feb 08 07:49:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.