# Manticore Search 9.3.2: Enhanced Table Usage Tracking, Memory Optimization and Stability Improvements

Manticore Search 9.3.2 brings improved table usage tracking, memory optimization, and numerous stability enhancements

We're excited to announce the release of **Manticore Search 9.3.2**, bringing enhanced table usage tracking, memory optimization, and numerous stability improvements to make your search experience more reliable and efficient.

---

### 🛠️ New Features and Improvements

This release includes several enhancements:

- **Per-Table Command Counter and Usage Statistics** ([PR #3337](https://github.com/manticoresoftware/manticoresearch/pull/3337)): Added detailed table usage statistics and command tracking for better monitoring and optimization.
![SHOW TABLE TEST STATUS](./manticore-search-9-3-2/show-table-status.png)

- **Memory Usage Optimization** ([v9.2.32](https://github.com/manticoresoftware/manticoresearch/releases/tag/9.2.32)): Reduced peak memory usage during merge operations. Document ID to row ID lookups now use 12 bytes per document instead of 16 bytes, significantly reducing memory requirements (e.g., 24 GB RAM for 2 billion documents instead of 36 GB).

---

### 🔧 Critical Bug Fixes and Stability Improvements

This release addresses several important issues:

* **Memory and Resource Management**:
   - Fixed OOM (Out Of Memory) errors when using `ORDER BY` and `WHERE` on `id` ([Issue #3301](https://github.com/manticoresoftware/manticoresearch/issues/3301))
   - Improved handling of large document IDs to prevent search failures ([Issue #3090](https://github.com/manticoresoftware/manticoresearch/issues/3090))
   - Fixed undefined behavior when zeroing string attributes ([v9.2.30](https://github.com/manticoresoftware/manticoresearch/releases/tag/9.2.30))

* **Table and Index Management**:
   - Fixed table damage issues by removing complex chunk updates and refactoring autoflush ([Issue #3236](https://github.com/manticoresoftware/manticoresearch/issues/3236))
   - Fixed incorrect `COUNT(*)` values in large real-time tables ([Issue #3238](https://github.com/manticoresoftware/manticoresearch/issues/3238))
   - Fixed leftover `tmp.spidx` files when the optimize process was interrupted ([Issue #3343](https://github.com/manticoresoftware/manticoresearch/issues/3343))

* **Query and Search Improvements**:
   - Fixed crash when using grouper with multiple JSON attributes on RT tables with multiple disk chunks ([Issue #3171](https://github.com/manticoresoftware/manticoresearch/issues/3171))
   - Fixed `WHERE string ANY(...)` queries failing after RAM chunk flush ([Issue #3246](https://github.com/manticoresoftware/manticoresearch/issues/3246))
   - Fixed bug in distance calculation when using the `GEODIST` function ([Issue #3063](https://github.com/manticoresoftware/manticoresearch/issues/3063))

* **Integration and Compatibility**:
   - Added support for creating Kafka sources for specific partitions ([Issue #3032](https://github.com/manticoresoftware/manticoresearch/issues/3032))
   - Fixed build compatibility with Boost 1.88.0 ([PR #3275](https://github.com/manticoresoftware/manticoresearch/pull/3275))
   - Added support for Elastic's `query_string` filter format ([Issue #3027](https://github.com/manticoresoftware/manticoresearch/issues/3027))

---

## 🚀 Get Started Today

Upgrade to **Manticore Search 9.3.2** to take advantage of these 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`