Analyzing MySQL Logs with ClickHouse
with ProxySQL Extra Bonus © 2018 Percona. 9 Logs to ClickHouse © 2018 Percona. 10 Several Options Logstash (ELK Stack) Kafka Do it yourself © 2018 Percona. 11 Founder and CEO of HoneyComb • cat schema/mysqlaudit.sql | clickhouse-client –multiline • Configure ClickTail • [Required Options] • ParserName = mysqlaudit • LogFiles = /var/lib/mysql/audit.log • Dataset = clicktail.mysql_audit_log [Required Options] • ParserName = mysql • LogFiles = /var/log/mysql/db01-slow.log • Dataset = clicktail.mysql_slow_log © 2018 Percona. 27 Additional Parser Configurarion [MySQL Parser Options] Host0 码力 | 43 页 | 2.70 MB | 1 年前3C++20's
like systems • But for Windows? Not so much...47 The MSVC story for time zone data We had a few options... • Ship the entire IANA time zone database with the library The IANA time zone database is huge source for the data This is where we settled!48 The MSVC story for time zone data We had a few options... • Ship the entire IANA time zone database with the library The IANA time zone database is huge0 码力 | 55 页 | 8.67 MB | 5 月前3C++高性能并行编程与优化 - 课件 - 01 学 C++ 从 CMake 学起
• target_add_definitions(myapp PUBLIC -DMY_MACRO=1) # 与 MY_MACRO=1 等价 • target_compile_options(myapp PUBLIC -fopenmp) # 添加编译器命令行选项 • target_sources(myapp PUBLIC hello.cpp # 添加库文件的搜索路径 • add_definitions(MY_MACRO=1) # 添加一个宏定义 • add_compile_options(-fopenmp) # 添加编译器命令行选项 第三方库 - 作为纯头文件引入 • 有时候我们不满足于 C++ 标准库的功能,难免会用到一些第三方库。 • 最友好的0 码力 | 32 页 | 11.40 MB | 1 年前3谈谈MYSQL那点事
MySQL 技巧分享 技巧分享 Explain Explain 使用 使用 语法: 语法: EXPLAIN SELECT EXPLAIN SELECT select_options select_options Type: Type: 类型,是否使用了索引还是全表扫描 类型,是否使用了索引还是全表扫描 , const,eg_reg,ref,range,index0 码力 | 38 页 | 2.04 MB | 1 年前3C++高性能并行编程与优化 - 课件 - 16 现代 CMake 模块化项目管理指南
cmake/Qt5 了。 科普:亲 Unix 软件从源码安装的通用套路 • Makefile 构建系统: • ./configure --prefix=/usr --with-some-options # 生成 Makefile (这个 configure 脚本由 Autoconf 生 成) • make -j 8 # 8 核心编译,生成 libtest 安装,拷贝到 /usr/lib/libtest.so • CMake 构建系统: • cmake -B build -DCMAKE_INSTALL_PREFIX=/usr -DWITH_SOME_OPTIONS=ON # 生成 Makefile • cmake --build build --parallel 8 # 8 核心编译,生成 libtest.so •0 码力 | 56 页 | 6.87 MB | 1 年前3Bringing Existing Code to CUDA Using constexpr and std::pmr
in future compiler releases. https://docs.nvidia.com/cuda/cuda-compiler-driver-nvcc/ index.html#options-for-altering-compiler-linker-behavior-expt-relaxed- constexpr Using constexpr 40 |constexpr void0 码力 | 51 页 | 3.68 MB | 5 月前3Lock-Free Atomic Shared Pointers Without a Split Reference Count? It Can Be Done!
Daniel Anderson -- danielanderson.net Solution #2: The split reference count Implementation options struct counted_cb { control_block* ctrl; long local_ref_count; }; std::atomiccctrl; 0 码力 | 45 页 | 5.12 MB | 5 月前3C++23: An Overview of Almost All New and Updated Features
Features Garbage Collection Support17 Multidimensional Subscript Operator In the past, two options for accessing multidimensional data: Function call: data(x, y, z) Multiple levels of array0 码力 | 105 页 | 759.96 KB | 5 月前3
共 8 条
- 1