cli/
bench.rs

1// Copyright 2023 Greptime Team
2//
3// Licensed under the Apache License, Version 2.0 (the "License");
4// you may not use this file except in compliance with the License.
5// You may obtain a copy of the License at
6//
7//     http://www.apache.org/licenses/LICENSE-2.0
8//
9// Unless required by applicable law or agreed to in writing, software
10// distributed under the License is distributed on an "AS IS" BASIS,
11// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12// See the License for the specific language governing permissions and
13// limitations under the License.
14
15use std::collections::{BTreeMap, HashMap};
16use std::future::Future;
17use std::sync::Arc;
18use std::time::Duration;
19
20use async_trait::async_trait;
21use clap::Parser;
22use common_error::ext::BoxedError;
23use common_meta::key::{TableMetadataManager, TableMetadataManagerRef};
24use common_meta::kv_backend::etcd::EtcdStore;
25use common_meta::kv_backend::memory::MemoryKvBackend;
26#[cfg(feature = "mysql_kvbackend")]
27use common_meta::kv_backend::rds::MySqlStore;
28#[cfg(feature = "pg_kvbackend")]
29use common_meta::kv_backend::rds::PgStore;
30use common_meta::peer::Peer;
31use common_meta::rpc::router::{Region, RegionRoute};
32use common_telemetry::info;
33use common_wal::options::WalOptions;
34use datatypes::data_type::ConcreteDataType;
35use datatypes::schema::{ColumnSchema, RawSchema};
36use rand::Rng;
37use store_api::storage::RegionNumber;
38use table::metadata::{RawTableInfo, RawTableMeta, TableId, TableIdent, TableType};
39use table::table_name::TableName;
40
41use self::metadata::TableMetadataBencher;
42use crate::Tool;
43
44mod metadata;
45
46async fn bench_self_recorded<F, Fut>(desc: &str, f: F, count: u32)
47where
48    F: Fn(u32) -> Fut,
49    Fut: Future<Output = Duration>,
50{
51    let mut total = Duration::default();
52
53    for i in 1..=count {
54        total += f(i).await;
55    }
56
57    let cost = total.as_millis() as f64 / count as f64;
58    info!("{desc}, average operation cost: {cost:.2} ms");
59}
60
61#[derive(Debug, Default, Parser)]
62pub struct BenchTableMetadataCommand {
63    #[clap(long)]
64    etcd_addr: Option<String>,
65    #[cfg(feature = "pg_kvbackend")]
66    #[clap(long)]
67    postgres_addr: Option<String>,
68    #[cfg(feature = "mysql_kvbackend")]
69    #[clap(long)]
70    mysql_addr: Option<String>,
71    #[clap(long)]
72    count: u32,
73}
74
75impl BenchTableMetadataCommand {
76    pub async fn build(&self) -> std::result::Result<Box<dyn Tool>, BoxedError> {
77        let kv_backend = if let Some(etcd_addr) = &self.etcd_addr {
78            info!("Using etcd as kv backend");
79            EtcdStore::with_endpoints([etcd_addr], 128).await.unwrap()
80        } else {
81            Arc::new(MemoryKvBackend::new())
82        };
83
84        #[cfg(feature = "pg_kvbackend")]
85        let kv_backend = if let Some(postgres_addr) = &self.postgres_addr {
86            info!("Using postgres as kv backend");
87            PgStore::with_url(postgres_addr, "greptime_metakv", 128)
88                .await
89                .unwrap()
90        } else {
91            kv_backend
92        };
93
94        #[cfg(feature = "mysql_kvbackend")]
95        let kv_backend = if let Some(mysql_addr) = &self.mysql_addr {
96            info!("Using mysql as kv backend");
97            MySqlStore::with_url(mysql_addr, "greptime_metakv", 128)
98                .await
99                .unwrap()
100        } else {
101            kv_backend
102        };
103
104        let table_metadata_manager = Arc::new(TableMetadataManager::new(kv_backend));
105
106        let tool = BenchTableMetadata {
107            table_metadata_manager,
108            count: self.count,
109        };
110        Ok(Box::new(tool))
111    }
112}
113
114struct BenchTableMetadata {
115    table_metadata_manager: TableMetadataManagerRef,
116    count: u32,
117}
118
119#[async_trait]
120impl Tool for BenchTableMetadata {
121    async fn do_work(&self) -> std::result::Result<(), BoxedError> {
122        let bencher = TableMetadataBencher::new(self.table_metadata_manager.clone(), self.count);
123        bencher.bench_create().await;
124        bencher.bench_get().await;
125        bencher.bench_rename().await;
126        bencher.bench_delete().await;
127        Ok(())
128    }
129}
130
131fn create_table_info(table_id: TableId, table_name: TableName) -> RawTableInfo {
132    let columns = 100;
133    let mut column_schemas = Vec::with_capacity(columns);
134    column_schemas.push(
135        ColumnSchema::new(
136            "ts",
137            ConcreteDataType::timestamp_millisecond_datatype(),
138            true,
139        )
140        .with_time_index(true),
141    );
142
143    for i in 1..columns {
144        let column_name = format!("my_column_{i}");
145        column_schemas.push(ColumnSchema::new(
146            column_name,
147            ConcreteDataType::string_datatype(),
148            true,
149        ));
150    }
151
152    let meta = RawTableMeta {
153        schema: RawSchema::new(column_schemas),
154        engine: "mito".to_string(),
155        created_on: chrono::DateTime::default(),
156        primary_key_indices: vec![],
157        next_column_id: columns as u32 + 1,
158        value_indices: vec![],
159        options: Default::default(),
160        region_numbers: (1..=100).collect(),
161        partition_key_indices: vec![],
162    };
163
164    RawTableInfo {
165        ident: TableIdent {
166            table_id,
167            version: 1,
168        },
169        name: table_name.table_name,
170        desc: Some("blah".to_string()),
171        catalog_name: table_name.catalog_name,
172        schema_name: table_name.schema_name,
173        meta,
174        table_type: TableType::Base,
175    }
176}
177
178fn create_region_routes(regions: Vec<RegionNumber>) -> Vec<RegionRoute> {
179    let mut region_routes = Vec::with_capacity(100);
180    let mut rng = rand::rng();
181
182    for region_id in regions.into_iter().map(u64::from) {
183        region_routes.push(RegionRoute {
184            region: Region {
185                id: region_id.into(),
186                name: String::new(),
187                partition: None,
188                attrs: BTreeMap::new(),
189            },
190            leader_peer: Some(Peer {
191                id: rng.random_range(0..10),
192                addr: String::new(),
193            }),
194            follower_peers: vec![],
195            leader_state: None,
196            leader_down_since: None,
197        });
198    }
199
200    region_routes
201}
202
203fn create_region_wal_options(regions: Vec<RegionNumber>) -> HashMap<RegionNumber, WalOptions> {
204    // TODO(niebayes): construct region wal options for benchmark.
205    let _ = regions;
206    HashMap::default()
207}