{"id":105484,"date":"2025-02-06T15:17:55","date_gmt":"2025-02-06T15:17:55","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?post_type=collection&p=105484"},"modified":"2026-03-18T11:37:16","modified_gmt":"2026-03-18T11:37:16","slug":"chisom-kanus-series-mysql-shell-and-basic-configuration-management","status":"publish","type":"collection","link":"https:\/\/www.red-gate.com\/simple-talk\/collections\/chisom-kanus-series-mysql-shell-and-basic-configuration-management\/","title":{"rendered":"Basic configuration management in MySQL Shell: the complete series"},"content":{"rendered":"\n

In this series, Chisom Kanu shares techniques and queries, centered around code written in SQL and presented in various ways using MySQL Shell scripts.<\/p>\n\n\n\n

\n
\n
\n
\n
\n \n\t\"An\t<\/a> <\/div>\n
\n \n
\n \n \n \"Chisom\n Chisom Kanu<\/span>\n <\/a>\n\n \n in<\/span>\n \n MySQL <\/a>\n <\/span>\n<\/div>\n\n
\n

\n MySQL Shell Basic Configuration Management (Part 6 – Backups and Recovery Procedures) <\/h1>\n

\n Learn how to automate MySQL performance tuning using MySQL Shell. Discover intelligent backup and recovery strategies, configuration tracking, and optimization… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Chisom\n Chisom Kanu<\/span>\n <\/a>\n\n \n in<\/span>\n \n MySQL <\/a>\n <\/span>\n<\/div>\n\n
\n

\n MySQL Shell Basic Configuration Management (Part 5a – Optimizing MySQL Performance) <\/h1>\n

\n Learn how to optimize MySQL performance using MySQL Shell. This guide covers network tuning, query optimization, and configuration best practices… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Chisom\n Chisom Kanu<\/span>\n <\/a>\n\n \n in<\/span>\n \n MySQL <\/a>\n <\/span>\n<\/div>\n\n
\n

\n MySQL Shell Basic Configuration Management (Part 4 – Optimizing MySQL Performance) <\/h1>\n

\n Welcome back to our journey of understanding MySQL performance tuning using MySQL Shell. So far, we\u2019ve covered essential topics like… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Chisom\n Chisom Kanu<\/span>\n <\/a>\n\n \n in<\/span>\n \n MySQL <\/a>\n <\/span>\n<\/div>\n\n
\n

\n MySQL Shell Basic Configuration Management (Part 3 \u2013 Disk I\/O and Storage Optimization) <\/h1>\n

\n So far, in our previous articles on MySQL optimization, we’ve looked at basic configuration management and memory and CPU tuning… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Chisom\n Chisom Kanu<\/span>\n <\/a>\n\n \n in<\/span>\n \n MySQL <\/a>\n <\/span>\n<\/div>\n\n
\n

\n MySQL Shell Basic Configuration Management (Part 2 – Memory and CPU) <\/h1>\n

\n In the first part of the series article, we introduced MySQL Shell as a tool for managing and optimizing MySQL… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Chisom\n Chisom Kanu<\/span>\n <\/a>\n\n \n in<\/span>\n \n MySQL <\/a>\n <\/span>\n<\/div>\n\n
\n

\n MySQL Shell Basic Configuration Management (Part 1 – Introduction) <\/h1>\n

\n \u200b\u200bThe database is an important part of any application and setting it up correctly is key to ensuring smooth performance…. <\/p>\n <\/div>\n

\n