[MDEV-7948] Protocol::write() takes 0.07% 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: Minor
Reporter: Sergey Vojtovich Assignee: Alexander Barkov
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.07%  mysqld  mysqld
 
   - Protocol::write()
 
      + 38.69% end_send(JOIN*, st_join_table*, bool)
 
      + 31.51% select_send::send_result_set_metadata(List<Item>&, unsigned int)
 
      + 27.18% select_send::send_data(List<Item>&)
 
      + 1.43% end_send_group(JOIN*, st_join_table*, bool)
 
      + 1.18% Protocol::send_result_set_metadata(List<Item>*, unsigned int)

A very good candidate for inlining:

bool Protocol::write()
 
{
 
  DBUG_ENTER("Protocol::write");
 
  DBUG_RETURN(my_net_write(&thd->net, (uchar*) packet->ptr(),
 
                           packet->length()));
 
}


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