SShortSingh.
TopTechnologyAI & MLStartupsProgrammingScienceBusinessFinanceCrypto & Web3World
Back to feed
Programming

ClickHouse System Tables Offer Built-In Tools for Query and Server Troubleshooting

0
·1 views

ClickHouse includes a built-in system database containing read-only tables that expose the server's internal state in real time. These tables cover a wide range of operational data, including running queries, storage parts, replication status, background merges, mutations, disk usage, and server errors. Administrators can query them using standard SQL without needing external monitoring software. Key tables such as system.query_log, system.processes, and system.merges help diagnose slow queries, track long-running operations, and monitor MergeTree maintenance. The system tables are automatically maintained by ClickHouse, making them a practical first stop for performance analysis and troubleshooting.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

AI Speeds Up Dev Work, But Leaves Some Engineers Questioning Ownership of Their Code

A software developer reflects on how AI-assisted coding has transformed their workflow, enabling them to ship complex billing systems in under a week that would previously have taken much longer. The author contrasts this with an early career memory of spending four days debugging a bank financing pipeline alone, describing the intense personal satisfaction that came from solving the problem independently. While acknowledging that AI catches edge cases and accelerates delivery, the developer feels a growing disconnect from the work being produced. The concern is not about competence or output quality, but about the loss of the hard-won, hands-on learning that once made shipped code feel personally meaningful. The piece raises broader questions about authorship and identity in software engineering as AI tools take on more of the problem-solving role.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

StatsBomb Data Analysis of 1,085 Matches Finds Late Soccer Goals Follow Predictable Patterns

A data analyst examined 1,085 professional soccer matches from 2017 to 2022 using StatsBomb's publicly available open data, focusing on goals scored in the final 15 minutes of regulation. The study found that late-game scoring correlates at 79.3% with specific pre-match and in-match conditions, suggesting these goals are far from random. A key finding was the 'Desperation Window' between the 70th and 80th minutes, during which teams trailing by one goal sharply increased attacking intensity. In 312 such matches, 68.6% showed an immediate shift to attacking play, and teams generating shots in that window were more likely to either equalise or concede a second goal late on. The analysis concludes that factors like fatigue, tactical desperation, and defensive adjustments create measurable, repeatable frameworks around late-match scoring.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

Analyst Claims UFC Betting Market Has Systematic Mispricings After 500-Fight Study

A data analyst spent six months building a dataset of 500 UFC fights from January 2022 to June 2023, cross-referencing striking accuracy, takedown defense, fight duration patterns, and historical betting odds against actual outcomes. The study claims UFC sportsbooks systematically misprice certain underdog profiles, pricing fighters based on public perception and recent results rather than granular statistical analysis. The analyst cites Sean Strickland's +340 underdog victory over Dricus du Plessis at UFC 287 as a case study in market inefficiency. According to the findings, specific underdog profiles generate consistent positive ROI that would be unlikely if odds accurately reflected true win probabilities. The research draws on publicly available data from UFCStats.com alongside opening and closing lines from at least two major sportsbooks per fight.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

Key principles engineers must follow when developing software with AI tools

A guide published on DEV Community outlines essential practices for software engineers integrating AI into professional development workflows. The article stresses that AI is a productivity tool, not a replacement for engineering judgment, architecture knowledge, or decision-making. It recommends using top-tier models such as Claude Opus and GPT with high-effort reasoning, paired with dedicated local agents like Claude Code or Codex for better output quality. Engineers are advised to always analyze and plan before implementation, maintain a structured project context file, and validate all AI-generated code through builds, tests, and static analysis. Ultimately, the article emphasizes that accountability for every line of code reaching production rests solely with the engineer, not the AI.

0 comments Read more at DEV Community
ClickHouse System Tables Offer Built-In Tools for Query and Server Troubleshooting · ShortSingh