Limiting the Number of Rows in MySQL Result Sets
In the Web 2.0 world where smart phone and Web applications are competing to access terabytes of data, there is a new imperative for speeding up retrieval times as much as the technology permits. Rob Gravelle lists a few coding techniques that we as database administrators and developers can use to whittle down unwieldy results sets into manageable chunks.
Troubleshooting MySQL Slow Queries with Tcpdumps
MySQL has a wonderful facility for capturing slow queries called the slow query log. However if yours is not enabled when trouble occurs, and restarting the database is not an option, you'll need another solution. This is where a tcpdump can come in handy.
Optimizing MySQL Query Retrieval Speed Through Table Joins
A poorly optimized query can become the bottleneck in an otherwise highly optimized process. In many cases, the source of the slow performance is improper table joining in the WHERE clause. With that in mind, this article looks at ways to optimize table joins for speedy data retrieval.
MySQL Point in Time Backups
Point in time backup and recovery is a crucial component of any part of any MySQL environment. This article describes how to implement the basic point in time recovery and describes a few mechanisms to accomplish this goal.
Use Derived Tables in Your MySQL Queries to Improve Database Performance
There has been much debate as to whether derived tables, views, or temporary tables are actually faster in terms of database performance. The fact is that there is no simple answer, as different queries require different optimizations. Rob Gravelle presents and evaluates some uses for derived tables that highlight their value in many applications.
MySQL Hotbackups with XtraBackup
Hotbackups are a staple of many different database platforms, but they remain sadly absent from the core MySQL distribution. Not to worry, the open-source utility has just arrived to rescue you.
Eliminating Duplicate Rows from MySQL Result Sets
The go to solution for removing duplicate rows from your result sets is to include the distinct keyword in your select statement. It tells the query engine to remove duplicates to produce a result set in which every row is unique. The group by clause can also be used to remove duplicates.
Simple Automation - Examining your MySQL Index Usage
In the majority of MySQL systems, the schema is always updated and changed based on the needs and focus of the application, making it somewhat difficult to keep up with all of the changes that come down the pipe. Chris Schneider shows you how to gauge the index usage in a system, using grep, awk and sed.
Clearing a Path through the 3NF Join Jungle
Rob Gravelle explores the pros and cons of normalization with a particular focus on the ramifications of third normal form normalization on data extraction by SELECT query.
SkySQL Takes Aim at Delivering MySQL
Former Oracle and Sun execs start up new venture aimed at filling perceived gaps in the open source database support system - but is it an attack on Oracle?
Inside MySQL Character Sets & Settings
MySQL has sophisticated character set support, and can store, retrieve and collate single byte, and multi-byte character sets alike. Sean Hull explores using non-default character sets and settings, which use the hierarchy to control these settings.
MySQL Server Benchmarking 101
Benchmarking can be a very revealing process. It can be used to isolate performance problems, and drill down to specific bottlenecks. More importantly, it can be used to compare different servers in your environment, so you have an expectation of performance from those servers, before you put them to work servicing your application.
Cardinality in MySQL Data Modeling
In data modeling, explaining how each table links to another is known as cardinality. Knowing how to establish table cardinality is a key skill in database design because it can identify areas where the normalization process may have gone awry. This article looks at each relationship type more closely.
A Look Inside MySQL Enterprise Monitor
MySQL Enterprise Monitor was highlighted during "MySQL Sunday" at the Oracle Open World conference this past month. Given the ease of implementation and helpful GUI tools, MySQL Enterprise Monitor provides almost instant benefits for any MySQL shop.
Using mysqldump to Back Up Your MySQL Database
Whether you host your website and database internally or you use a hosting provider, it is of paramount importance that you institute a rigorous backup policy. If you're using MySQL, several easily implementable options are at your disposal. This article introduces one such option by showing you how to backup your database using MySQL's native mysqldump client.
The 10 Most Common MySQL Queries
MySQL queries are usually written once and then wrapped in class functions to minimize code repetition. This article lists the 10 queries used most often in MySQL.
How Operator Precedence Affects MySQL SELECT Queries
When joining tables on common fields, if you're not diligent in the use of AND-OR combinations in the criteria clause, be prepared for unexpected results! Learn how to break filtering criteria into individual steps and how to group AND-OR statements to most effectively isolate the data that you wish to retrieve.
Disambiguating between Duplicate Column Names in MySQL
To minimize headaches that can accompany long field lists, DBAs employ a range of techniques. The specific techniques covered today are used to disambiguate between duplicate column names. Don’t be too quick to judge this as basic stuff. You just might find that there are a few things you don’t know on this subject.
Inside MySQL Binary Logs
The MySQL Binary Log files are important to the proper functioning of the database and facilitate replication, and recovery. This article discusses some of the inner workings of these important files, and explains how ordering of transactions also plays into how they work.
Top 10 Security Tips for MySQL
Security is a crucial part of any database system and MySQL is no different! There are very specific techniques a database administrator can use to protect their MySQL installation. Read on to learn the TOP 10 security tips for MySQL database administrators.
MySQL SELECT Statement 101
The SELECT statement is without question the most complex amongst MySQL's data manipulation statements. This article covers the syntax of the SELECT statement, exploring its many optional clauses.
MySQL in Amazon EC2 - Beginners Guide
Increasingly, enterprises are looking at cloud services such as Amazon Web Services for their deployments. Datacenter virtualization is much more sophisticated than its desktop counterpart is, providing a whole suite of tools that allow you to control every aspect of your deployments. Join Sean Hull as he explores the MySQL - Amazon EC2 solution.
Working with MySQL Multi-master Replication - Keeping a True Hot Standby
Knowing and working with master-master replication and keeping a true hot standby is very important, especially when your business requires a fast failover with the least amount of downtime. This article focuses on the wonderful world of multi-master replication. Knowing how to setup and implement multi-master replication is the next step to faster, automated failover.
MySQL 
Advertisement
Advertisement
Advertisement
