LoginSign Up
← Back to all sparks
M

Manticore Search

DEVOPS
Velocity5.0

Open-source database for full-text search and analytics

manticoresearch.com ↗

Manticore 31.0.7 undoes a 2x COUNT(DISTINCT) slowdown its own collation fix caused.

search-engineopen-sourcesqlperformancemaintenance
◆Current state
Manticore Search's 31.x tags so far are fixes rather than features. 31.0.3 and 31.0.4 were CI and packaging work; 31.0.7 restores string COUNT(DISTINCT) speed after the 29.18.5 collation fix made it 2x slower (1.1 s to 2.4 s on the logs10m benchmark) by calling tolower() per byte. A lookup table replaces the call without changing hash values, so secondary indexes and histograms stay compatible.
◆Where it's heading
October has been correctness work on string handling (range filters, collation-aware COUNT(DISTINCT)) followed by fixing the performance cost of those fixes. The 31.x line still appears in the feed without notes on what features justified the major version.
◆Prediction
Expect more 31.0.x patches in this vein. What new capability defines 31.x remains unclear from these entries.

◆Recent moves

  1. 2d ago

    31.0.7: string COUNT(DISTINCT) 2x slowdown fixed

    Fixes the cost of 29.18.5's collation fix: rowwise COUNT(DISTINCT) on strings had doubled to 2.4 s on the logs10m benchmark and is back to about 1.1 s, with string GROUP BY also faster. Hash values are unchanged, so no index rebuild is needed.

    View source ↗
  2. 5d ago

    31.0.4: CI fix for bundled Debian dependencies

    A CI change so dev bundles can pull Debian dependencies from the release-candidate index. Users see nothing beyond a working build.

    View source ↗
  3. 5d ago

    31.0.3: Test Kit pinned to Executor 1.4.6

    Pins Executor 1.4.6 in the Test Kit so release assets match. The first 31.x tag in the feed is build plumbing, not engine changes.

    View source ↗
  4. 8d ago

    29.18.7: Manticore Buddy sidecar bumped to 4.4.8

    A dependency bump of the Buddy sidecar from 4.4.7 to 4.4.8 with no described user-facing change. It continues the October maintenance run after the September hybrid search features.

    View source ↗
  5. 9d ago

    29.18.6: crash dumps now name the operation and table

    Crash dumps now name the operation and table involved, covering background tasks such as OPTIMIZE, merges and flushes, startup crashes, and per-command reset for SQL, API and HTTP requests. It helps operators and maintainers debug, but doesn't change query behavior.

    View source ↗
  6. 9d ago

    Fix: COUNT(DISTINCT) on strings now respects session collation

    COUNT(DISTINCT) on strings now hashes with the session collation instead of the default one. A narrow follow-up to the larger string-comparison fix released the same day.

    View source ↗