MySQL Performance Tuning Or: How To Optimize And Scale With MySQL / LAMP
Welcome to MySQL Performance Tuning. This site is for people who need to optimize, tune and scale MySQL. Or, more generally speaking, build high performance websites.
We focus on getting more from your existing hardware.
MySQL / LAMP Performance Tuning
Everita provides a comprehensive consulting service focused on optimizing the performance of MySQL and LAMP stacks.
In conjunction to this we can profile your application, alerting you to bottlenecks, and advise you on how to get more from your existing hardware.
Remote MySQL
DBA Services
Everita offers an expert remote and on-site DBA service. We can look after the day-to-day maintenance of your database.
Our services include server configuration, monitoring, backup and restoration, configuring replication and query optimization amongst others.
Articles
Green Computing, Data Centre Efficiency, Virtualization And The Cloud
There's been a lot of talk of late about green computing, how data centres are becoming more efficient, virtualization and particularly the idea that cloud computing is some sort of panacea. Yes, that maybe so. But you rarely hear anyone mention inefficient software being taken to task: it's the elephant in the room.
Serve Static Drupal Content Faster With Boost And Nginx
If your site serves static Drupal content then Boost might be for you. Having got an impressive 167% increase yesterday with XCache we can show you how we got an eye-popping further 1806% increase with Boost. Warning: your results may vary.
How To Speed Up Drupal With XCache
If you serve pages from Drupal or moreover with PHP you could increase your PHP throughput by a staggering 167% for five minutes of effort. If you haven't already find out how with XCache.
How To Reduce table_locks_waited In MySQL/MyISAM
The scourge of parallelism and scaling everywhere: locking. Or in MySQL/MyISAM — and to be more precise — table locks. Here's an overview of what to look out for and how one might go about reducing the frequency at which they occur.
How To Speed Up MySQL: An Introduction To Optimizing
Although there is nothing groundbreaking in this document consider it a bringing together of techniques for your first foray into optimization. We won't discuss the more esoteric methods of squeezing the very last millisecond out of MySQL. There are a myriad of parameters to tune: here's what you need to get right first.