The tools we’ve redesigned in Percona Toolkit recently have moved away from a legacy technique for operating on small numbers of rows at a time, towards a more reliable and predictable method. We call the old version “chunking” and the new version “nibbling.” Many other MySQL tools I’ve seen either operate on entire tables, or use the “chunking” technique and are exposed to the problems it creates. I’ll compare the two briefly to explain the differences.

I still continue to run benchmarks of different SSD cards. This time I show numbers for Virident FlashMAX 1400. This is a MLC PCIe SSD device. There are couple notes on these results.
First, this time I use a different server. For this benchmark it is Cisco UCS C250, while for previous results I used HP ProLiant DL380 G6.

Second note is, that I use a mode “turbo=1″ for Virident card. What does that mean? Apparently PCIe specification has a limitation on available power. If I am not mistaken it is 25W, however Virident to provide full write performance requires 28W. And while many servers can handle 28W on PCIe, this is a non-standard mode, and Virident by default uses 25W (turbo=0). To force full power, I load a driver with turbo=1. I also use “maxperformance” formatting for Virident, …

As an experiment, I have converted the MariaDB Bazaar repository into Git.

https://github.com/atcurtis/mariadb

Should be interesting...

The social network problem

Social networks like Facebook and Google+ have always been known as huge data mining machines and that they don’t have very strict privacy policies, meaning that:

• you are not informed what happens with your data (what it is used for) when you enter it,
• you don’t have full control over your data (deletion is very hard to impossible, you can’t rely that “deleted” data is really erased etc.),
• data may be given to third parties (like application providers) or wrong people without your (explicit) consent.

“Don’t use social networks” is not a solution in my opinion because social networks are media like any other media, and they have advantages (that’s why they shall – and will – be used) and dangers (that’s what should be minimized).

Diaspora – a solution?

So, I was very happy when I heard the first announcement of …

Happy Star Wars Day. May the Fourth be with you!

We are still busy with data center moves! Only two more to go through, until we are all done. Twice this week, people have come to me, frantically saying “This database is moving NEXT WEEK and I need it migrated! Help!” and in both instances my reply has been, “Those servers are ready to go, they’ve been replicating data for weeks.”

Which led coworker Shyam Mani to make a Chill Meme (has bad language), which then prompted me to make a Keep Calm Meme.

• Added some metadata for http://graphs.mozilla.org.
  
• Moved our internal …

This week we talk about MariaDB - explaining features, and comparing to Percona's patched MySQL and Oracle's MySQL. MariaDB is touted as "a better MySQL, not a different MySQL". MariaDB is the 2nd most popular open source database, even more popular than Postgres.

Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!

read more

The Ubuntu Developer Summit takes place at The Oakland Marriott City Center, Oakland, California from 7–11 May 2012.

If your attending the event, you will have a few different blueprints to discuss MySQL opportunities:

•  MySQL RoundTable 
•  Utilities to work with MySQL

A full schedule is available here: http://summit.ubuntu.com/uds-q/

Oracle is proud to also be a Sponsor of the Ubuntu Developer Summit.

A big thanks to the NYC MySQL Community for a great turn out at the OTN MySQL Developer Days in NYC.

We had well over 200 people that stayed until the end. The attendees all enjoyed sessions that included MySQL Cluster, InnoDB as well as the different performance improvement sessions.

I hope they can join the rest of the MySQL Community for the MySQL Innovation Day  (a web cast is available) and MySQL Connect.

The Rocky Mountain Oracle User Group MySQL SIG is meeting May 18th in Building 1 of the Oracle Broomfield Campus. Speakers include Ronald Bradford, Dan Hotka, Donald Schaefer, David Peake, and George Trujillo.

As the summer in many parts of the world starts, not only the snow is thawing, many bloggers are also coming out of hiatus and the database blogosphere is seeing new sensational activity. This Log Buffer Edition includes blogging tidbits from Oracle, SQL Server and MySQL. Enjoy reading Log Buffer #270. Oracle: Oracle’s Timeline, Copious [...]