kevin

摘要: 由于100GB数据量时执行Q16发生了OOM，以10GB数据量作为测试 运行统计: 耗时: explain执行计划分析: mysql> explain select -> p_brand, -> p_type, -> p_size, -> count(distinct ps_suppkey) as supplier_cnt -> from -> partsupp, -> part -> where -> p_partkey =...

对比mysql/innodb 摘要: 分析mysql/innodb如何处理Q17 硬件环境: 1. 内存: 8GB 2. cpu: 8核心， 3.2GHz 3. mysql: 8.0.28 explain分析: mysql> explain select -> p_brand, -> p_type, -> p_size, -> count(distinct ps_suppkey) as supplier_cnt ->...

摘要: 分析Q16执行耗时究竟在哪里 分析: 火焰图： 分析: 1. 占用时间的大头在物化中的aggregate 日志埋点: [2022-08-09 21:58:35.661551] [61425] [INFO] [temp_table.cpp:2043] MSG: Timer 0.006423 : TempTable::Materialize over [2022-08-09 21:58:40.601132] [61425] [INFO] [aggregation_algorithm.cpp:75] MSG: AggregationAlgorithm [AggregationAlgorithm::Aggregate start] memLeft: 250803432...

> Now mtr in 5.7 is not work, would you make a pr to fix this? sure

It does not continue to appear in later versions

gcc version `[root@LAPTOP-R709FV7O rocksdb-6.12.6]# gcc -v Using built-in specs. COLLECT_GCC=gcc COLLECT_LTO_WRAPPER=/opt/rh/devtoolset-7/root/usr/libexec/gcc/x86_64-redhat-linux/7/lto-wrapper Target: x86_64-redhat-linux Configured with: ../configure --enable-bootstrap --enable-languages=c,c++,fortran,lto --prefix=/opt/rh/devtoolset-7/root/usr --mandir=/opt/rh/devtoolset-7/root/usr/share/man --infodir=/opt/rh/devtoolset-7/root/usr/share/info --with-bugurl=http://bugzilla.redhat.com/bugzilla --enable-shared --enable-threads=posix --enable-checking=release --enable-multilib --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-gnu-unique-object...

on centos7.9 use gcc7.3 build rocksdb6.12.6 faild ` /opt/rh/devtoolset-7/root/usr/libexec/gcc/x86_64-redhat-linux/7/ar: creating librocksdb_env_basic_test.a CCLD cache_test CCLD lru_cache_test test_util/testutil.o: In function `rocksdb::WritableFileWriter::WritableFileWriter(std::unique_ptr&&, std::string const&, rocksdb::FileOptions const&, rocksdb::Env*, rocksdb::Statistics*, std::vector const&, rocksdb::FileChecksumGenFactory*)': /root/work/github/rocksdb-6.12.6/./file/writable_file_writer.h:167: undefined...

In Tianmu engine conversion syntax tree code style collation In the code logic of Tianmu engine conversion syntax tree, a large number of if judgment returns to the same line...

What is the table structure? What is the statement for the amount of data inserted? What is the amount of data

Requirements: 1. Support dynamic function call in column storage engine 2. Use custom dynamic function function query statement, query performance approximates SQL rewritten statement (millisecond level)