[MDEV-7956] handler::rebind_psi() takes 0.07% in OLTP RO Created: 2015-04-09  Updated: 2015-06-19  Resolved: 2015-06-19

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.1
Fix Version/s: 10.1.6

Type: Bug Priority: Major
Reporter: Sergey Vojtovich Assignee: Sergey Vojtovich
Resolution: Fixed Votes: 0
Labels: None

Epic Link: Performance: micro optimizations
Sprint: 10.1.6-1

 Description   

Data comes from Sandy Bridge system running sysbench OLTP RO in 1 thread against 1 table.

Call graphs:

-   0.07%  mysqld  mysqld
 
   - handler::rebind_psi()
 
      + 73.91% open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*)
 
      + 26.09% open_table(THD*, TABLE_LIST*, Open_table_context*)

Most time spent for function call convention. It also adds ~0.03% to open_table(). Try to make it inline.

 Comments   
Comment by Sergey Vojtovich [ 2015-05-20 ]

serg, please review fix for this bug.

Comment by Sergey Vojtovich [ 2015-06-17 ]

serg, please review updated fix.

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