In this month’s article over at Database Journal we discuss more areas to tune your initial MySQL database setup including InnoDB & MyISAM buffers, hit ratios, index usage and full table scans, security, and logs. With this second article in a two part series we complete our coverage of basic tuning of a MySQL database.
Archive for category databasejournal
DBJ: Five More Dials To Turn
Jul 10
DBJ – Ten Dials To Set
Jun 12
This month in Database Journal we start a two part article on tuning the dials of your new MySQL database. After you install and setup your first database, you’ll need to set various parameters in your my.cnf file. These control memory, logfiles, temp table usage, sorting, joins, and a whole lot more. We’ll review some of the more important wants and start you on your way to more nuanced tuning of your MySQL instance.
Read the article: Ten Dials To Set at DatabaseJournal.com
If you haven’t worked with MySQL’s NDB Cluster storage engine yet, now is the time to take a peek. There is a sandbox available from serveral nines, which can be installed fairly quickly. This new article over at DatabaseJournal, MySQL Clustering In A Sandbox will have you up and running in no time.
A new article is up on Database Journal where I discuss some query optimizations that work well with MySQL applications.Five Query Optimizations in MySQL
The MySQL Query Cache is a powerful piece of engineering that users of the popular open source database can take advantage of to speed up throughput of their applications. MySQL’s cache operates a little bit differently from other database engines. It does not just cache query plans, but the query data as well. What this means is that the size and number of queries that your database manages will be variables when tuning the query cache. We discuss all of these items in our new article at DatabaseJournal.
Database Journal – Optimizing the MySQL Query Cache
Our latest article over at Database Journal is hot off the presses. Advanced MySQL Replication – Improving Performance discusses some of the best ways to improve the performance of your MySQL slave setup. If the slave is constantly getting further and further behind the master database, we discuss a number of techniques which may help you bring it under control.
Part II in our series on MySQL picks up where we left off from talking about some of the challenges, and potential issues and problems that come up with MySQL replication after you have it setup and running for some time. DBJ: Fixing MySQL Replication
In this piece we talk about some of the ways to verify your setup, and make sure your slave does not drift out of sync with the master, and to alert you if it does.
DBJ: Replication Pitfalls
Nov 13
In this month’s Database Journal article we write about Replication Pitfalls with MySQL.
Replication is fairly straightforward to setup, however your slave databases can get out of sync, or throw errors. We investigate some of the reasons why, and help you identify those before they come back to bite you!
If you’re interested in getting started with Oracle’s AWR facility, roughly the new statspack that’s built in, and easier to use, take a look at this new article over at Database Journal.
DBJ: Intro to PHP + Oracle
Sep 15
If you’re already building LAMP applications (linux/apache/mysql/php), and you’re looking to port them to Oracle, or you’re new to this technology stack, and you want to use Oracle as your database, this article is for you. We cover the basics of gettings started, and where to look for more information.