Blog
Where is the MySQL in Sun’s announcement
I find it surprising that in the official Sun Announcement there is no mention of MySQL for two reasons. Firstly, this was Sun largest single purchase of $1 billion only 12 months ago.
Drizzle + PHP = Sweet
I’ve just successfully configured Drizzle with the PHP Extension and successfully retrieve data to present on a web page. Qudos to Eric Day for his work. I was able to identify a problem with the current tar release, and a quick confirmation on #drizzle at IRC confirmed a fix had already been commited.
What questions do you ask?
When you have to evaluate a MySQL System & Environment, what questions do you ask in order to determine critical information about the environment and evaluate the business success and viability.
mysql.com search is so broken
Today, while on the MySQL manual page , I typed in ‘select’ in the search manual box to confirm the SELECT syntax. The result was not what I expected, the “SELECT” command.
Developing Code Coverage for MySQL tests
I have always been a strong advocate of good testing of any system. I started on a project last year with Drizzle to produce coverage tests to facilitate verifying syntax and helping in comparison with MySQL.
A beginners look at Drizzle – SQL_MODE
A new feature to MySQL Version 5 was the introduction of SQL_MODE to support STRICT… or TRADITIONAL values. This feature enabled a closer compatibility to other RDBMS products. MySQL by default performs a number of silent data changes which do not help in providing a level of data integrity if you come from a more traditional background.
Identifying resource bottlenecks – Memory
Continuing on from CPU , we turn our attention to Memory. One of the first steps when addressing a MySQL performance tuning problem is to perform a system audit of the physical hardware resources, then identify any obvious bottlenecks in these resources.
A beginners look at Drizzle – Datatypes and Tables
The Drizzle database, while similar to MySQL includes a number of significant differences. In this post we will look at data types and table syntax that is valid in Drizzle. For more background information you can also review A beginners look at Drizzle – Getting around with SHOW .
A beginners look at Drizzle – Getting around with SHOW
Assuming you have successfully compiled Drizzle , and you are ready to start for the first time, here are some beginner differences with those familiar with the current MySQL 5.1 GA version.
A Drizzle update – Running version 2009.03.970-development
I’ve not looked at compiling and running Drizzle on my server for the past four weeks. Well overdue time for a check and see how it’s going. I saw in today’s planet.
Extending vmplot
Taking the work already done with vmplot.sh, a useful tool for MySQL performance tuning by Yves and Matt at BigDBAHead, and in true Open Source fashion I’ve enhanced and modified for my own purposes.
Identifying resource bottlenecks – CPU
One of the first steps when addressing a MySQL performance tuning problem is to perform a system audit of the physical hardware resources, then identify any obvious bottlenecks in these resources.
Two FREE MySQL Conferences Next Month
The annual MySQL Conference & Expo will be held in this year on April 20-23 in Santa Clara, California with a double twist. Not one, but *two* FREE additional MySQL Conferences are running at the same time, in the same hotel.
Twitter Tips
I have in the past questioned the value of Twitter as an effective business tool, but it continues to defy the trend of inability to bridge the business gap with social media.