MySQL Performance Audits

We are excited to announce that we are now providing highly competitive MySQL performance audits which include a complete overview of your current MySQL setup.

The MySQL performance audit includes our recommendations to help you maximise the performance of your existing investment and to build additional capacity for future growth.

The following describes the headings of a typical MySQL performance audit report:

  • Server hardware health check
  • Operating system review
  • Application and system architecture
  • Table and query design
  • Indexing performance and coverage
  • Current capacity vs. future demands
  • Identification of current bottlenecks and any emergency remedial work required
  • Our recommendations and summary

Our workflow process involves accessing your system onsite or remotely, gathering the necessary data and then constructing a report. We are also happy to quote for our expert engineers to perform any or all of the required changes we identify.

We can perform two types of audit; non-invasive and standard. Non-invasive requires that we do not install any audit tools and collect no identifiable information (such as table names) or slow query logs. A standard audit will involve running basic python scripts to automate the collection of certain configuration data.

A non-invasive audit will require a certain amount of additional time to gather the necessary data manually. The amount of extra time is dependent on the number of servers and data collection required. We may be limited in what we can do regarding optimising of table and index design; this depends on the level of access we are permitted which can be discussed prior to work beginning.

It is important to note that both audit types do not take copies of actual table data. We only collect global configuration data, MySQL configuration data and anonymous counters (such as number of unauthorised access attempts and slow query log %).

We can also provide other services such as scale-out and scale-up consultancy, Master-Master replication and Cluster configuration, benchmarking and capacity checks and architectural design guidance.

Being AWS approved consultants we have experience with Amazon RDS, both in standard mode and coupled with Auto Scale, so if you are considering Cloud managed services as an option for your next MySQL deployment, please get in touch to see how we can help you.

For more information about our MySQL Performance Audit services please email us (sales@buckhill.co.uk) or call us on +44 (0)1903 238012

Tags:

MySQL AWS Cloud

Published by: Stuart Buckell

Published on: 28.11.2016

"We engaged Buckhill to support the development of our new hybrid mobile app. Buckhill's experience, expertise and adaptable approach enabled us to accelerate our learning and jointly deliver a great app that is now being used by our customers. If you're looking for a development partner then Buckhill are a great choice"

Mark O'Neill - Agile Development Manager
Virgin Holidays

"Buckhill are an outstanding service supplier. They have considerable knowledge and experience which has enabled them to successfully undertake a number of complicated migrations and platform designs for us. They do what they say they're going to do when they say they’re going to do it and challenges are never problems. These qualities are rare."

Daniel Cuthbert, Information Services Manager
The Scouts Association

"The technical expertise within the team at Buckhill is far above any other company that we have dealt with, this means that we can always rely on Buckhill to provide the very best solution for any issues we have. We now treat Buckhill as part of the in-house team."

Farhan Hussain, Head of Digital Marketing
NRS Healthcare

"We are delighted with our choice of service provider, and have nothing but good things to say about Buckhill. They acted with a high level of professionalism and competence in all respects. We cannot recommend them highly enough."

Matthew Dickinson, Director
Vable, UK

"Buckhill was able to bring a solution in a complex interoperability problem. I was often impressed by the level of their expertise and deep knowledge. When problems arose they were able to find creative solutions with an emphasis on reliability and security. I can say that during the whole project Buckhill was never the bottleneck, our success with this project is definitely due to Buckhill's talented team."

David Wulliamoz, Head of IT Services
Compassion Suisse, Switzerland

VMware Partner

Contact Information

Speak to an expert on +44(0)1903 250250, email us at contact@buckhill.co.uk, or start a live chat, located in the bottom right

Alternatively, complete the form below

We're happy to talk

Our offices are open 8.30am - 7pm GMT, Monday to Friday - but you can always contact us via email. When we receive your email during opening hours, we aim to respond within 30 minutes or less. Should your email reach us out of hours, we will contact you when the office re-opens.

You can contact us using live chat