We are proud to announce our first MySQL for Excel video is now available at the MySQL youtube channel.

Please give it an eye and get to know about the main features of MySQL for Excel (Import, Export, Append and Edit).

To view the video on youtube click over the image shown in below:

We always look forward to hear what new features you will like to see on future versions of MySQL for Excel so we encourage you to please visit our forum and let us know. Also, follow us at:

• Facebook - http://www.facebook.com/mysql
• Twitter -  …

I recently worked on an uncommon slow query: less than 100 rows were read and returned, the whole dataset was fitting in memory but the query took several seconds to run. Long story short: the query was a join involving 21 tables, running on MySQL 5.1. But by default MySQL 5.1 is not good at handling joins with such a large number of tables. The good news is that MySQL 5.6 brings welcome improvements.

Isolating the problem

As always with a slow query, finding the execution plan with EXPLAIN is the 1st step to understand where time is spent. Here the plan was very good with almost all joins using the primary key or a unique key, but perhaps the most interesting part was that EXPLAIN was very slow as well. This indicates that the optimizer takes a lot of time finding the optimal execution plan. To double check, we can run SHOW PROFILE:

mysql> set @@profiling = 1;
mysql> SELECT …

March 6, 2014 By Severalnines

Check Out Our Latest Resources for MySQL, MariaDB & MongoDB Clusters

Here is a summary of resources & tools that we’ve made available to you in the past weeks. If you have any questions on these, feel free to contact us!

ClusterControl 1.2.5 released

We are pleased to announce the release of ClusterControl 1.2.5, which now supports MySQL 5.6 and Global Transaction IDs to enable cross-datacenter and cloud replication over high latency networks. Galera users are now able to assign nodes to their respective datacenter. Other features include User Defined Alerts and agent-less monitoring.

…

Thu, 2014-03-06 09:30peterhumaj

In my previous role as the manager of an enterprise-grade public cloud, I’ve had the opportunity to work with many enterprises from across industries and across the world. All of these companies were looking for new ways to better understand and serve their customers, to improve efficiency, and improve their financials. There were many different approaches, but they all had one thing in common; it is all about data. Every day nearly 4 exabytes of data is created. This data holds great value for business, science and society. However, in order to extract that value, data needs to be stored, secured, managed and analysed. This is why I am excited to join SkySQL, a company that is at the forefront of driving innovation in databases.

Big Data is a big topic - and depending on who you’re talking to, it can mean very different things. There are two kinds of big data analytics - depending on whether you …

MySQL Workbench is the second most popular download of all MySQL products and recently a new Beta version was made available for evaluation. Workbench is a Swiss Army Knife tool with three very sharp blades — query tool, data modeler, and administration. Download here and pick the Development Release. We are looking for feedback on the new version so kick the tires, do a long afternoon test drive, and run it through the paces PLEASE! The changes over the GA release are very impressive and you do really need to try this beta. Packages for all the usual players — Ubuntu, Fedora, RHEL/Oracle, OSX and Windows — are available. Windows users get a Zip archive they can unpack where desired and run from there while others get to use their regular rituals for their package manager. The first window you see

…

Devart is glad to announce the release of the new versions of dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, dotConnect for SQLite, and dotConnect for DB2 - enhanced database connectivity solutions, built over the ADO.NET architecture, that support Entity Framework and LinqConnect ORM solutions. New versions of dotConnect data providers offer you support for ASP.NET Identity technology.

Devart is glad to announce the release of the new versions of dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, dotConnect for SQLite, and dotConnect for DB2 - enhanced database connectivity solutions, built over the ADO.NET architecture, that support Entity Framework and LinqConnect ORM solutions. New versions of dotConnect data providers offer you support for ASP.NET Identity technology.

I want to teach you the difference between an inner and an outer join. We first need to think about what a join is. Simply, it’s when you combine two tables to make a new one. You’re not physically creating a new table when you join them together, but for the purposes of the query, you are creating a new virtual table. Every row now has the columns from both tables. So if TableA has columns Col1 and Col2 and TableB has columns Col3 and Col4, when you join these two tables, you’ll get Col1, Col2, Col3, and Col4. Just as with any query, you have the option of including all columns or excluding some, as well as filtering out rows.

Inner join. A join is combining the rows from two tables. An inner join attempts to match up the two tables based on the criteria you specify in the query, and only returns the rows that match. If a row from the first table in the join matches two rows in the second table, then two rows will be …

Dear MySQL users,

We are proud to announce that we have made the open source version of our Connector/NET 6.8.3 is available as official MySQL Nuget packages.

Currently we have 3 nuget packages which contain:

• MySQL Connector/NET Core
• MySQL Connector/NET for Entity Framework 6
• MySQL Connector/NET Web providers

I’ve been a little behind in recent blogging efforts, and realized that in less than a month we’ll be back at Percona Live: MySQL Conference and Expo 2014, aka PLMCE. Last year’s PLMCE was my first, as well as the event where Tokutek announced the open sourcing of TokuDB.

It’s hard to believe that a year has gone by, but the customer adoption in both enterprise and community users has been awesome. TokuDB is available from our website for both MySQL and MariaDB, and is also available directly from MariaDB and …