LibreDB Studio — blog LibreDB Studio is the open-source database IDE that deploys next to your data instead of onto your laptop — one browser tab for PostgreSQL, MySQL, MongoDB, Redis and thirteen more engines, with SSO and audit built in. https://siftrss.com/f/oaRaGD1B15 en With performance_schema off, MySQL metrics are absent not zero https://libredb.org/blog/mysql-performance-schema-off-metrics-absent https://libredb.org/blog/mysql-performance-schema-off-metrics-absent Cache hit ratio, queries per second and buffer-pool usage are omitted rather than defaulted, and two more figures mean less than their names suggest. Fri, 14 Aug 2026 09:00:00 GMT Engineering Databases LibreDB Reading MySQL EXPLAIN FORMAT=JSON as a plan tree https://libredb.org/blog/mysql-explain-format-json-plan-tree https://libredb.org/blog/mysql-explain-format-json-plan-tree What the plan tree answers on MySQL, and where the surrounding introspection runs out: index figures here are estimates of distinct values. Fri, 17 Jul 2026 09:00:00 GMT Engineering Databases LibreDB A MySQL ER diagram is bounded by one database https://libredb.org/blog/mysql-er-diagram-single-database-scope https://libredb.org/blog/mysql-er-diagram-single-database-scope Every introspection query binds to the connected database, so a reference that crosses schemas simply does not appear as an edge on the diagram. Thu, 11 Jun 2026 09:00:00 GMT Engineering Databases LibreDB A MySQL connection URI skips your SSL and timezone settings https://libredb.org/blog/mysql-connection-uri-ssl-ignored https://libredb.org/blog/mysql-connection-uri-ssl-ignored Supplying a connection string takes a different branch entirely, so the SSL panel, the timezone and cloud detection stop applying and must live in the URI. Sat, 25 Apr 2026 09:00:00 GMT Engineering Databases Security LibreDB Connecting to MySQL in a container, and what the pool honours https://libredb.org/blog/mysql-connect-docker-pool-limits https://libredb.org/blog/mysql-connect-docker-pool-limits Port 3306 with the fixture credentials, the container-network case, and the pool settings that are quietly ignored because the driver model differs. Mon, 09 Mar 2026 09:00:00 GMT Engineering Databases LibreDB Stopping a runaway MySQL query is cancellation, not a timeout https://libredb.org/blog/mysql-cancel-runaway-query https://libredb.org/blog/mysql-cancel-runaway-query No server-side statement timeout is wired into the pool, so nothing kills a long query on its own and cancellation is an explicit act with a caveat. Tue, 20 Jan 2026 09:00:00 GMT Engineering Databases LibreDB Agent plan mode on MySQL drafts; it does not execute https://libredb.org/blog/mysql-agent-plan-mode-grounded-drafts https://libredb.org/blog/mysql-agent-plan-mode-grounded-drafts The tool-using run ends engine-unsupported here, so the useful post is what plan mode does instead: read the real schema and hand a statement to a person. Thu, 04 Dec 2025 09:00:00 GMT Engineering Databases Security LibreDB