search

readysettech / readyset

Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
https://readyset.io
Other
4.54k stars 125 forks source link

[Performance] sysbench oltp_point_select case, max qps limit 10W+ , some opts can optimize ? #1268

Open linuxgood1230 opened 5 months ago

linuxgood1230 commented 5 months ago

sysbench: prepare | run sysbench /usr/share/sysbench/oltp_point_select.lua --db-driver=mysql --mysql-host=xx --mysql-user=root --mysql-password=readyet --mysql-port=3307 --mysql-db=rs_bench --range_size=100 --table_size=1000000 --tables=32 --threads=32 --time=1800 --rand-type=uniform --report-interval=1 run

-- [ 2s ] thds: 32 tps: 105193.50 qps: 105193.50 (r/w/o: 105193.50/0.00/0.00) lat (ms,95%): 0.44 err/s: 0.00 reconn/s: 0.00 -- [ 3s ] thds: 32 tps: 105896.67 qps: 105896.67 (r/w/o: 105896.67/0.00/0.00) lat (ms,95%): 0.44 err/s: 0.00 reconn/s: 0.00 -- [ 4s ] thds: 32 tps: 105613.79 qps: 105613.79 (r/w/o: 105613.79/0.00/0.00) lat (ms,95%): 0.44 err/s: 0.00 reconn/s: 0.00

altmannmarcelo commented 5 months ago

Hi @linuxgood1230

Thanks for taking the time to benchmark Readyset.

Can you please share some details about your installation:

What type of machine is RS running How have you deployed RS (docker, .rpm/.deb, manually compiled)

Are you able to generate a flamegraph so we can see where RS is spending its CPU time?