I thought I would introduce my hobby project tweet2email.com.

I created Tweet 2 Email because I had certain people I follow in Twitter who do not post very regularly, but whose updates I do not want to miss in the flow of more regular posters. Tweet 2 Email allows you to follow someone via email by sending you hourly digests of a selected user’s updates. I later added the ability to subscribe to a Twitter search, allowing you to keep up with a given subject.

I built it using PHP, MySQL and a PHP-Twitter library I tweaked for my purposes.

I’m still testing and improving it, but if you need to track something in Twitter I invite you to give it a try.

MySQL's compressed protocol is not so widely used, but there are still users that use it. Thus, the need to implement it in mysqlnd.

Unfortunately the compressed protocol is full of landmines, a lot of them, exploding one by one.

We are proud to announce the next service release of MySQL Workbench 5.1.18. We have fixed another set of bugs and made some improvements you people have been asking for. We have optimized the layout of the Columns-section in our table-editor considering the ideas and exeriences you posted in feature requests, bug-reports and on the forums. Now it should provide a smoother more comfortable workflow.
As already reported in previous blog-posts, this version is also compatible with Apples recently released version of OSX – 10.6 Snow Leopard.
Detailed information on the fixes can be found on our Releases Page.

The new files are available on our download page:

http://dev.mysql.com/downloads/workbench/5.1.html

If you encounter problems or have any questions, you …

A quick tip. When placing a VM for an application/app server that connects to a VM running MySQL, you will get bus level (as opposed to network) data transfer rates over their Virtual NICs when installed on the same baremetal hypervisor. Something to consider.

This comes rather quickly as the last revision – 150 was just uploaded a few days ago. This is because there was a new method of checking config options in the bin/ scripts that utilizes the codeigniter config files instead of config.cfg in the base directory, the problem was the all of the required bin/ [...]

The MySQL 5.1.38 release is available today with the InnoDB Plugin (1.0.4) included in the software distribution.  The InnoDB Plugin offers some key features: Improved performance and scalability.

Important management features that will be very helpful to MySQL DBAs.     I recommend you look into the new features available with the InnoDB Plugin. The InnoDB Plugin (1.0.4) is at end of beta

If you are unfamiliar with what to monitor in MySQL, starting with looking at what popular Monitoring products monitor. For example, the following is the list of MySQL Cacti Plugin measurements.

Innodb Buffer Pool Activity

• Pages Created
• Pages Written
• Pages Read

Innodb Buffer Pool Pages

• Pool Size
• Database Pages
• Free Pages
• Modified Pages

Inoodb File I/O

• File Reads
• Files Writes
• Log Writes
• File Fsyncs

Innodb Pending I/O

• Aio Log Ios
• Aio Sync ios
• Buffer Pool Flushes
• Chkp Writes
• Ibuf Aio Reads
• Log Flushes
• Log Writes
• Normal Aio Reads …

As I outlined in Part 1 MySQL Proxy can be one tool for performing SQL analysis. The impact with any monitoring is the art of monitoring will affect the results, in this case the performance. I don’t recommend enabling this level of detailed monitoring in production, these techniques are designed for development, testing, and possibly stress testing.

This leads to the question, how do I monitor SQL in production? The simple answer to this question is, Sampling. Take a representative sample of your production system. The implementation of this depends on many factors including your programming technology stack, and your MySQL topology.

If for example you are using PHP, then defining MySQL proxy on a production system, and executing firewall rules to redirect incoming 3306 traffic to 4040 for a period of time, e.g. 2 …

It's gotta be tough for InfoWorld's overworked editors to figure out how to recognize the best open source products out there. Open source has become so pervasive in IT that there aren't too many areas where there aren't at least a half-dozen interesting pieces of open source technology from software infrastructure, networking, development tools, desktop software, you name it. I'm not a part of the decision making process in these awards, but I have empathy for them and all the different products they need to consider.

read more

Just in case you missed the live event, we have a recording of the ZFS + SSD for databases webcast

Listen Now

You can also download the slides from Slide share. Download Slides