2 Simple Ways to Improve MySQL Performance

By Sean
16th January 2018

There’s no way of knowing how many businesses use MySQL databases. But we can say with some confidence that it’s one of the most popular database technologies in the world. MySQL is free, easy to use, and has a massive community behind it. It’s also now owned by Oracle, which means its longevity is almost certainly assured.

Keeping your database online is key to keeping your business ticking over. WellData offers outsourced database support and management for businesses across the UK, and a proactive, professional team is certainly the best method of protection for your data. But if your MySQL database is running slowly, there are two easy things you can do to speed it up, and they take just a few seconds to action.

Many administration tasks are carried out using command line tools. If you’re not familiar with the command line, you may prefer to use a web-based GUI tool like phpMyAdmin or phpMiniAdmin.

 

How to Repair and Optimise MySQL

MySQL has its own built-in tools to repair and optimise a database. phpMyAdmin provides easy access to both.

The repair operation will correct any corrupted data, which is commonly created if the database has crashed at some point. The optimise command compresses the table, so that the database engine spends less time retrieving data. This can speed up the application that the database is linked to.

In phpMyAdmin, tick the tables you want to work on, and select Repair table or Optimise table from the With selected drop-down list. This operation can take a while on a large database, so it’s important to wait for the confirmation screen to appear.

 

Other Performance Issues

All databases are complex, and achieving peak performance takes time. You can only achieve optimum efficiency if your database is set up correctly. At WellData, we can fine-tune the way your MySQL works, adjusting basic settings like log file sizes, cache file capacity and the number of connections your database is accepting. We can also ensure your indexes are set up and working correctly.

As part of ongoing database maintenance, you could instruct MySQL to repair its own tables automatically. However, we don’t recommend using this as a sticking plaster for performance problems. If you’re experiencing ongoing issues and bottlenecks with any kind of database, it’s best to speak with our expert database administrators about the root cause.

 

Affordable Database Support

WellData provides database support for businesses all over the UK, as part of our suite of managed IT services. Our team is geographically dispersed, allowing us to respond quickly to many incidents. We carry out most of our management and maintenance tasks remotely, and assist with the full management lifecycle, from implementation through to management, and even disaster recovery planning.

 

If your business is struggling with database problems, or lacking a reliable database administrator, speak to WellData about our MySQL database support services today.

Your organisation could benefit from our range of IT services, provided in a low cost monthly fixed fee. 

 

Get in touch

 

Found our blog interesting? Share with friends and colleagues….

Share

<< Back to resources

Join Our Newsletter

Contact Email  *
First Name 
Last Name 
*Required Fields
I agree to the  Privacy Policy and  Terms of Use 

Here's what other people think

Google Rating
5.0
WellData provide an excellent level of support and their team are very knowledgeable and always go the extra mile. I would wholeheartedly recommend them.read more
Stefan Parrott
Stefan Parrott
13:12 19 Sep 17
Having worked with the team at Welldata for approaching 17 years, my company and I have always found them professional, reliable and generally a great firm to work with.read more
John Lynes
John Lynes
14:00 04 Oct 17
Our partnership with WellData has enabled us to resolve critical database problems. Their attitude and service makes them a natural extension to our own technology team, which extends our capability in a critical area of our business.read more
Steve Fenton
Steve Fenton
10:56 05 Nov 18
Really know their stuff and their response times are very good.
Andy Cole
Andy Cole
11:45 06 Nov 18
We use Welldata for SQL support and are very happy with their service.
David Sadler
David Sadler
09:40 15 Nov 18
A very dedicated team of extremely professional and knowledgeable experts
Giulia Iannucci
Giulia Iannucci
14:08 16 Nov 18
I have worked with the WellData team for many years now and they have always delivered. I would highly recommend them to any business looking for best-value outsourced Expert DBA’s. Being able to offer a rolling contract on the basis that if they don’t deliver you can leave shows their confidence and commitment. Their professionalism and knowledge is second to none.read more
Petro Bartoszyk
Petro Bartoszyk
08:51 18 Oct 19