Percona Server moved to https://jira.percona.com/projects/PS

Fadvise the slave SQL thread for relay logs

Bug #1073170 reported by Raghavendra D Prabhu
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Triaged
Wishlist
Unassigned
5.1
Won't Fix
Wishlist
Unassigned
5.5
Triaged
Wishlist
Unassigned
5.6
Triaged
Wishlist
Unassigned

Bug Description

While working on a customer issue, I noticed that blockdev --setra being used (for faster replication) and tried to see where such an initiative may be beneficial for read-intensive workload (since O_DIRECT is mostly used in innodb).

Slave SQL thread reading relay log files turned out to be one of them. Using posix_fadvise(WILLNEED) or posix_fadvise(SEQUENTIAL) may be beneficial here for replication, since when SQL thread iteratively reads through relay logs with Log_event::read_log_event, it won't incur as much of cost as without the hint. (and I suppose the files are opened in init_relay_log_pos?)

Tags: performance
Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

Makes sense to check as a Wishlist/feature request.

Laurynas Biveinis (laurynas-biveinis)
tags: added: performance
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2388

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.