In several recent posts: It’s LEMP not LAMP! and Amazon EC2 Shoutout! I've discussed how I switched from a shared hosting account with GoDaddy to a dedicated Micro instance with Amazon. At the same time I decided to go out and try nginx (pronounced Engine-X) and remove Apache from the equation.
This saw some incredible results. However, several times since switching I've run into several database issues where it appears Mysql runs out of memory! Performing a top command shows over 15 mysql processes running at anyone giving time each taking up to 10% of the memory. On a micro instance I only get 600mb, so this adds up quickly!
I've been told now by several people about Percona. This is a company that has dedicated themselves to making Mysql more performant over the past 6 years. It's quite a beautiful thing, it actually installs and runs Mysql; however, it's performed all of those necessary tweaks for you without requiring you to be a DBA (database administrator).
So I suppose at the end of the day it really still is LEMP or LAMP, but I'm going to go out on a limb and start giving Percona some credit – perhaps it should be LEMPP or LAMPP?
After installing Percona, I was able to free up over 100mb of memory; a very much needed 100mb as I was running with less than 40mb available.
Thanks Percona!
Fyi if you wish to install this, on my Ubuntu box I ran into a couple of quick snags because I already had mysql server and mysql client installed. I simply had to remove this with apt-get remove and I was then able to install Percona as instructed.
The beauty part was because it leverages mysql I didn't have to do a single thing! All of my databases were still there and running. Published on Sep 14, 2012 Tags: SQL Tutorials for Beginners, Intermediate and Advanced Users
| Optimization
| lemp
| lamp
| nginx
| Theory
| lepp
| percona
Did you enjoy this article? If you did here are some more articles that I thought you will enjoy as they are very similar to the article
that you just finished reading.
Jamie Munro is the author of ASP.NET MVC 5 with Bootstrap and Knockout.js,
Knockout.js: Building Dynamic Client-Side Web Applications,
20 Recipes for Programming MVC 3,
and 20 Recipes for Programming PhoneGap. He has been developing websites and web applications for over 20 years. Jamie began his writing career in 2009. As the success of Jamie's blog grew, he turned his writing passion to books about web development in hopes that his many years of experience could be passed on to his readers. No matter the programming language you're looking to learn, I've hopefully compiled an incredible set of tutorials for you to learn; whether you are beginner
or an expert, there is something for everyone to learn. Each topic I go in-depth and provide many examples throughout. I can't wait for you to dig in
and improve your skillset with any of the tutorials below.
Related Posts
Tutorials
Learn how to code in HTML, CSS, JavaScript, Python, Ruby, PHP, Java, C#, SQL, and more.