MySQL
Compiling 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?
What 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.
Optimal 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.
Procedure 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.
MySQL 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.
MySQL at Oracle Open World
Yes, it may seem rather strange to the readers but MySQL has a booth at this week’s Oracle Open World 2007 and I’m here in San Francisco Wednesday and Thursday. If your in SF come in and say hi.
Using MySQL Table Checksum
The MySQL Table Checksum , part of the MySQL Toolkit (having to be renamed soon ) is an invaluable community tool for use with MySQL. Most sites or installations of any volume will use MySQL Replication for one purpose or another, be it for read scalability, backups, testing, upgrading etc.
Funny command line option for the day
I needed to start mysql without privileges after a database restore today, and while confirming the correct option which was –skip-grant-tables I came across an option which made me laugh.
MySQL Conference Submissions have closed
If you didn’t get your proposal in for MySQL Conference 2008 , that’s too bad. I often wondered from past conferences why submissions were needed so early, like 5 months before.
NY Users Group – Analyzing MySQL Status and your SQL
This month I continued my Performance Analysis talks at the Local NY MySQL Meetup . Previous discussions can be found here . Our focus was a more in-depth look at gathering and reviewing MySQL Status and your applications SQL statements using MySQL Proxy .
LAST_INSERT_ID(expr) – The lesser known usage
I am of the attitude, the day you stop learning something is the day you die. I’m not prepared to induce MySQL into both sides of that equation, however some days it never ceases to amaze me what little thing I didn’t know about MySQL.
MySQL Camp II – Memorable Quotes Day 1
Better late then never, this week I finally have the chance to catch up on some overdue posts. At the first MySQL Camp I made a list of memorable Quotes, see Day 1 , Day 2 , Day 3 .
DateTime vs Timestamp
I was asked a question today, “DATETIME vs TIMESTAMP. When to use which & why?” It’s a good MySQL introduction question, here are some general considerations for choosing one. Do you need Date values other then an EPOCH value?