MySQL Planet
innotop version 1.8.1 released
Sunday, 26 February 2012 06:06

The new stable version of innotop is now released. Version 1.8.1 is a bug-fix-only release, with no new features. It’s available for immediate download.

Further Reading:

 
Let your voice be heard – Help define the MariaDB 5.6 Roadmap
Sunday, 26 February 2012 02:06

We’ve had quite a bit of feedback already, so many thanks to all of you who have shared your thoughts with us!

However, if you’ve not voted yet, please take a moment and let us know what you’d most like to see in MariaDB 5.6:

http://www.skysql.com/content/new-server-functionality-have-your-say

As always, thank you, and we look forward to hearing from you.

Read more...
 
A better SHOW TABLE STATUS
Saturday, 25 February 2012 12:06

From command line we have the entire MySQL server on hands (if we have privileges too of course) but we don’t have a overall overview, at this point the show table status command is every useful, or not?.

This is what we get when run show table status in a standard 80×25 terminal screen:

Read more...

 
Introducing new type of benchmark
Saturday, 25 February 2012 10:06

Traditionally the most benchmarks are focusing on throughput. We all get used to that, and in fact in our benchmarks, sysbench and tpcc-mysql, the final result is also represents the throughput (transactions per second in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, response time is way more important metric to compare.

Read more...
 
Asyncronous Shard Queries in PHP using mysqlnd enabling the feed load 10 times faster.
Saturday, 25 February 2012 04:06
A few years ago I wrote about Asynchronous Shard Queries verses Synchronous Shard Queries, and in this post I talked about having to write a server to handle this for me in Java. Now I do it in PHP and got great results that are posted below.

Building the Feed was taking 100ms up to 40 seconds on the initial load, if the feed is out of cache.
Read more...
 
Book review: "The computer boys take over"
Saturday, 25 February 2012 04:06
I guess that most folk who read this blog are IT people in one way or the other. I do not expect my mother to read it, or even my wife. This is, after all, mostly about rather geeky technical computer things. But what do I do, when I am at work? I have been asked this more times than I care to remember, and I think this goes for most of you. Your significant other asks, your mum, some realtive, a guy you meet on a train or in a bar.
Read more...
 
Connector/J extension points – Load Balancing Strategies
Saturday, 25 February 2012 02:06

A fourth and final Connector/J extension point I covered in my JavaOne and Silicon Valley Code Camp presentations is load-balancing strategies.  This exists in order to allow you to define behavior for balancing load across multiple back-end MySQL server instances.

Read more...
 
Log Buffer #260, A Carnival of the Vanities for DBAs
Friday, 24 February 2012 10:06
Nothing pleases the technology bloggers more than the moment when somebody thank them for a helpful blog entry. That is one of the many awesome advantages of the technology blogs. In database arena, the developers, DBAs and evangelists are sharing their tips and tricks through their blogs and this Log Buffer Edition is projecting them [...]
PlanetMySQL Voting: Vote UP / Read more...
 
Recommendation: Vagrant and Veewee
Friday, 24 February 2012 08:06

Quoting from Vagrant’s web site:

Vagrant is a tool for building and distributing virtualized development environments. By providing automated creation and provisioning of virtual machines using Oracle’s VirtualBox, Vagrant provides the tools to create and configure lightweight, reproducible, and portable virtual environments.

A complementary technology called Read more...

 
« StartPrev12345678910NextEnd »

Page 1 of 340