MySQl 5.6.10 is easily buildable from source code. In an earilier post I discussed the differences in using pre-packaged builds versus binaries bersus source code and had a few readers ask for details on building from scratch.

Step 1 — Download the source code from http://dev.mysql.com. Once again, you have the options of packages like RPM or a tar ball. In the following steps I usedthe good ol’ tar ball.

You too can build your own MySQL 5.6.10 from source code.

Step 2 — Unpack the downloaded code in the directory of your choice. I used the /usr/local/ of my Centos test server and executed tar xzf /home/dstokes/Downloads/mysql-5.6.10.tar.gz.

Step 3 — Inside /usr/local/mysql-5.6.10 you will find a file …

The MySQL & Cloud Solutions Day will take place at the Hyatt Regency Santa Clara, immediately following the Percona Live:  MySQL User Conference & Expo 2013

During this one day event, Monty Widenius and Patrik Sallner, SkySQL CEO, will share insights on the current and future trends pertaining to MySQL, MariaDB 10.0, and the Cloud.  The event will feature two technical tracks:  one focused on the MySQL database and related technologies, and a second on best practices for deploying database applications in the Cloud.  Speakers will also include SkySQL and MariaDB customers, users and partners.



read more

Data management is undergoing a revolution.  Many businesses now depend on data sets that vastly exceed the capacity of DBMS servers.  Applications operate 24x7 in complex cloud environments using small and relatively unreliable VMs.  Managers need to act on new information from those systems in real-time. Users want constant and speedy access to their data in locations across the planet.

It is tempting to think popular SQL databases like MySQL and PostgreSQL have no place in this new world.  They manage small quantities of data, lack scalability features like parallel query, and have weak availability models.  One reaction is to discard them and adopt alternatives like Cassandra or MongoDB.  Yet open source SQL databases have tremendous strengths:  simplicity, robust transaction support, lightning fast operation, flexible APIs, and broad communities of users familiar with their operation.  The …

In Part 1, we showed performance results of some of the work that’s gone in to TokuDB v6.6. In this post, we’ll take a closer look at how this happened, on the engineering side, and how to think about the performance characteristics in the new version.

Background

It’s easiest to think about our concurrency changes in terms of a Fractal Tree® index that has nodes like a B-tree index, and buffers on each node that batch changes for the subtree rooted at that node. We have materials that describe this available here, but we can proceed just knowing that:

1. To inject data into the tree, you need to store a message in a buffer at the root of the tree. These messages are moved down the tree, so you can find messages in all the internal …

MySQL makes it easy to bulk load multiple rows of data from a flat file into a MySQL table using the LOAD DATA INFILE command, but that command can quickly get you into trouble if you are not careful about capturing the warnings and errors it produces.

Running LOAD DATA INFILE commands at the mysql prompt gives you pretty good output, but if you run the same command at the terminal or in a shell script you have to do a little bit of extra work to capture the errors and warnings.

Here are a few techniques I use when I run LOAD DATA INFILE at the terminal or in a shell script:

1. Use double-verbose mode (--v) to capture the high level counts of Records, Deleted, …

MySQL makes it easy to bulk load multiple rows of data from a flat file into a MySQL table using the LOAD DATA INFILE command, but that command can quickly get you into trouble if you are not careful about capturing the warnings and errors it produces.

Running LOAD DATA INFILE commands at the mysql prompt gives you pretty good output, but if you run the same command at the terminal or in a shell script you have to do a little bit of extra work to capture the errors and warnings.

Here are a few techniques I use when I run LOAD DATA INFILE at the terminal or in a shell script:

1. Use double-verbose mode (--v) to capture the high level counts of Records, Deleted, …

The day has come, MySQL 5.6 is now generally available (GA), ready for production use (at the time of writing the latest version number if 5.6.10). To download, go to www.mysql.com or go directly to the download page.

As part of MySQL Server Quality Assurance I have been "intimate" with parts of this release for a long time... it comes with many new great features, bug fixes and other improvements. While I won't claim it to be bug free (after all, no software is), I feel confident that it is a big step forward from earlier releases for the majority of use cases.

Give it a spin!

The MySQL developer tools team announces the availability of version 5.2.46 of the MySQL Workbench GUI tool. This version contains 30 resolved bugs and support for the new MySQL 5.6 server.

Additionally, MySQL Utilities 1.2.0 have been included on the distribution.

For a full list of issues fixed in this release, see the release notes.

Please get your copy from our Downloads site. In Windows, you can also use the MySQL Windows Installer to update Workbench and other MySQL products.

Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

Workbench Documentation can be found …

The MySQL developer tools team announces the availability of version 5.2.46
of the MySQL Workbench GUI tool. This version contains 30 resolved bugs
and support for the new MySQL 5.6 server.

Additionally, MySQL Utilities 1.2.0 have been included on the distribution.

For a full list of issues fixed in this release, see the release notes.

Please get your copy from our Downloads site. In Windows, you can also
use the MySQL Windows Installer to update Workbench and other MySQL products.

Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

Workbench Documentation can be found …

MySQL 5.6 reached GA (General Availability) today and is packed with a wealth of new features and capabilities.  Exciting stuff!
MySQL 5.6 also introduces the largest set of enhancements to replication ever delivered in a single release, including: - 5x higher performance to improve consistency across a cluster and reduce the risks of data loss in the event of a master failing - Self-healing clusters with automatic failover and recovery from outages or planned maintenance - Assured data integrity with checksums implemented across the replication workflow - DevOps automation
Of course, getting started with all of these enhancements can be a challenge - whether you are new to MySQL replication or an experienced user. So two new Guides are available to help take advantage of everything replication offers in MySQL 5.6.
…