Blog
Why are we standing still?
I wrote an email a week ago to several close friends titled, “[w]hy are we standing still?” I opened with “[y]ou are all good friends and you are all smart people.
MySQL conference schedule
I am one of the crazy individuals(*) that will be speaking at both the regular O’Reilly MySQL Conference and the IOUG Collaborate conference both being held in the second week of April.
Upcoming NY Presentation – How Better Indexes Save You Money
For all those in New York this is an upcoming MySQL presentation held in conjunction with our colleagues at General Assembly on March 22nd 2011. This presentation “How Better Indexes Save You Money” will be discussing how one simple technique can result in huge MySQL performance improvements and with zero code changes necessary.
Your PHP installation appears to be missing the MySQL extension which is required by WordPress.
I recently deployed a new WordPress installation to my existing production webserver running Apache, MySQL and PHP for other websites, yet I was presented with the following message. “Your PHP installation appears to be missing the MySQL extension which is required by WordPress.
Part 2 – Simple lessons in improving scalability
Given the popular response from my first lesson in improving scalability where I detailed simple ways to eliminate unnecessary SQL, let me share another common bottleneck with MySQL scalability that can be instantly overcome.
Optimizing UPDATE and DELETE statements
Updated Nov 2011. Check out my latest book on Optimizing SQL Statements for more information. MySQL 5.6.2 also now provides an EXPLAIN syntax for UPDATE and DELETE statements natively. While most people look at performance optimizations for SELECT statements, UPDATE and DELETE statements are often overlooked.
Simple lessons in improving scalability
It can be very easy to improve scalability with a MySQL server by a few simple rules. Here is one of them. “The most efficient way to improve an SQL statement is to eliminate it”
MySQL 5.5.9
You blink and there is a new version. I have not seen an Planet MySQL release as yet about this new version. Release Notes . I’d like to say I installed it, but I downloaded the Linux – Generic 2.
Leveraging the InnoDB Plugin
Beginning with MySQL 5.1 as an additional plugin and included by default in MySQL 5.5 the InnoDB plugin includes many performance improvements. To leverage the support of new file formats however a very important setting is necessary.
Interesting MySQL 5.5 upgrade gotcha
Today I discovered an interesting upgrade problem with a client migrating from MySQL 5.0 to 5.5. The client who is undertaking the upgrade reported that MySQL 5.5 did not support the DECIMAL(18,5) data type.
Higher Availability (HA) starts with two database servers
Many early startups that use a single server for all services or a single database server for their website talk about how they would like to achieve higher availability with MySQL.
Do you use PHPMyAdmin?
If so then were is it installed on your publicly accessible website. If the location is where the documentation states not to put it, or in other popular locations then you can easily become open to an attack.
Microsoft’s position on MySQL
While Oracle provides no official information they are planning on improving MySQL and using as a product to compete with Microsoft SQL Server, it is rather obvious from what little information you can glean from public announcements this is a clear business goal.
All time top MySQL Blogger
Planet MySQL contains the aggregation of MySQL articles from over 500 individuals and countries. In the MySQL Community Blogging article, Ronald Bradford was recognized as the all-time top individual MySQL blogger at Planet MySQL.