enterprise-support team mailing list archive

[Laurynas Biveinis <laurynas.biveinis@xxxxxxxxx>]

Public bug reported:

buf_pool_get_oldest_modification() loops over all buffer pool instances,
acquiring the flush list mutex for each of them.

Before the loop it enters the log flush order mutex:

	/* When we traverse all the flush lists we don't want another
	thread to add a dirty page to any flush list. */
	log_flush_order_mutex_enter();

In the case of srv_buf_pool_instances == 1 this is unnecessary as the
flush list mutex will take care of it

** Affects: mysql-server
     Importance: Unknown
         Status: Unknown

** Affects: percona-server
     Importance: Wishlist
     Assignee: Laurynas Biveinis (laurynas-biveinis)
         Status: In Progress

** Affects: percona-server/5.1
     Importance: Undecided
         Status: Invalid

** Affects: percona-server/5.5
     Importance: Wishlist
         Status: Fix Released

** Affects: percona-server/5.6
     Importance: Wishlist
     Assignee: Laurynas Biveinis (laurynas-biveinis)
         Status: In Progress


** Tags: innodb

** Also affects: percona-server/5.1
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.5
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.6
   Importance: Undecided
       Status: New

** Tags added: innodb

** Bug watch added: MySQL Bug System #69146
   http://bugs.mysql.com/bug.php?id=69146

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=69146
   Importance: Unknown
       Status: Unknown

** Changed in: percona-server/5.1
       Status: New => Invalid

** Changed in: percona-server/5.5
       Status: New => Fix Released

** Changed in: percona-server/5.5
   Importance: Undecided => Wishlist

** Changed in: percona-server/5.6
       Status: New => In Progress

** Changed in: percona-server/5.6
   Importance: Undecided => Wishlist

** Changed in: percona-server/5.6
     Assignee: (unassigned) => Laurynas Biveinis (laurynas-biveinis)

** Changed in: percona-server/5.6
    Milestone: None => 5.6.10-60.3

** Changed in: percona-server/5.5
    Milestone: None => 5.5-20beta

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1176496

Title:
  Optimization in buf_pool_get_oldest_modification if
  srv_buf_pool_instances == 1

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1176496/+subscriptions