Databases
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.
Read moreUsing 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.
Read moreFunny 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.
Read moreMySQL 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.
Read moreNY 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 .
Read moreLAST_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.
Read moreMySQL 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 .
Read moreDateTime 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?
Read moreThe woes of MySQL Community tools under Solaris
Yesterday I attempted to get a working MySQL environment to support the number of utilities we all use including mytop , innotop , mybench , mysqltoolkit . These products require a number of Perl Dependencies, and while that may be a rather trivial task under Linux and with the power of cpan , working on Solaris is a whole different story.
Read moreA MySQL Story
The Taso Dump I’ve gotto go, my time has come. (maintenance window needed) Could not get a lock. (table lock) I needed a blocker to ensure a single thread. (–single-transaction)
Read moreMySQL Camp II – Post Dinner
MySQL Camp II is complete. A small group of about 18 had post dinner at Tiny Thai in New York City. Some elected to drive from Brooklyn, they arrived at least 30 minutes after those of us that the subway.
Read moreMySQL Camp II – Introductions
We have started MySQL Camp II . The first session is Introductions. I didn’t catch all the employers, but here is part of the list of attendees at the Introduction section.
Read moreMySQL Camp II – It begins
Well readers, your either here or your not. MySQL Camp II starts today in Brooklyn, New York, at Polytechnic University. Last night’s pre drinks meetup in NYC went well, but today it’s brass tacks time.
Read more