Blog
3 webinars on Upgrading MySQL
The IOUG Online Education Series: Get Real with Upgrades will include next week 3 different MySQL webinars. These are: MySQL 5.1: Why and How to Upgrade by Sheeri Cabral on Tuesday, July 27, 12:00 p.
Read moreInstalling WordPress on Oracle Enterprise Linux LAMP stack
A company blog can be easily configured in under 10 minutes using WordPress , a popular open source LAMP product that runs a reported 12+ million blogs including those found at CNN, NY Times, Wall Street Journal (WSJ), ZDNet, MTV, People Magazine, Playstation and eBay.
Read moreReviewing your MySQL installation on Oracle Enterprise Linux
After successfully Installing MySQL , let us take a look at an operational MySQL instance on your Oracle Enterprise Linux server. User Management By default there will be a new mysql user and group created.
Read moreInstalling a LAMP stack on Oracle Enterprise Linux
After successfully installing MySQL on Oracle Enterprise Linux installing a LAMP (Linux/Apache/MySQL/PHP) stack can also be performed with a single command: $ yum install -y httpd php php-mysql # Start the Apache Httpd Process $ /etc/init.
Read moreInstalling MySQL on Oracle Enterprise Linux
One of the significant benefits of MySQL is it’s ease of use. Generally already installed on most Linux systems, MySQL can be installed by a single command if not yet present.
Read moreSpeaking at Oracle Open World 2010
I will be one of 18 MySQL speakers at Oracle Open World 2010 at the first ever
Read moreOptimizing SQL Performance – The Art of Elimination
The most efficient performance optimization of a SQL statement is to eliminate it. Cary Millsap’s recent Kaleidoscope presentation again highlighted that improving performance is function of code path. Removing code will improve performance.
Read moreWhat do MySQL Consultants do?
One role of a MySQL consultant is to review an existing production system. Sometimes you have sufficient time and access, and other times you don’t. If I am given a limited time here is a general list of things I look at.
Read moreTiming your SQL queries
When working interactively with the MySQL client, you receive feedback of the time the query took to complete to a granularity of 10 ms. Enabling profiling is a simple way to get more a more accurate timing of running queries.
Read moreGetting started with Ruby and Sinatra
I’ve been doing a little work with Ruby , starting with some XHTML parsing with Nokogiri . I’ve just created my first web page using Sinatra . While the instructions makes it look simple, it was a little more complex due a package dependency error.
Read moreUpcoming Conferences with dedicated MySQL content
We recently held a dedicated MySQL Track at ODTUG Kaleidoscope 2010 conference for 4 days. This is the first of many Oracle events that will begin to include dedicated MySQL content.
Read moreImproving MySQL Productivity – From Design to Implementation
My closing presentation at the dedicated MySQL track at ODTUG Kaleidoscope 2010 discussed various techniques and best practices for improving the ROI of developer resources using MySQL. Included in the sections on Design, Security, Development, Testing, Implementation, Instrumentation and Support were also a number of horror stories of not what to do, combined with practical examples of improving productivity.
Read moreMySQL Idiosyncrasies That Bite
The following are my slides that I presented at ODTUG Kaleidoscope 2010 . This presentation talks about the MySQL defaults including a non-transactional state, silent data truncations, date management, and transaction isolation options.
Read moreGetting Nokogiri working under Mac OS X
The official Installation documentation states: sudo port install libxml2 libxslt sudo gem install nokogiri however I found this not to work for me. The following did work. $ sudo port install libxml2 libxslt $ sudo gem install nokogiri ERROR: could not find nokogiri locally or in a repository $ sudo gem sources -a http://gems.
Read more