Databases
Today’s interesting MySQL Error Message
You have to love error messages some times. Today in MySQL is was “ERROR 1289 (HY000): The ‘UNKNOWN’ feature is disabled;” What was even more interesting is the error message and indeed the error number changed across different versions.
Read moreMySQL graphics and words in use
Not sure during my vacation which part of the creative brain has taken over, but I’ve become rather obsessed with marketing graphics and associated words being used across the MySQL and Sun MySQL websites, (See previous examples here and here ).
Read moreWhere is the Sun MySQL Reference Manual?
Yesterday I mentioned the new <a href=-“http://ronaldbradford.com/blog/?p=958">The official Sun-MySQL WebSite. It interested me with the navigation, graphics and content used to describe MySQL. Greg of One Free Voice in a comment raised a very valid question, he could not find the MySQL Reference Manual, see comments .
Read moreThe official Sun-MySQL WebSite
As already reported the deal is done (see Sun Press Release , Kaj – Ambassador to Sun comments ). I’ve had a look at the Official Sun-MySQL website. Here is a review of the interesting words and images on the new site.
Read moreMySQL Monitoring 101 – Graph your results
The problem Hands up those that don’t monitor their production MySQL web server. I’m a little surprised by this, but I’ve visited several clients that have absolutely no monitoring other then “the customers will tell us when something is wrong”.
Read moreMicrosoft, Yahoo and Open Source
There has been plenty of press this week regarding Microsoft making a bid for Yahoo. This week the Wall Street Journal Article From Uncertain Future To Leading Yahoo Bid has prompted me to the following observations.
Read moreSolid-State Drives Press
I read yesterday in The Wall Street Journal an interesting article in Personal Technology, “Solid-state drives challenge hard drives in speed, but not value”. While the title does sum up nothing new, the barrier to entry to embracing new technology is always cost, and early adopters may not have deeper pockets, but it’s also about being a alpha geek.
Read moreMySQL & Sun
I have been noticeably absent on my comments in this topic, something I was pinged about yet again today by another colleague. Did I have nothing to say? No. It’s just I’ve not been able to say much, or actually do anything in the past 7 days due to strong bought of the flu which has kept me in bed near 5 days straight (coincidently aligning perfectly with MySQL’s recent ACM.
Read moreCompiling MySQL 5.0.51 under Ubuntu 7.10
I’ve finally decided to work on a number of improvements in Instrumentation within the MySQL Server I’ve wanted for the first year, See What is the optimal thread specific buffer size?
Read moreWhat is the optimal thread specific buffer size?
So you want to know what join_buffer_size, sort_buffer_size, read_buffer_size and read_rnd_buffer_size values for your application should be? These MySQL thread specific buffers are variables I can never get right because there are insufficient metrics, instrumentation or even abstract details with the present MySQL Versions.
Read moreOptimal OS Partitions
What is the optimal OS partition layout for a database server? I’ve seen so many different configurations for OS partitions of recent time, none to my satisfaction. Historically, in Unix days 20 years agao, long before RAID and SAN’s all my experiences were for strongly defined partitions.
Read moreProcedure privileges
I came across a problem on site yesterday. In moving the development environment to a new server and creating more appropriate permissions for users (they were using ALL on *.*) I found that the Java application would crash with a NullPointerException.
Read moreMySQL under Mac OS/X 10.5
Time to install MySQL on my new MacBook . $ cd /opt $ wget http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.45-osx10.4-i686.tar.gz/from/http://mysql.mirrors.hoobly.com/ $ tar xvfz mysql-5.0.45-osx10.4-i686.tar.gz $ cd mysql-5.0.45-ox10.4-i686 $ scripts/mysql_install_db Installing MySQL system tables... 071129 22:10:48 [Warning] Setting lower_case_table_names=2 because file system for /opt/mysql-5.
Read more