[MDEV-23502] Performance testing for packed keys in Unique objects Created: 2020-08-18  Updated: 2021-03-19

Status: Open
Project: MariaDB Server
Component/s: Optimizer
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Varun Gupta (Inactive) Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-21829 Use packed sort keys in Unique objects In Review

 Description   

This tasks relates to analysing performance of the implementation of packed keys in Unique implemented in MDEV-21829.

Performance should be tested with

  • EITS
  • COUNT(DISTINCT col)
  • GROUP_CONCAT(DISTINCT col1,col2....)
  • Index merge (no packing here but we should not get regressions here)

 Comments   
Comment by Varun Gupta (Inactive) [ 2020-08-24 ]

The scripts for benchmarking are here
https://github.com/varunraiko/sort-benchmark

git clone https://github.com/varunraiko/sort-benchmark.git
 
cd sort-benchmark
 
bash 01-setup-trees.sh
 
bash 02-run-sort-int-bench.sh count_distinct
 
bash 06-run-varchar-bench.sh count_distinct

Comment by Varun Gupta (Inactive) [ 2020-08-24 ]

Results for the first run:

https://docs.google.com/spreadsheets/d/1lJt4m-9Gifo8x6ago0VjtxrBN5qepWCfi1xJczwOcQo/edit?usp=sharing

Generated at Thu Feb 08 09:22:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.