[MDEV-7957] QUICK_RANGE_SELECT::get_next() takes 0.17% in OLTP RO Created: 2015-04-09  Updated: 2016-02-16

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.1
Fix Version/s: 10.2

Type: Bug Priority: Major
Reporter: Sergey Vojtovich Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None

Epic Link: Performance: micro optimizations

 Description   

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

Call graphs:

-   0.17%  mysqld  mysqld
 
   - QUICK_RANGE_SELECT::get_next()
 
      + 36.73% rr_quick(READ_RECORD*)
 
      + 29.42% sub_select(JOIN*, st_join_table*, bool)
 
      + 22.79% create_sort_index(THD*, JOIN*, st_order*, unsigned long long, unsigned long long, bool)
 
      + 11.06% filesort(THD*, TABLE*, st_sort_field*, unsigned int, SQL_SELECT*, unsigned long long, bool, unsigned long long*, unsigned long long*)

Most time spent for function call convention. A good candidate for inlining?
Generated at Thu Feb 08 07:23:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.