Creating or dropping a partitioned table on InnoDB can become a quite expensive operation, on my laptop i'm seeing the following times for a simple table with 100 or 1000 partitions (using 5.1.58 right now as i'm testing on stock Ubuntu 11.10):

  mysql> CREATE TABLE t1 (id INT PRIMARY KEY )
               engine=innodb PARTITION BY HASH(id) PARTITIONS 100;
  Query OK, 0 rows affected (5.21 sec)

  mysql> drop table t1;
  Query OK, 0 rows affected (5.11 sec)

  mysql> CREATE TABLE t1 (id INT PRIMARY KEY )
               engine=innodb PARTITION BY HASH(id) PARTITIONS 1000;
  Query OK, 0 rows affected (52.76 sec)

So the time to create a partitioned InnoDB table grows linearly with the number of partitions at a 'speed' of about 20 partitions per second, and during that time the hard disk LED is always on. The rate for creating regular InnoDB tables on this machine is about 10 tables per second by the way.

MyIsam on …

My last post explained what to expect from memcached plugin in MySQL 5.6 (labs release). But I want to take a step back and think about "why" first. Why is memcached plugin of interest at all? What can I gain from using this instead of plain SQL?
First: I don't see this as a replacement for memcached. If you want memory caching with memcached then use memcached.
But the memcached plugin to MySQL is a replacement or addition to the SQL interface to MySQL. So instead of using SQL queries in your application to persist or retrieve data from MySQL you can use the memcached interface. And what are the benefits?

• Much higher performance
• Easier scalability via sharding
• Simpler application coding

1. PerformancePerformance is always good. But there are two different aspects of performance: Latency (or runtime) of a specific query …

Read the original article at Oracle to MySQL – prepare to bushwhack through the open source jungle

I was recently approached by a healthcare company for advice on suitable database solutions capable of executing its new initiative. The company was primarily an Oracle shop so naturally, they began by shopping for possible Oracle solutions.

The CTO relayed his conversation with the Oracle sales rep, who at first recommended an Oracle solution that, expensive as it may have been, ultimately aligned with the company’s existing technology and experience. Unfortunately this didn’t match their budget and so predictably, the Oracle sales rep whipped out a MySQL-based solution as an alternative.

Having worked as an Oracle DBA throughout the dot-com years, I know the technology well. I also know …

Last week I was part of a discussion panel on SQL versus NoSQL. Many in the audience seemed to believe that you needed to be one or the other with an exclusive or. Then today I learned about Vitess, an idea to use MySQL as a data layer while providing easy scaling and control the roll out of a logical schema. Is there room for an inclusive or.

Some traditional SQL rules are relaxed in conjunction with pools of sessionless connections. I hope Vitess does well and maybe this hybrid approach makes some of our current SQL/NoSQL arguments moot.

…

Read the original article at A handy guide for PHP and MongoDB Web Development

What makes a beginner’s guide handy is when it speaks to your intuition. It anticipates the burning questions that follow from a newbie trying to grasp new concepts and it quickly answers them. PHP and MongoDB Web Development – Beginner’s Guide is one such guide.

I hadn’t heard of Packt Publishing or Rubayeet Islam before picking up this title and I must say I’m impressed. Based in Birmingham, with offices in Mumbai, part of Packt’s business model is to give part of the royalties earned from its books to the open …

MySQL Tech Tour Event – CO Springs
Monday, March 12, 2012
1:00 PM – 4:30 PM
Invite:
http://www.oracle.com/us/dm/sev100051614-wwmk11042736mpp146-1526263.html

MySQL Tech Tour Event – San Diego
Wednesday, March 14, 2012
1:00 PM – 4:30 PM
Invite:
http://www.oracle.com/us/dm/h2fy11/51630-wwmk11042736mpp145c003-oem-1526730.html

MySQL Tech Tour Event – Phoenix
Friday, March 16, 2012
1:00 PM – 4:30 PM
Invite:
…

The 2012 SouthEast LinuxFest registration and call for papers are now live on their site.

MySQL Days at SELF!

"This year we are specifically seeking speakers from all over the database spectrum for Open Database Camp. ODC at SELF will consist of a track of database talks selected by SELF on Saturday, then an unconference on Sunday. So if you have a database related talk, please submit!" -- RFP Form 

I think a lot of folks are aware of this already, but just in case anyone missed it, let me post it again, as I’m quite excited about it.

Main Benefits:

• Monty Widenius and David Axmark will reunite for the key note!
• Six intensive tutorials!
• Free Lunch!

You can sign up for it in just a couple of seconds here .. and best of all, it’s completely FREE:

http://www.skysql.com/mysql-solutions-day

Hi,

We are delighted to announce the release of MONyog 5.0. This release is very special. This is not one of those bug fix / feature / functionality releases. This is about complete makeover for MONyog. Since the first release of MONyog, we have been continually adding features and fixing bugs. Less did we concentrate on looks and holistic usability. We kept on adding features with existing layout and put reorganizing logically connected elements to the back-burner. We thought it’s time to address these issues and took it up with MONyog 5.0.

• The design is modern. Easy to say in a line, but took months to come up with new looks as the software was not built to incorporate new design elements.
• MONyog is now more usable. We got into the shoes of a user and redesigned the flow, …

I’ll be presenting on/demoing MySQL Cluster 7.2 at this free breakfast seminar in Oracle’s London office on 25th April – starting with coffee at 9:00 and ending with lunch at 13:00 (quite a generous take on “breakfast”!). Space is limited and so if you would like to attend then register early here.

As well as MySQL Cluster there will be …