# Manticore Search 7.4.6: Kibana Integration, Performance Optimizations, and Critical Fixes Manticore Search 7.4.6 introduces Kibana integration, join query optimizations, and fixes for critical issues to enhance stability and performance We're excited to announce the release of **Manticore Search 7.4.6**, bringing powerful data visualization capabilities through Kibana integration, significant performance optimizations for joins and histograms, and numerous bug fixes to enhance stability and reliability. --- ### 📊 Kibana Integration for Advanced Data Visualization The standout feature of this release is the long-awaited **[Kibana integration](https://manual.manticoresearch.com/Integration/Kibana)** ([#832](https://github.com/manticoresoftware/manticoresearch/issues/832)), enabling easier and more efficient data visualization. Now you can create stunning dashboards, charts, and visualizations directly from your Manticore Search data, making it simpler than ever to derive insights from complex datasets. This integration opens up new possibilities for monitoring, analytics, and business intelligence applications built on Manticore Search. **Try it yourself**: We've created a [ready-to-use demo repository](https://github.com/manticoresoftware/kibana-demo) that showcases the Manticore-Kibana integration and allows you to compare performance with Elasticsearch. Our tests with approximately 40 million documents show that the same dashboard renders in just 7 seconds with Manticore Search, compared to 18 seconds with Elasticsearch! Another example: {{< youtube M6i3gthKZh8 >}} --- ### ⚡ Performance Optimizations This release includes several significant performance improvements: - **Join Query Batching** ([#2995](https://github.com/manticoresoftware/manticoresearch/issues/2995)): We've implemented optimizations for join batching, significantly improving performance for complex join operations. - **Histogram Optimizations** ([#3039](https://github.com/manticoresoftware/manticoresearch/issues/3039)): EstimateValues in histograms now performs better, enabling faster analytics on large datasets. - **Columnar Storage Enhancements** ([#77](https://github.com/manticoresoftware/columnar/issues/77)): We've optimized block data reuse when creating filters with multiple values, added min/max to attribute metadata, and implemented pre-filtering of filter values based on min/max, resulting in faster query execution. - **Cross-Platform Consistency** ([#1727](https://github.com/manticoresoftware/manticoresearch/issues/1727)): Fixed floating-point precision differences between arm64 and x86_64 architectures, ensuring consistent results across platforms. --- ### 🔧 Critical Bug Fixes This release addresses several important issues: * **Join Query Improvements**: - Fixed handling of expressions in joined queries when attributes from both tables are used ([Commit 73ac](https://github.com/manticoresoftware/manticoresearch/commit/73ac22f358a7a0e734b332c3943c86e6294c06c3)) - Fixed incorrect results when using `avg()` in JOIN queries ([#2915](https://github.com/manticoresoftware/manticoresearch/issues/2915)) - Fixed incorrect result sets caused by implicit cutoff with join batching ([#2996](https://github.com/manticoresoftware/manticoresearch/issues/2996)) - Fixed a memory leak in the join query cache ([#3042](https://github.com/manticoresoftware/manticoresearch/issues/3042)) - Fixed handling of query options in joined JSON queries ([#3052](https://github.com/manticoresoftware/manticoresearch/issues/3052)) * **Stability Enhancements**: - Fixed a crash during shutdown when an active chunk merge was in progress ([#3031](https://github.com/manticoresoftware/manticoresearch/issues/3031)) - Fixed a daemon crash caused by a full-text query with a single `NOT` operator and an expression ranker ([#3126](https://github.com/manticoresoftware/manticoresearch/issues/3126)) - Fixed a potential vulnerability in the CJSON library ([#3128](https://github.com/manticoresoftware/manticoresearch/pull/3128)) ❤️ Thank you, [@tabudz](https://github.com/tabudz) for the PR * **Query and Data Handling**: - Fixed an issue where `IN(...)` could produce incorrect results ([#3037](http://github.com/manticoresoftware/manticoresearch/issues/3037)) - Fixed issues with the ATTACH TABLE command ([#3054](https://github.com/manticoresoftware/manticoresearch/issues/3054)) - Resolved duplicate entries after bulk replacing large IDs ([#3088](https://github.com/manticoresoftware/manticoresearch/issues/3088)) * **Configuration and Performance**: - Fixed an issue where setting `max_iops` / `max_iosize` in version 7.0.0 could degrade indexing performance ([#3038](https://github.com/manticoresoftware/manticoresearch/issues/3038)) - Fixed an issue where setting `diskchunk_flush_write_timeout=-1` per table did not disable index flushing ([#3087](https://github.com/manticoresoftware/manticoresearch/issues/3087)) --- ### 🔄 New Semantic Versioning System With this release, we're also introducing a significant improvement to our versioning strategy. Manticore 7.4.6 marks the beginning of our transition to true [Semantic Versioning](https://semver.org/), making version numbers more meaningful and predictable for developers. Key benefits include clearer communication about the nature of changes, independent package versioning, improved development tracking, and better automation support. This change represents our commitment to providing a more transparent and developer-friendly experience. For more details about this important change, see our dedicated blog post: [About Versioning in Manticore](/blog/semver/). --- ### 📚 Additional Improvements - **Boost 1.87.0 Support** ([#3099](https://github.com/manticoresoftware/manticoresearch/issues/3099)): Added support for the latest Boost library version. ❤️ Thank you, [@cho-m](https://github.com/cho-m) for the PR. - **Error Message Consistency** ([#3079](https://github.com/manticoresoftware/manticoresearch/issues/3079)): Fixed inconsistencies in error messages for a better developer experience. --- ## 🚀 Get Started Today Upgrade to **Manticore Search 7.4.6** to take advantage of these powerful new features and improvements. For a full list of changes, visit the [changelog](https://manual.manticoresearch.com/Changelog). **We'd love to hear from you!** - Join the discussion on our [Community Forum](https://forum.manticoresearch.com) - Report issues or suggest features on [GitHub](https://github.com/manticoresoftware/manticoresearch/issues) - Chat with us on [Slack](https://slack.manticoresearch.com) - Email us directly at `contact@manticoresearch.com` *Special thanks to contributors [@cho-m](https://github.com/cho-m), [@tabudz](https://github.com/tabudz), and all who helped shape this release!* ❤️