Tag Archives: mysql server

Mysql Server Optimization Blogshot

facebooktwittergoogle_plusredditpinterestlinkedintumblrmail

Here I am listing some articles that I found very useful in doing the mysql server performance tuning.

Mysql performance running Optimizing the MySQL Server
From: mysql.com
This section discusses optimization techniques for the database server, primarily dealing with system configuration rather than tuning SQL statements. The information in this section is appropriate for DBAs who want to ensure performance and scalability across the servers they manage; for developers constructing installation scripts that include setting up the database; and people running MySQL themselves for development, testing, and so on who want to maximize their own productivity.

How to Optimize a Mysql Server
From: hardwaresecrets.com
Before talking specifically about the MySQL server, we need to discuss three topics often overlooked when setting up a MySQL server: the hardware configuration of the server, the networking setup of the server, and the optimization of the source code of the application that will access the MySQL server.

Optimizing mysql response timeMysql Database Performance tuning and Optimize Mysql Database response time
From: debianhelp.co.uk
Performance tuning and Optimize Mysql Database response time is very important for your website or your application to run efficiently.Now we will see each one separately how todo this.

mysql performance tuning MySQL Performance Tuning Scripts and Know-How
From: askapache.com
Unless you are a MySQL performance tuning expert, or a total linux-freak-guru like myself, and even if you are, it can be enormously challenging and somewhat overwhelming to locate and eliminate MySQL bottlenecks. While many DBAs focus on improving the performance of the queries themselves, this post will focus on the highest-impact items: MySQL Server Performance and OS Performance for MySQL.

This post is a “best-of” compilation of the tricks and scripts I have found to be the most effective over the past decade. I’d like to write a 50 page article but am limiting this to 1 page.

Using MySQLTuner to Optimize MySQL configuration
From: rtcamp.com
Tweaking MySQL is something you need to do regularly. Unlike PHP & Nginx tweaking, this is not a set & forget job!

We will use mysqltuner for tweaking mysql on a regular basis.

MySQLTuner-perl
From: github.com
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.