Shannon-Data / ShannonBase

A MySQL HTAP Database, Open Source version of MySQL Heatwave, Powered by AI.
https://www.shannonbase.org
Other
14 stars 6 forks source link

Feature: performance evaluation #182

Open ShannonBase opened 3 months ago

ShannonBase commented 3 months ago

Summary

Using perf to evaluate the performance of ShannonBase, mainly focus on memory, such as memory bandwith usage, cache miss, etc.

and to evaluate the impact of options of gcc on performance.

ref: https://en.wikipedia.org/wiki/Cache_prefetching

ShannonBase commented 3 months ago

using perf to test metrics on memory.

1: create database xxx;

2:  create user.
CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpass';
GRANT ALL PRIVILEGES ON testdb.* TO 'testuser'@'localhost';
FLUSH PRIVILEGES;

3:sysbench --mysql-host=127.0.0.1  --mysql-db=testdb --mysql-user=testuser --mysql-password=testpass --table-size=1000000 --tables=10 /usr/share/sysbench/oltp_read_write.lua prepare