>

Amazon's play in 'big data' lives large.  From S3 to EBS to EC2, Amazon has its share of acronyms and playgrounds.  Recently, Amazon launched Redshift, an analytic database utilizing ParAccel's in-memory capabilities on top of Amazon's cloud infrastructure.  While the full details of ParAccel and Amazon's collaboration remain hidden, the offspring of their work has shown promise. 

To shed light on the differences between Infobright Enterprise Edition (IEE) and Redshift, I surveyed several potential Infobright prospects who evaluated both technologies.  Overall, a single Infobright M2 2XL node performs the same as 4-5 Redshift XL nodes.  No comparisons were performed between the Infobright Community Edition and Redshift.

While Redshift is a compelling solution, there are stark contrasts between IEE and Redshift that you should consider during an evaluation.  As always, the best …

One of the new features in MySQL 5.6 is persistent table statistics. The word “persistent” makes you think that table statistics will be very stable from now on.
This is generally true, but there are some exceptions. There is a particular case where InnoDB statistics may change with no warning, even when there is no user activity on the server. Consider the following pattern (which nearly all bug or feature testcases follow):

CREATE TABLE t1 (...) ENGINE=INNODB;
INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
EXPLAIN SELECT * FROM t1;
EXPLAIN SELECT * FROM t1;

With MySQL 5.6, the following is possible

• the first EXPLAIN will show that the optimizer expects table t1 to have 6 rows
• the second EXPLAIN will show that the optimizer expects table t1 to have 5 rows

For me, this was a big surprise. After all, table t1 never had 6 rows. If there was some rounding which rounded up 5 to 6, why …

Summer is flying by and it's almost time to get back to school! We will be continuing our Tungsten University series on August 22nd, with a live webcast "MySQL Multi-Master Operations Made Simple With Tungsten Replicator 2.1". 

Deployment of MySQL multi-master topologies with Tungsten Replicator has been constantly improving. Yet, earlier there were some heavy operations to sustain, and

Hi! I just wanted to ask if you ever have any problems with hackers?
My last blog (wordpress) was hacked and I ended up losing months of hard work due to no data backup.
Do you have any solutions to protect against hackers?

This week we discuss copyleft, GPL and related licenses. In Ear Candy we discuss INFORMATION_SCHEMA and permissions, and At the Movies is about a columnar database.

Events
DB Hangops - every other Wednesay at noon Pacific time

Oracle is having a MySQL OTN Virtual Developer Day August 31st.

FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

Upcoming MySQL events

read more

We have forums available to help you answer your questions when dealing with our Windows products.  You can post questions, answer other user's questions, and find solutions to your own problems there.   You can find these forums along with many other resources in our Development Zione found at http://dev.mysql.com/.  The forums are located at http://forums.mysql.com/.

 Here are the forum links for our products:

• Connector/Net - http://forums.mysql.com/list.php?38
• MySQL for Visual Studio -http://forums.mysql.com/list.php?174
• MySQL for Excel -  …

If you see the “Waiting for table metadata lock” error, you may be wondering what is the best course of action to prevent it in the future. I have briefly discussed troubleshooting metadata locks before, however, that post more illustrated how easy it is to encounter the “Waiting for table metadata lock” error in both MyISAM and InnoDB. It provides simple examples for reproducing using both storage engines, so one could hopefully more easily identify where the locks are stemming from in their particular case.

Pin-pointing which transaction holds the locks is a different story. There are feature requests filed in MySQL and MariaDB bugs databases to track this information, but they are recent, and no ETA is scheduled for either yet, as far as I know:

http://bugs.mysql.com/bug.php?id=69527 …

Those who deal with big data probably know about Disco – a distributed computing framework aimed to provide a MapReduce platform for big data processing Python applications. We are proud to say that we are one of the largest users of Disco in the Netherlands. As an owner of multiple high-traffic portals with lots of […]

The post Big data processing with Disco appeared first on Spil Games Engineering.

MySQL 5.6 introduces a new feature – microseconds resolution in some temporal types. As of 5.6.4 TIME, TIMESTAMP and DATETIME can have a fractional part. To create a field with subseconds you can specify precision in brackets: TIME(3), DATETIME(6) etc.

Obviously, the new feature requires the format change. All three types may now have a tail with a fractional part. The tail may be one, two or three bytes long and can store up to six digits after the point.

The non-fractional part has changed too. Thus, DATETIME uses only five bytes comparing to eight in previous versions.

As of revision 79 the …

On Thursday, Dr Charles Bell and I will be presenting a webinar on MySQL Utilities; there will be a heavy focus on what you can acheive with them and how you should use them. As well as listening to the presentation, this is a great chance to get your questions answered by the experts (Israel Gomez from the engineering team will also be on-line to help with the questions). As always, the webinar is free but you should register in advance here. If the time isn’t convenient, register anyway and you’ll be sent a link to the replay when it’s available.

Abstract:

MySQL Utilities provide a collection of command-line utilities that are used for maintaining and administering MySQL databases, including:

• Admin …