# database administration

Published articles for database administration.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Evaluating LLM models for DBA tasks

DevFeed: [Evaluating LLM models for DBA tasks](<https://devfeed.tech/articles/evaluating-llm-models-for-dba-tasks-41417.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/evaluating-llm-models-for-dba-tasks/>)

Author: Vadim Tkachenko

Published: 2026-09-17T11:50:07Z

Content type: article

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [LLM evaluation / benchmarking](<https://devfeed.tech/topics/llm-evaluation-benchmarking.md>), [Database](<https://devfeed.tech/topics/database.md>), [Large Language Model](<https://devfeed.tech/topics/llm.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Replication](<https://devfeed.tech/topics/replication.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [guardrails](<https://devfeed.tech/tags/guardrails.md>), [harness](<https://devfeed.tech/tags/harness.md>), [llm](<https://devfeed.tech/tags/llm.md>), [models](<https://devfeed.tech/tags/models.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [openrouter](<https://devfeed.tech/tags/openrouter.md>), [replication](<https://devfeed.tech/tags/replication.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

This article describes a harness for evaluating open-weight and other LLMs on real database administration tasks performed on remote systems. It reports that most models completed the tasks, while smaller models often achieved similar results at lower cost but required more steps. The article also shows that models may adapt when the requested software version is unavailable, highlighting the need for validation and guardrails.

### Source excerpt

Evaluating LLM Models for DBA Tasks Large language models are increasingly capable of performing practical systems-administration tasks. I wanted to understand how well they could handle something more specialized: database administration. To explore this, I developed a harness for evaluating the ability of different LLMs to execute real DBA tasks on remote systems. My ... Continued The post Evaluating LLM models for DBA tasks appeared first on Percona.

## Too many GCache Page Files in MySQL Data Directory

DevFeed: [Too many GCache Page Files in MySQL Data Directory](<https://devfeed.tech/articles/too-many-gcache-page-files-in-mysql-data-directory-35043.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/too-many-gcache-page-files-in-mysql-data-directory/>)

Author: Kedar Vaijanapurkar

Published: 2026-09-17T05:29:14Z

Content type: tutorial

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [XtraDB Cluster (PXC)](<https://devfeed.tech/topics/xtradb-cluster-pxc.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [cluster](<https://devfeed.tech/tags/cluster.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [disk-space](<https://devfeed.tech/tags/disk-space.md>), [galera](<https://devfeed.tech/tags/galera.md>), [galera-replication](<https://devfeed.tech/tags/galera-replication.md>), [gcache](<https://devfeed.tech/tags/gcache.md>), [gcache-freeze-purge-at-seqno](<https://devfeed.tech/tags/gcache-freeze-purge-at-seqno.md>), [gcache-keep-pages-count](<https://devfeed.tech/tags/gcache-keep-pages-count.md>), [gcache-page](<https://devfeed.tech/tags/gcache-page.md>), [gcache-page-files](<https://devfeed.tech/tags/gcache-page-files.md>), [gcache-purge](<https://devfeed.tech/tags/gcache-purge.md>), [gcache-troubleshooting](<https://devfeed.tech/tags/gcache-troubleshooting.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-disk-space](<https://devfeed.tech/tags/mysql-disk-space.md>), [mysql-troubleshooting](<https://devfeed.tech/tags/mysql-troubleshooting.md>), [percona-xtradb-cluster](<https://devfeed.tech/tags/percona-xtradb-cluster.md>), [pxc](<https://devfeed.tech/tags/pxc.md>), [replication](<https://devfeed.tech/tags/replication.md>), [xtradb-cluster-pxc](<https://devfeed.tech/tags/xtradb-cluster-pxc.md>)

### AI overview

An investigation into thousands of GCache page files accumulating in a Percona XtraDB Cluster data directory. The article explains how frozen GCache purging caused disk growth, links the behavior to a cluster partition, and describes reproducing it by setting gcache.freeze_purge_at_seqno and generating workload.

### Source excerpt

Learn why PXC accumulates thousands of gcache.page.* files, how frozen GCache purging causes disk growth, and how to safely recover and rejoin using IST. The post Too many GCache Page Files in MySQL Data Directory appeared first on Percona.