Tagged articles
TokuDB
19 articles · Page 1 of 1
This article details a real‑world test of loading over 20 billion records into MySQL with XeLabs TokuDB, covering the demand, configuration tweaks, table schema, bulk‑loader commands, performance metrics, comparison with InnoDB, and practical conclusions for large‑scale data ingestion.
Large DataMySQLTokuDB
0 likes · 7 min read

This article details a real‑world test of loading over 200 million rows into MySQL using XeLabs TokuDB, showing configuration tweaks, bulk‑loader commands, performance metrics (≈570 k rows per second), file‑size reductions, and comparisons with InnoDB under a 8‑core, 8 GB RAM, 500 GB SSD environment.
Large DataMySQLTokuDB
0 likes · 6 min read

This article describes a real‑world requirement to import over 2 billion records into MySQL, analyzes the challenges, introduces XeLabs TokuDB with its optimizations, details the test schema and configuration, demonstrates bulk loading commands, presents performance metrics showing up to 570 k rows per second, and concludes with practical recommendations and environment details.
Large DataMySQLTokuDB
0 likes · 7 min read


21CTOJul 23, 2020 · Databases
This article explains how a friend loaded over 2 billion rows into MySQL using XeLabs TokuDB, detailing configuration, bulk‑load commands, benchmark results of roughly 574 k rows per second, and comparisons with InnoDB performance on a cloud server.
MySQLTokuDBbulk load
0 likes · 6 min read


ITPUBJul 23, 2020 · Databases
This article details a real‑world test that loads 200 million rows into a MySQL TokuDB table in under six minutes, achieving roughly 570 k writes per second, and compares the results with InnoDB while providing configuration tips and bulk‑loader considerations.
MySQLTokuDBbulk load
0 likes · 6 min read


ITPUBJul 22, 2020 · Databases
This article explains how to load over 20 billion rows into MySQL using the XeLabs‑compiled TokuDB engine, detailing configuration tweaks, table schema, bulk‑loader commands, benchmark results that reach 574 k rows per second, and practical tips for handling auto‑increment keys.
MySQLTokuDBbulk load
0 likes · 7 min read


21CTOJul 9, 2019 · Databases
This article details a real‑world performance test of loading over two billion rows from a big‑data platform into MySQL using XeLabs TokuDB, covering requirements, TokuDB features, table schema, bulk‑load commands, results, and practical recommendations for high‑throughput data ingestion.
Large DataMySQLTokuDB
0 likes · 6 min read


ITPUBJul 5, 2019 · Databases
A friend needed to import over 2 billion records from a big‑data platform into MySQL for next‑day reporting, so we evaluated InnoDB versus XeLabs TokuDB, configured TokuDB parameters, created test tables, used LOAD DATA, measured write speed, file size, and discovered TokuDB can achieve about 570 k rows per second, roughly three to four times faster than InnoDB, especially when avoiding auto‑increment columns.
Large Data ImportMySQLTokuDB
0 likes · 8 min read

This article describes how to ingest more than two billion records into MySQL by leveraging XeLabs TokuDB’s bulk‑loader, detailing configuration, table schema, performance metrics, and a comparison with InnoDB to demonstrate a three‑to‑fourfold speed improvement.
Large DataMySQLTokuDB
0 likes · 7 min read


21CTOFeb 14, 2019 · Databases
This article details a real‑world test of loading over 2 billion rows into MySQL using XeLabs TokuDB, compares InnoDB and TokuDB performance, shows configuration, table schema, bulk‑loader commands, and provides practical conclusions for high‑throughput data ingestion.
Large DataMySQLTokuDB
0 likes · 7 min read

This article describes how to quickly import more than two billion rows from a big‑data source into MySQL by leveraging XeLabs TokuDB’s bulk‑loader, showing configuration, code examples, performance results, and practical recommendations for handling large‑scale data ingestion.
Large DataMySQLTokuDB
0 likes · 6 min read

This article describes a real‑world test of loading over 2 billion records from a big‑data platform into MySQL using XeLabs TokuDB, showing configuration details, performance results, and practical tips for achieving up to 570 k rows per second on a cloud instance.
MySQLTokuDBbig data loading
0 likes · 5 min read

This article walks through a real‑world case of MySQL 5.7 replication delay after switching to TokuDB, presenting a step‑by‑step methodology that examines network, hardware, large transactions, locks, configuration parameters, and multi‑threaded replication to identify and resolve the root cause.
DBALAGMySQL
0 likes · 12 min read

The benchmark shows that while InnoDB delivers roughly 30 % higher insert throughput than TokuDB, the TokuDB engine achieves 10‑16× storage compression with comparable import times, minimal impact from log‑sync settings, and zlib emerging as the preferred compression algorithm for balanced performance and CPU usage.
CompressionInnoDBMySQL
0 likes · 18 min read

This article analyzes why redirecting MySQLdump output can crash the client, explores a GTID_PURGED bug that breaks AUTO_POSITION replication, examines GTID gaps caused by replicate‑do‑db filtering, and explains why TokuDB's OPTIMIZE TABLE appears to increase table size.
DUMPDatabase BugsGTID
0 likes · 13 min read

This article examines how differing key‑hash algorithms in MySQL 5.1 versus 5.5/5.6 cause data loss in partitioned tables, describes compatibility fixes with ALTER TABLE … ALGORITHM=1, analyzes a MySQL client crash caused by mis‑redirected dump output, explores GTID_PURGED replication issues and replicate‑do‑db filtering gaps, and evaluates the behavior of OPTIMIZE TABLE on TokuDB tables.
BackendGTIDMySQL
0 likes · 18 min read


21CTOOct 20, 2015 · Databases
This article examines why MySQL 5.5/5.6 fails to retrieve non‑null partitioned rows after a physical upgrade, how the ALTER TABLE … PARTITION BY KEY ALGORITHM=1 fix works, the cause of MySQL client crashes when dump output mixes warnings, GTID_PURGED replication bugs, replicate‑filter side effects, and the behavior of TokuDB’s OPTIMIZE TABLE.
GTIDMySQLOptimization
0 likes · 19 min read


21CTOSep 25, 2015 · Databases
This article explains the evolution of MySQL's metadata lock (MDL) subsystem, the introduction of lock‑free hash tables and fast‑path locking in 5.7, the hash_scan replication optimization, TokuDB 7.5.0 enhancements, and MariaDB's small‑LIMIT filesort improvement, providing deep insight into modern database performance tuning.
Hash ScanMariaDBMetadata Lock
0 likes · 17 min read

This article presents a practical performance comparison between TokuDB and InnoDB, covering compression ratio, insert speed, online DDL operations, CPU usage, IOPS, and response time, and concludes with the advantages and drawbacks of adopting TokuDB in production.
CompressionDatabase PerformanceInsert Speed
0 likes · 7 min read
