1use 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 let _ = regions;
206 HashMap::default()
207}