谈谈MYSQL那点事互联网常用数据库市场占有率 互联网通用架构体制 谈谈 MySQL 数据库那些事 MySQL MySQL 基本介绍 基本介绍 MySQL MySQL 优化方式 优化方式 MySQL MySQL 技巧分享 技巧分享 Q Q & & AA MyISAM MyISAM 特点 特点 MyISAM vs MyISAM vs InnoDB InnoDB • 数据存储方式简单,使用 • 二进制层次的文件可以移植 二进制层次的文件可以移植 (Linux (Linux Windows) Windows) • 访问速度飞快,是所有 访问速度飞快,是所有 MySQL MySQL 文件引擎中速度最快的 文件引擎中速度最快的 • 不支持一些数据库特性,比如 事务、外键约束等 不支持一些数据库特性,比如 事务、外键约束等 • Table level lock Table 读写性能都非常优秀 读写性能都非常优秀 • 能够承载大数据量的存储和访问 能够承载大数据量的存储和访问 • 拥有自己独立的缓冲池,能够缓存数据和索引 拥有自己独立的缓冲池,能够缓存数据和索引 MySQL 架构设计—应用架构 强一致性 对读一致性的权衡,如果是对读写实时性要求非常高的话, 就将读写都放在 M1 上面, M2 只是作为 standby 。 比如,订单处理流程,那么对读需要强一致性,实时写实0 码力 | 38 页 | 2.04 MB | 1 年前3
Analyzing MySQL Logs with ClickHouse© 2018 Percona. 1 Peter Zaitsev Analyzing MySQL Logs with ClickHouse CEO, Percona April 27,2018 © 2018 Percona. 2 ClickHouse is my love at the first sight © 2018 Percona. 3 Why ? Fast and and Efficient Built with Purpose Practical Features Easy to Use MySQL inspired © 2018 Percona. 4 MySQL inspired © 2018 Percona. 5 Why Keep and Analyze Raw Logs ? Raw Logs Contain ultimate Typically 100x faster than MySQL on Single Server • Semi-Linear Scalability to 100s of nodes High Performance © 2018 Percona. 8 MySQL Wire Protocol Compatibility with ProxySQL Extra Bonus0 码力 | 43 页 | 2.70 MB | 1 年前3
sync clickhouse with mysql mongodbSync Clickhouse with MySQL/MongoDB Company: Xiaoxin Tech. Industry: Education Team: Big Data Leader: wangchao@xiaoheiban.cn About 100 billion data this year till now 30 million users We use binlog/oplog CRUD directly Can’t update/delete table frequently in Clickhouse Possible Solutions 2. MySQL Engine Not suitable for big tables Not suitable for MongoDB Possible Solutions 3. Reinit whole Must Listen ● Merge sharding tables ● SolidKey Typical Provider Config { Type: mysql, // mysql, mongodb, redis Listen: binlog, // binlog, kafka DataSource: user:pass@tcp(example0 码力 | 38 页 | 2.25 MB | 1 年前3
C++20 STL Features: 1 Year of Development on GitHubatomic operations only when necessary • Distinct non-conflicting and conflicting parts • Layout compatibility; works with T within C structs • Near-identical interface • Encapsulates platform/architecture-specific Developer Community, Azure Boards, todos • GH-713 boyer_moore_searcher • vNext issues affect binary compatibility • Will start vNext after finishing C++2031 cxx20 Issues32 Pull Requests • GH-724 Fix boyer_moore_searcher evolving • Careful code review avoids regressions, new bugs • Especially important for binary compatibility • Codebase consistency is important, especially now • Ideally, looks like the work of a single0 码力 | 45 页 | 702.09 KB | 6 月前3
使用硬件加速Tokio - 戴翔currently provides only the bare essentials for writing async code. Rust has very strict backward compatibility requirements, , and they haven't chosen to lock- in a specific runtime. Why need Tokio? Rust0 码力 | 17 页 | 1.66 MB | 1 年前3
基于Rust-vmm实现Kubernetes运行时Kata-container BareMetal Only Heavy control logic Application kernel based Sandbox gVisor Compatibility problem, Bottleneck in sentry mVMd + QEMU + eklet is what we need to implement Elastic Kubernetes0 码力 | 27 页 | 34.17 MB | 1 年前3
whats new in visual studiodirectly from Visual Studio 2022 Step #3: Compile your code with the latest compiler 💡 Binary compatibility between the VS2022 and previous C++ runtimes (VS 2019, VS 2017, VS 2015) Step #4: Compile your0 码力 | 42 页 | 19.02 MB | 6 月前3
hazard pointer synchronous reclamationReclamation Beyond Concurrency TS2 – Maged Michael // Extend hazard_pointer_obj_base (subject to ABI-compatibility) class hazard_pointer_obj_base { public: void set_cohort(hazard_pointer_cohort* cohort) noexcept;0 码力 | 31 页 | 856.38 KB | 6 月前3
共 8 条
- 1













