Databases
MySQL Monitoring 101
At the 2009 MySQL Conference and Expo I presented to a full room on MySQL Monitoring 101 . This presentation focused on the following four goals. Know what to monitor Know how you can monitor Learn practices to diagnose problems Have a foundation of historical information MySQL Monitoring 101 View more presentations from Ronald Bradford.
Read moreA change in the MySQL Binary distributions
Yesterday was the surprise announcement of MySQL 5.4 at the 2009 MySQL Conference and Expo. It was unfortunate that the supporting information was not that forthcoming on the MySQL website. I tried for several hours to try and download, but no mirrors were initially available.
Read moreSetting up MySQL on Amazon Web Services (AWS) Presentation
On Tuesday at the MySQL Camp 2009 in Santa Clara I presented Setting up MySQL on Amazon Web Services (AWS). This presentation assumed you know nothing about AWS, and have no account.
Read moreWhat’s happening with InnoDB
I have moved on to InnoDB: Innovative Technologies for Performance and Data Protection by Ken Jacobs at MySQL Conference and Expo . With a brief history lesson of inception from 1994, inclusion in MySQL in 2000 and acquired by Oracle in 2005.
Read moreSearch at Craigslist
I am now sitting in on MySQL and Search at Craigslist by Jeremy Zawodny at MySQL Users Conference Some of the technical difficulties that required addressing. High churn rate half life can be very short Growth Traffic Need to archive postings, e.
Read moreMySQL Users Conference Opening Lines
Opening introduction from Colin Charles got us started. Karen Tegan Padir VP MySQL & Software Infrastructure was the opening keynote. She comes from a strong tech background and is passionate about open source, the communities and how to make a successful product.
Read moreWhere 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.
Read moreDrizzle + 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.
Read moreWhat 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.
Read moremysql.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.
Read moreDeveloping 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.
Read moreA 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.
Read moreIdentifying 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.
Read moreA 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 .
Read more