mastodon.online is one of the many independent Mastodon servers you can use to participate in the fediverse.
A newer server operated by the Mastodon gGmbH non-profit

Server stats:

11K
active users

#clickhouse

2 posts2 participants0 posts today
Habr<p>Отказоустойчивая распределённая архитектура для UX-аналитики</p><p>UX-аналитика – это сбор и анализ данных о взаимодействии пользователей с интерфейсом (клики, скроллы, навигация и прочие события). Такие события генерируются в огромных количествах, особенно при большой аудитории приложения. Чтобы эффективно обрабатывать эту информацию, необходима распределённая архитектура, способная масштабироваться под высокий поток событий и обеспечивать отказоустойчивость – т.е. работать надёжно даже при сбоях отдельных компонентов. Также важна возможность обработки данных в реальном времени , чтобы как можно быстрее получать метрики и инсайты об опыте пользователей. В этой статье мы рассмотрим ключевые аспекты такой архитектуры: масштабирование UX-событий, надёжный сбор метрик с устройств (в том числе офлайн), реалтайм-аналитику на основе потоковых технологий (Kafka, Flink, Kafka Streams, ClickHouse) и механизмы гарантированной доставки событий (at-least-once, exactly-once, retry, дедупликация). В результате станет понятно, как правильно спроектированная система UX-аналитики позволяет оперативно находить проблемные места UI, проводить A/B тесты и глубже понимать поведение пользователей.</p><p><a href="https://habr.com/ru/articles/897798/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">habr.com/ru/articles/897798/</span><span class="invisible"></span></a></p><p><a href="https://zhub.link/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a> <a href="https://zhub.link/tags/kafka" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>kafka</span></a> <a href="https://zhub.link/tags/flink" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>flink</span></a> <a href="https://zhub.link/tags/kafka_streams" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>kafka_streams</span></a> <a href="https://zhub.link/tags/%D1%80%D0%B0%D1%81%D0%BF%D1%80%D0%B5%D0%B4%D0%B5%D0%BB%D0%B5%D0%BD%D0%BD%D1%8B%D0%B5_%D1%81%D0%B8%D1%81%D1%82%D0%B5%D0%BC%D1%8B" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>распределенные_системы</span></a> <a href="https://zhub.link/tags/%D0%BE%D1%82%D0%BA%D0%B0%D0%B7%D0%BE%D1%83%D1%81%D1%82%D0%BE%D0%B9%D1%87%D0%B8%D0%B2%D1%8B%D0%B5_%D1%81%D0%B8%D1%81%D1%82%D0%B5%D0%BC%D1%8B" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>отказоустойчивые_системы</span></a> <a href="https://zhub.link/tags/%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D1%82%D0%B8%D0%BA%D0%B0" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>аналитика</span></a> <a href="https://zhub.link/tags/%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D0%B7_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>анализ_данных</span></a> <a href="https://zhub.link/tags/%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D0%B7_%D0%B8_%D0%BF%D1%80%D0%BE%D0%B5%D0%BA%D1%82%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5_%D1%81%D0%B8%D1%81%D1%82%D0%B5%D0%BC" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>анализ_и_проектирование_систем</span></a> <a href="https://zhub.link/tags/%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D0%B7" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>анализ</span></a></p>
Habr<p>Шардированный кластер ClickHouse</p><p>Хочу рассказать, как спроектированы распределённые вычисления в ClickHouse. Вы узнаете, на что влияет схема кластера (и на что не влияет). Расскажу, как можно на ровном месте создать себе проблему при помощи всего одной таблицы Kafka и нескольких матвьюх. Поделюсь опытом про дебаг и оптимизацию SELECT-запросов к Distributed таблицам: поизучаем планы выполнения и поэксперементируем с настройками в блоке SETTINGS.</p><p><a href="https://habr.com/ru/companies/wildberries/articles/896060/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">habr.com/ru/companies/wildberr</span><span class="invisible">ies/articles/896060/</span></a></p><p><a href="https://zhub.link/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a> <a href="https://zhub.link/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://zhub.link/tags/bigdata" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>bigdata</span></a> <a href="https://zhub.link/tags/%D1%85%D1%80%D0%B0%D0%BD%D0%B5%D0%BD%D0%B8%D0%B5_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>хранение_данных</span></a> <a href="https://zhub.link/tags/data_engineering" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>data_engineering</span></a> <a href="https://zhub.link/tags/mpp" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mpp</span></a> <a href="https://zhub.link/tags/shared_nothing" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>shared_nothing</span></a></p>
Habr<p>Sandbox DB: универсальная песочница для погружения в Big Data, аналитику и визуализацию</p><p>Запускайте PostgreSQL, ClickHouse, Airflow, Superset и другие инструменты одним кликом: учите, экспериментируйте, осваивайте новое!</p><p><a href="https://habr.com/ru/articles/896054/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">habr.com/ru/articles/896054/</span><span class="invisible"></span></a></p><p><a href="https://zhub.link/tags/%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D0%B7_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>анализ_данных</span></a> <a href="https://zhub.link/tags/%D0%B1%D0%B0%D0%B7%D1%8B_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>базы_данных</span></a> <a href="https://zhub.link/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>python</span></a> <a href="https://zhub.link/tags/spark" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>spark</span></a> <a href="https://zhub.link/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a> <a href="https://zhub.link/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgres</span></a> <a href="https://zhub.link/tags/superset" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>superset</span></a></p>
Scott Laird<p>Okay, there -- first pass done. <a href="https://github.com/scottlaird/nel-collector" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/scottlaird/nel-coll</span><span class="invisible">ector</span></a> is a <a href="https://hachyderm.io/tags/NEL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NEL</span></a> (Network Error Log) collector that can listen on HTTP for NEL messages from Chrome, etc and log them to a DB.</p><p>It should be at least somewhat DB-agnostic, although I've only tested it with <a href="https://hachyderm.io/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a> so far.</p><p>It also includes otel tracing, which is uglier than I'd like in Go, but seems to be working. I still need to get trace propagation through it to the DB backend working, but I think that's a problem with the backend config, not my code. Probably.</p><p>I'm still using <a href="https://hachyderm.io/tags/vector" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>vector</span></a> for this at home right now; I'll probably cut over tomorrow.</p>
Julio Jimenez<p><span class="h-card" translate="no"><a href="https://hachyderm.io/@laird" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>laird</span></a></span> <a href="https://fosstodon.org/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a> o11y is the hot thing right now. Have you checked out <a href="https://fosstodon.org/tags/hyperdx" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>hyperdx</span></a>?</p>
Scott Laird<p>This morning's accomplishment: finally setting up an otel collector at home, pointing it at <a href="https://hachyderm.io/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a>, getting <a href="https://hachyderm.io/tags/caddy" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>caddy</span></a> tracing via otel, and throwing a <a href="https://hachyderm.io/tags/grafana" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>grafana</span></a> dashboard on it.</p><p>I didn't expect the dashboard to be the hard part.</p>
Habr<p>Кардинальность при оптимизации DAX запросов в ClickHouse</p><p>Привет, Хабр! Мы уже неоднократно поднимали вопросы оптимизации запросов к СУБД ClickHouse, которую все чаще используют как универсальное высокопроизводительное хранилище для аналитических задач. В случае с Visiology этот вопрос приобретает двойную ценность, так как мы используем оптимизацию для эффективного выполнения запросов в языке DAX. Сегодня мы поговорим о применении группировок GROUP BY с учетом их производительности для относительно больших таблиц, например, с миллионами записей. Таким образом, речь пойдет об оценке кардинальности одного или нескольких столбцов. Эта задача, кстати, является достаточно нетривиальной. Но если Вы можете ее решить, появляется возможность для эффективных оптимизаций SQL. О них мы и поговорим сегодня.</p><p><a href="https://habr.com/ru/companies/visiology/articles/895850/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">habr.com/ru/companies/visiolog</span><span class="invisible">y/articles/895850/</span></a></p><p><a href="https://zhub.link/tags/DAX" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DAX</span></a> <a href="https://zhub.link/tags/ClickHouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ClickHouse</span></a> <a href="https://zhub.link/tags/%D0%BA%D0%BE%D0%BC%D0%B1%D0%B8%D0%BD%D0%B0%D1%82%D0%BE%D1%80%D1%8B" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>комбинаторы</span></a> <a href="https://zhub.link/tags/GROUP_BY" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GROUP_BY</span></a> <a href="https://zhub.link/tags/%D0%BA%D0%B0%D1%80%D0%B4%D0%B8%D0%BD%D0%B0%D0%BB%D1%8C%D0%BD%D0%BE%D1%81%D1%82%D1%8C" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>кардинальность</span></a> <a href="https://zhub.link/tags/%D0%BE%D0%BF%D1%82%D0%B8%D0%BC%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F_DAX" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>оптимизация_DAX</span></a> <a href="https://zhub.link/tags/%D0%BE%D0%BF%D1%82%D0%B8%D0%BC%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F_SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>оптимизация_SQL</span></a></p>
FOSSASIA<p>Join Alkin Tezuysal's session "Unified Observability: Leveraging ClickHouse as a Comprehensive Telemetry Database" at <a href="https://floss.social/tags/FOSSASIASummit2025" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>FOSSASIASummit2025</span></a> to learn how <a href="https://floss.social/tags/ClickHouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ClickHouse</span></a> simplifies observability, giving engineers deep system insights while minimizing infrastructure complexity.</p><p>🔗 Click here <a href="https://youtu.be/sCRXGqOPtOU?si=lWcjSCpKkuD_gLHW" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">youtu.be/sCRXGqOPtOU?si=lWcjSC</span><span class="invisible">pKkuD_gLHW</span></a> to watch on the FOSSASIA YouTube channel.</p><p><a href="https://floss.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenSource</span></a> <a href="https://floss.social/tags/FOSSASIA" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>FOSSASIA</span></a> <a href="https://floss.social/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a></p>
Scott Laird<p>Here's how to turn web access logs in <a href="https://hachyderm.io/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a> into nicely formatted maps in <a href="https://hachyderm.io/tags/grafana" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>grafana</span></a>, like the picture that I posted yesterday.</p><p><a href="https://scottstuff.net/posts/2025/03/21/geocoding-ip-addresses-with-clickhouse/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">scottstuff.net/posts/2025/03/2</span><span class="invisible">1/geocoding-ip-addresses-with-clickhouse/</span></a></p><p>The hard part with this was getting IPv4 and IPv6 handling without needing special cases for either. Now that that's done, it should just be cut-and-paste to use it yourself now.</p>
Julio Jimenez<p>I don’t usually share AI stuff, but this is way cool.</p><p><a href="https://www.linkedin.com/pulse/bi-dead-change-my-mind-dmitry-pavlov-2otae/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">linkedin.com/pulse/bi-dead-cha</span><span class="invisible">nge-my-mind-dmitry-pavlov-2otae/</span></a></p><p><a href="https://fosstodon.org/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a> <a href="https://fosstodon.org/tags/librechat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>librechat</span></a> <a href="https://fosstodon.org/tags/mcpserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mcpserver</span></a> <a href="https://fosstodon.org/tags/apache_superset" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>apache_superset</span></a> <a href="https://fosstodon.org/tags/Anthropic" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Anthropic</span></a></p>
N-gated Hacker News<p>🧐 So, aspiring <a href="https://mastodon.social/tags/data" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>data</span></a> wizards, you're thrilled about <a href="https://mastodon.social/tags/AGX" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>AGX</span></a>, the shiny new toy for <a href="https://mastodon.social/tags/ClickHouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ClickHouse</span></a> <a href="https://mastodon.social/tags/data" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>data</span></a> <a href="https://mastodon.social/tags/exploration" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>exploration</span></a>. But let's be real, it's just another <a href="https://mastodon.social/tags/GitHub" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GitHub</span></a> repo pretending to be the messiah of data <a href="https://mastodon.social/tags/querying" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>querying</span></a>. 🚀 Meanwhile, the rest of us are still trying to figure out why "collaborate outside of code" sounds like a bad <a href="https://mastodon.social/tags/corporate" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>corporate</span></a> team-building exercise. 🤦‍♂️<br><a href="https://github.com/agnosticeng/agx" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/agnosticeng/agx</span><span class="invisible"></span></a> <a href="https://mastodon.social/tags/collaboration" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>collaboration</span></a> <a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/ngated" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ngated</span></a></p>
Hacker News<p>AGX – Open-Source Data Exploration for ClickHouse (The New Standard?)</p><p><a href="https://github.com/agnosticeng/agx" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/agnosticeng/agx</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/AGX" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>AGX</span></a> <a href="https://mastodon.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenSource</span></a> <a href="https://mastodon.social/tags/DataExploration" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataExploration</span></a> <a href="https://mastodon.social/tags/ClickHouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ClickHouse</span></a> <a href="https://mastodon.social/tags/TechNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TechNews</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataAnalysis</span></a></p>
Habr<p>Telescope — web-based log viewer UI</p><p>Всем привет Хочу поделиться с сообществом своим проектом. Telescope - это opensource web-приложение для удобной работы с логами, хранящимися в ClickHouse.</p><p><a href="https://habr.com/ru/articles/890762/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">habr.com/ru/articles/890762/</span><span class="invisible"></span></a></p><p><a href="https://zhub.link/tags/vuejs" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>vuejs</span></a> <a href="https://zhub.link/tags/django" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>django</span></a> <a href="https://zhub.link/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a> <a href="https://zhub.link/tags/logs" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>logs</span></a> <a href="https://zhub.link/tags/logviewer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>logviewer</span></a> <a href="https://zhub.link/tags/telescope" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>telescope</span></a> <a href="https://zhub.link/tags/web" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>web</span></a></p>
Josh Lee<p>More fun! <a href="https://hachyderm.io/tags/ClickHouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ClickHouse</span></a>, <a href="https://hachyderm.io/tags/Kubernetes" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Kubernetes</span></a>, and <a href="https://hachyderm.io/tags/RaspberryPi" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RaspberryPi</span></a> clusters for dev environments and testing: <a href="https://dub.sh/VN21JTp" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">dub.sh/VN21JTp</span><span class="invisible"></span></a> (blog post and recorded livestream).</p><p>I wanted to use <a href="https://hachyderm.io/tags/nixos" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>nixos</span></a> or <a href="https://hachyderm.io/tags/talos" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>talos</span></a> for a declarative OS-layer but Pi5 support is not strong yet. Raspbian with the Raspberry Pi Imager wasn't too bad though.</p>
Habr<p>ClickHouse в мире IoT</p><p>В этой статье мы рассмотрим использование ClickHouse для хранения данных, поступающих по протоколу MQTT. Данный протокол был специально разработан для приложений IoT и предназначен для обеспечения эффективной и надежной связи между устройствами. В MQTT используется облегченная модель публикации‑подписки, обеспечивающая бесперебойную передачу данных даже в условиях ограниченных ресурсов. Низкие накладные расходы и поддержка потоковой передачи данных в реальном времени делают протокол MQTT идеальным выбором для сбора и передачи данных IoT с различных конечных устройств на платформы обработки данных.</p><p><a href="https://habr.com/ru/companies/otus/articles/888252/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">habr.com/ru/companies/otus/art</span><span class="invisible">icles/888252/</span></a></p><p><a href="https://zhub.link/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a> <a href="https://zhub.link/tags/mqtt" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mqtt</span></a> <a href="https://zhub.link/tags/emqx" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>emqx</span></a> <a href="https://zhub.link/tags/grafana" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>grafana</span></a> <a href="https://zhub.link/tags/%D1%81%D1%83%D0%B1%D0%B4" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>субд</span></a></p>
LavX News<p>Unraveling the Mystery of CPU Spikes in ClickHouse Cloud: A Deep Dive into Linux Kernel Debugging</p><p>A perplexing CPU spike in ClickHouse Cloud led to an extensive investigation, revealing a hidden bug in the Linux kernel's memory management. This article chronicles the journey through kernel interna...</p><p><a href="https://news.lavx.hu/article/unraveling-the-mystery-of-cpu-spikes-in-clickhouse-cloud-a-deep-dive-into-linux-kernel-debugging" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">news.lavx.hu/article/unravelin</span><span class="invisible">g-the-mystery-of-cpu-spikes-in-clickhouse-cloud-a-deep-dive-into-linux-kernel-debugging</span></a></p><p><a href="https://mastodon.cloud/tags/news" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>news</span></a> <a href="https://mastodon.cloud/tags/tech" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tech</span></a> <a href="https://mastodon.cloud/tags/LinuxKernel" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>LinuxKernel</span></a> <a href="https://mastodon.cloud/tags/eBPF" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>eBPF</span></a> <a href="https://mastodon.cloud/tags/ClickHouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ClickHouse</span></a></p>
kfekete<p>In the last couple of weeks (on and off between other things) I was looking into a <a href="https://hachyderm.io/tags/ClickHouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ClickHouse</span></a> based implementation of <a href="https://hachyderm.io/tags/Prometheus" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Prometheus</span></a>' rate() functionality on <a href="https://hachyderm.io/tags/OpenTelemetry" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenTelemetry</span></a> metrics.</p><p>There are a couple of vendors aiming to provide this feature, but most of them either do it by counting traces/spans, or using inflexible schemas and/or not handling edge-cases properly.</p><p>Stay tuned!</p>
🆃🅸🅼 🏴‍☠️<p><span class="h-card" translate="no"><a href="https://hachyderm.io/@laird" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>laird</span></a></span> Nice post. I’d suggest you take a look at the fairly new JSON data type in <a href="https://hachyderm.io/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a> . Muuuuch nicer than maps and tuples.</p>
Scott Laird<p>New blog post: how to pull web logs from <a href="https://hachyderm.io/tags/Caddy" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Caddy</span></a> into <a href="https://hachyderm.io/tags/Clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Clickhouse</span></a> using <a href="https://hachyderm.io/tags/Vector" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Vector</span></a>.</p><p><a href="https://scottstuff.net/posts/2025/02/27/caddy-logs-in-clickhouse-via-vector/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">scottstuff.net/posts/2025/02/2</span><span class="invisible">7/caddy-logs-in-clickhouse-via-vector/</span></a></p><p>Clickhouse is an open-source (plus paid, as usual) columnar DB. This lets you do ad hoc SQL queries to answer questions as well as create Grafana dashboards to show trends, etc.</p>
Habr<p>Базы данных в Kubernetes из коробки: реально ли развернуть кластер в пару кликов? [ВИДЕО]</p><p>Заглянем под капот Kubernetes-кластера и запустим инсталляции баз данных PostgreSQL и Clickhouse. Видео</p><p><a href="https://habr.com/ru/companies/dbraincloud/articles/886304/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">habr.com/ru/companies/dbraincl</span><span class="invisible">oud/articles/886304/</span></a></p><p><a href="https://zhub.link/tags/kubernetes" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>kubernetes</span></a> <a href="https://zhub.link/tags/dbrain" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbrain</span></a> <a href="https://zhub.link/tags/%D0%BA%D0%BE%D0%BD%D1%82%D0%B5%D0%B9%D0%BD%D0%B5%D1%80%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>контейнеризация</span></a> <a href="https://zhub.link/tags/%D0%B1%D0%B0%D0%B7%D1%8B_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>базы_данных</span></a> <a href="https://zhub.link/tags/%D0%BB%D0%BE%D0%B3%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>логирование</span></a> <a href="https://zhub.link/tags/s3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>s3</span></a> <a href="https://zhub.link/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgresql</span></a> <a href="https://zhub.link/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>clickhouse</span></a> <a href="https://zhub.link/tags/devops" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>devops</span></a> <a href="https://zhub.link/tags/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>видео</span></a></p>