https://sudonull.com/cpu-80-diagnostics-in-clickhouse
Tools for finding problematic queries in ClickHouse: system.processes, query_log, EXPLAIN. Diagnostics steps, SQL examples, checklist. Optimize load without downtime.
Search Articles — Sudonull
Search Results
In this project
https://sudonull.com/cpu-memory-hierarchy-latencies-and-optimization
Analysis of memory hierarchy from registers to DRAM. Cache misses, 64 B lines, locality, prefetcher, MESI. Optimization for RISC-V and desktops. Learn how to speed up code.
https://sudonull.com/cpu-temperature-monitoring-on-python-xlib
Implement CPU temperature overlay in X11 with python-xlib. Cross-platform script for FreeBSD/Linux. Full code, sysctl/sysfs setup. For middle/senior dev.
https://sudonull.com/cpu-repair-chinese-woman-restored-a-processor-with-a-needle-myth-or-reality
A Chinese engineer single-handedly repaired an Intel Core i9 CPU under a microscope for the first time. Is it true and how does nano-soldering change the electronics economy? Read the analysis.
https://sudonull.com/cpuid-hack-trojan-in-cpu-z-and-hwmonitor
Hackers swapped downloads of popular utilities CPU-Z and HWMonitor on the CPUID website, distributing the STX RAT trojan. Learn the details of the attack, risks, and protection measures for your PC. Check your system now.
From other projects
https://ymaho.com/nvidia-shares-hit-all-time-high-ai-chips-rubin-ultra
Nvidia shares rose 5% to $3.1 trillion after announcement of Rubin Ultra chips and Vera CPU. Analysis of drivers, risks, and forecast. Read more.
https://ymaho.com/intel-and-qualcomm-stocks-growth-on-chips-and-contracts
Analysis of the reasons for the rally of Intel and Qualcomm stocks in May 2026: Apple agreement, AI contracts and a new CPU supercycle. Find out who wins and how to profit from it.
Trending Now
Figure 02: new humanoid robot with AI interface from Figure AI
Figure AI introduced the humanoid robot Figure 02 with physical AI and OpenAI language model. The robot passed tests at BMW factories. Learn how humanoid robots are changing manufacturing.
MongoDB vs PostgreSQL When to Use Each: Key Differences
MongoDB vs PostgreSQL when to use each: compare ACID compliance, scalability, schema flexibility, and query power. Choose the right database for your project.
What Are the Ethical Concerns in Artificial Intelligence?
Learn what are the ethical concerns in artificial intelligence, from bias to job loss. Backed by research, this guide offers a practical framework for evaluation.
How to Deploy LLM in Production: Step-by-Step Guide
Learn how to deploy LLM in production with this step-by-step guide. Covers model selection, Kubernetes deployment, vLLM, testing, and monitoring for reliable AI systems.
GPT-4 vs Claude Comparison: Which AI Model Is Best?
Read our data-driven GPT-4 vs Claude comparison covering accuracy, coding, hallucinations, and cost. Discover which AI model fits your needs in 2026.
OWASP Top 10 Explained: What It Is & Why It Matters
Learn what is the OWASP Top 10 and why does it matter for secure coding. A developer's guide to web app vulnerabilities, risks, and practical defense strategies.
How to Use Docker for Beginners: A Hands-On Guide
Learn how to use docker for beginners with this hands-on guide. Run containers, build images, and master Docker Compose. Start containerizing your apps today.
How to Learn Python for Beginners: Step-by-Step Roadmap
Discover how to learn Python for beginners with this step-by-step roadmap. Master fundamentals, data structures, and build real projects. Start your coding journey today.
Semiconductor Industry History & How It Works
Explore the history of the semiconductor industry and how does it work. Learn chip design, fabrication, and the global impact of this vital technology. Discover more.
What Is Infrastructure as Code? Benefits, Tools & Best Practices
Learn what is infrastructure as code and why use it. Discover key benefits, essential tools, and best practices to automate and secure your cloud infrastructure.