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 [...]

A short while after I fixed the legacy bug that prevented temporary MyISAM tables from using the dynamic record format, I got an email from Davi Arnaut @ Twitter. It turned out that Twitter needed to fix the very same problem, but for the case when INFORMATION_SCHEMA temporary tables use MyISAM.

In short, INFORMATION_SCHEMA tables provide access to database metadata. Despite their name, they are more like views than tables: when you query them, relevant data is gathered from the dictionary and other server internals, not from tables. The gathered data is stored in a temporary table (memory or MyISAM depending on size) and then returned to the user.

The reason Davi emailed me was to let me know that he had further improved the fix for temporary MyISAM tables to also enable the use of dynamic record format for …