MySQL: Tuning filesorts and temporary tables

Filesorts and temp tables are a necessary evil in MySQL, used when MySQL must sort the data before returning the output to the user. They are the most common issue with slow queries in MySQL, the main reason being that if the output is too large, you can kiss goodbye in-memory performance, and say hello to disk access.

Read More >

MySQL Can’t Use Index With Uncorrelated IN Subquery

Today is the first time I had to look at MySQL performance. Tiny database as web application back-end was having significant performance issues with spikes of CPU workload. After identifying problematic queries, I found a pile of statements using IN subqueries. I asked around and our MySQL experts assured me that this is one of the minor and not so disturbing issues, in fact. I can’t imagine what those disturbing issue are. I guess Oracle XE does have some advantages over MySQL for small installations.

Read More >

MySQL Recipes: Promoting a Slave to Master or Changing Masters

In MySQL–land, failovers for redundancy, disaster recovery, or load balancing are performed by master databases and slave databases, the most popular method using binlog replication. There are a couple more methods of replication which aren’t covered here. Also see the MySQL Replication FAQ. The methods are the same, but the formatting of the procedure(s) are less than ideal.

Read More >

MySQL and PostreSQL on Solaris 10

First of all, there is now FREE Solaris 10 media kit available to order by mail if you’re not fancy downloading several GB. By the way, it also includes Sun Studio (anyone using it?). Second, I found a cool article on Solaris BigAdmin portal – Deployment Guide for an Open Source Stack on the Solaris 10 OS also available as PDF.

Read More >

MySQL CEO Marten Mickos Interviewed

I just read this excellent review by Matt Asay of an excellent interview by Guy Kawasaki (of garage.com and apple fame) of MySQL CEO Marten Mickos.

Read More >

MySQL 5.0 is Now Available

MySQL AB,”developer of the world’s most popular open source database” has released today, the production versionof MySQL 5.0, its most important upgrade in ten years. The 5.0 version provides new enterprise database features such as stored procedures, triggers, views and cursors.

Read More >

Pervasive Posts Rival to MySQL

Did you know the data infrastructure software company Pervasive Software Inc., is coming out with a customized version of the open-source PostgreSQL database?

Read More >
Page 25 of 25« First Page...10...2122232425