Blog

News, tutorials and release notes for Canvasly Web Studio, Sidcraft and VidCellar.

Showing posts tagged “MySQL”. Show all posts

· Canvasly Web Studio · AI

When the MCP Server Says "Done" Too Early: Preventing Duplicate Writes from AI Agents in WordPress

AI agents don't get tired, and they don't hesitate. That's what makes them useful, and it's also what makes them dangerous when a tool gives them the wrong signal. Ask an agent to create a post, give it a stale answer when it checks its work, and it will happily create the post again, as many times as it takes to "fix" a problem that never existed. This article started as a discussion on X about WordPress and the Model Context Protocol (MCP). It turned into a good, practical lesson about building tools that AI agents can safely retry.

Read the post When the MCP Server Says "Done" Too Early: Preventing Duplicate Writes from AI Agents in WordPress →

· Canvasly Web Studio · Performance

Database Performance Tuning 101: How to Identify, Isolate and Fix Slow or Duplicate SQL Queries in Production

Most slow websites aren't slow because the server is too small. They're slow because a handful of database queries do far more work than they need to, or run far more often than they should. This guide walks through a simple, repeatable loop for finding those queries in production, understanding why they're slow, fixing them safely, and proving the fix worked. Examples cover MySQL / MariaDB (which WordPress uses) and PostgreSQL.

Read the post Database Performance Tuning 101: How to Identify, Isolate and Fix Slow or Duplicate SQL Queries in Production →