{"id":117,"date":"2020-02-12T10:36:39","date_gmt":"2020-02-12T10:36:39","guid":{"rendered":"https:\/\/www.lcn.com\/support\/knowledge-base\/how-to-optimise-your-mysql-database\/"},"modified":"2020-09-09T11:09:27","modified_gmt":"2020-09-09T11:09:27","slug":"how-to-optimise-your-mysql-database","status":"publish","type":"ht_kb","link":"https:\/\/www.lcn.com\/support\/articles\/how-to-optimise-your-mysql-database\/","title":{"rendered":"How to Optimise your MySQL Database"},"content":{"rendered":"

This guide will explain how to optimise MySQL database tables in phpMyAdmin. For customers using LCN Web hosting<\/a> or WordPress hosting<\/a>.<\/p>\n

Optimising tables reorganises the physical storage of table data, to reduce storage space used on disk and improve I\/O efficiency when accessing data within the table. Sometimes tables that are written to frequently can become poorly optimised which can result in wasted disk space being reserved by the table and can affect website performance by causing slower read\/writes to the database table.<\/p>\n

Let\u2019s get started\u2026<\/p>\n

How to access phpMyAdmin<\/h3>\n

To optimise tables within your MySQL database you\u2019ll need to log in to the phpMyAdmin control panel. Simply type http:\/\/www.domain.com\/mysqladmin\/<\/strong> into your browser’s address bar (replace domain.com<\/i> with your actual domain name). You will be prompted to enter your MySQL database username and password, which you set when you created your database.<\/p>\n

If your site was set up using one of our Web Apps such as Joomla<\/strong> or WordPress<\/strong>, the database login details will have been set automatically by our system. You can find these details within the configuration file for the site via FTP as follows:<\/p>\n