This post is slightly off-topic, but I thought I'd share some information.  I've been suffering from carpal tunnels syndrome recently, and it's only gotten worse.  Apparently I'm not the only bloggers to suffer from this. And what's apparently made it worse is in my Internet/e-mail/blogging addiction, I've queued up a bunch of posts to take place over the next couple of weeks while I'm traveling.  (I may also have aggravated this by trying to play a lot of rock guitar.  Recently when I'm completely ill-equipped to do so.)

At any rate, I'm trying not to type so much.  And some of you may have already guessed that this posting is being written using voice recognition software from Dragon systems.  (Naturally speaking, version …

As you probably know MySQL is Running AdSense Ads on PlanetMySQL.org for last few months. When the project was just started it was Ad free. I’m curious If MySQL Really ask syndicated Blog owners if they would allow that or if they just hope if someone does not like it he would speak up ?

I recently found an blog post on the same matter which make me to think on this once again.

So what is my take on this ? We currently run no Ads on MySQLPerformanceBlog and I would not like to see someone making money from something I have chosen to be free.

Would I like to be removed from PlanetMySQL aggregation ? No because many MySQL users are subscribed to PlanetMySQL rather than tens of individual MySQL blogs they would like to read, and I do not want to cut my RSS feed for the same reason.

I learned an extremely valuable lesson today on a client site. It’s important that users of MySQL read the right version of the manual for the product they are using. It’s very easy to just goto http://dev.mysql.com/doc/ which is what I type in directly and browser the manual. While the MySQL Manual has separate sections for 4.x, 5.0, 5.1 etc, the 5.0 Manual for example reflects the most current version of MySQL 5.0. You may not be running the most current version, infact most production systems rarely run the current version.

My specific case was with Connector/J (JDBC) Reference of 5.0.4. The manual pages reflects the new 5.0.5 or todays’ 5.0.6 release and a particular default is now a different value. With …

I just want to raise a warning flag for DBAs using RMAN and flash recovery area in Oracle 10g. An RMAN script is usually something like: backup database plus archivelog

However, the behavior of plus archivelog depends on whether optimization is enabled or disabled in RMAN. The RMAN reference document says that when the plus archivelog [...]

This release of MySQL Table Sync adds the ability to sync only part of a table, adds minor new functionality, and fixes a bug that could crash the tool. I will be focusing some effort on this tool soon. If you would like to see particular features, please consider sponsoring them.

By Mike Hendrickson

In this fourth post [one, two and three are found here] on the State of the Computer Book Market, I will look at programming languages and drill in a little on each language area.

A Treemap view of the Programming Languages

Overall the Q1 '07 market for programming languages was down (9.10%) when compared with Q1 '06. There were 482,079 units sold in Q1 '06 versus 441,850 units sold in Q1 '07.

In the treemap view below, you will notice a couple of bright green areas -- namely Ruby and Transact SQL. JavaScript and Python, which are also green [not bright green] show a nice growth when compared to the Q1 '06 …

I came up with this analogy today comparing MySQL and Oracle and it seemed to fit. Only real Unix geeks will get this, but here goes:

MySQL is to Oracle as Vi is to Emacs

Maybe this has been said before, but think about it.

Here's what they all have in common:

• 
  
• All are cool technologies and worthy of respect in their own right
  
• All have zealots vigorously defend their technology to the death
  
• Each set (Oracle/Emacs and MySQL/Vi) represents a different way of looking at and solving a problem
  

For the Oracle/Emacs world things work like this:

The technology is the be-all/end-all, make it do everything we want.

In many ways this is a huge advantage, things are tightly integrated, you don't need to worry so much about system conventions and …

MySQL Table Checksum 1.1.5 adds a some useful features and fixes a couple of bugs. Now you can checksum tables in chunks, and there is an option to pause between chunks as well. This has already helped me recover a very large table that got out of sync on the slaves, and many of you have also requested this feature.

One thing that has been a curious topic among some of us here at work has been if raw InnoDB partitions are better than using files on-top of a file-system. Well, I was able to find a test server that, while it has modest hardwawre, it did have a spare drive to use for this purpose.

First things first, the tests were run on a system with an Athlon XP 2000+, 512MB of RAM, and 2 identical 80GB EIDE drives with 2MB of disk cache. The OS was Red-Hat ES4 and I used MySQL 5.0.41 for the tests. The InnoDB data was housed on a single partition on the second drive for all tests. The InnoDB logs, however, remained in /var/lib/mysql. MySQL itself was configured using default settings (with the exception of having to change the innodb_data_file_path of course).

The file-system test was done by formatting the partition with EXT3, mounting it under /mnt/innodb and having MySQL use it for the ibdata files. For the raw partition, though …

Von Kriesse.

Nutzt Du Social Bookmarking/Networking Seiten wie Digg, Yigg, Mister Wong oder Del.Icio.Us? Wenn ja, welche?

Digg fuer News und del.icio.us zum Bookmarks ablegen und finden.

Schaust Du Dir Videos bei Videoportalen wie YouTube, Sevenload oder DailyMotion an? Wenn ja, was für Videos guckst Du Dir meistens an?

Ab und zu YouTube, entweder albernes Zeug oder irgendwelche neue Musik, die es noch nicht zu kaufen gibt.

Kennst bzw. nutzt Du Flickr?

Ja

Was hältst Du von Diensten wie Twitter oder Frazr?

Twitter ist nett um Events zu verfolgen, an denen man nicht teilnehmen kann. Sonst ist das eher uninteressant.

Wie viele RSS-Feeds hast Du abonniert?

138

Liest Du die alle …