> For the complete documentation index, see [llms.txt](https://docs.lenses.io/latest/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.lenses.io/latest/devx/6.1/changelog/lenses-agent/6.1.3/features-improvements-and-fixes.md).

# Features / Improvements & Fixes

Changelog details for Lenses 6.1.3

## Improvements :muscle:

## SQL Snapshot Performance

**Release Notes: SQL Engine Enhancements**

**Problem Addressed**: The engine previously permitted unlimited concurrent queries, risking excessive CPU and memory consumption.

**Solution Implemented**: Introduced configurable limits for concurrent queries to ensure balanced resource usage and system stability.

**New Configuration Options**:

* `max.concurrent.queries`: Global query limit (default: 100).
* `max.concurrent.queries.per.user`: Per-user query limit (default: 2).

**SQL Usage Enhancements**: Admins can modify limits via Lenses configuration:

* `lenses.sql.settings.max.concurrent.queries=200`
* `lenses.sql.settings.max.concurrent.queries.per.user=1`

**Impact**:

* Prevents Out-Of-Memory (OOM) errors due to query overload.
* Ensures equitable resource distribution.
* Offers clear error messages to enhance user experience.

## SQL Snapshot Performance

To alleviate CPU and memory pressure, the engine now avoids duplicating internal buffers. The default value has been adjusted from 50,000 to 5,000. You can modify this value using the following methods:

1. Through SET statements:\
   `SET query.buffer=10000; <your query>`
2. In the agent configuration, either in `provision.yml` or `lenses.conf` (depending on your deployment method):\
   `lenses.sql.settings.query.buffer = 10000`

## Topic storage format identification

The update enhances the identification of strings, bytes, and integers/longs in a topic Key or Value format.

## Fixes 🛠️

### **Kafka Insert Messages**

Addresses a gap in the feature where inserting data for a Kafka data involving Avro schema with different Enum classes sharing the same name but different namespace.

#### Other fixes

* Fixed topic format identification for Confluent wire format, binary/string/emoji handling
* Fixed quota parsing for usernames containing slashes
* Fixed WebSocket status updates when processor actions fail


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.lenses.io/latest/devx/6.1/changelog/lenses-agent/6.1.3/features-improvements-and-fixes.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.