Here is an interview of me talking about EXPLAIN FORMAT=JSON, optimizer trace, cost model, MySQL Workbench and even a little Performance Schema.
Some links that I recommend checking out:
MySQL Workbench 6.2 (6.2.5 GA, published on Tuesday, 03 Mar 2015)
Oracle's MySQL Team is busy in March. We're traveling to many
places to bring the latest MySQL news and product development to
a city near You!
Do you want to learn more about building a security enterprise
platform with MySQL? Want to hear what's new in MySQL 5.7 and
MySQL Enterprise Monitor 3.0? Get ready to discover which of the
MySQL high availability solutions is the best fit for your
infrastructure?
Plan to join one of the following MySQL events:
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.17 and MariaDB 10.1.3. MariaDB 10.0.17 is a Stable (GA) release. MariaDB 10.1.3 is a Beta release.
Release Notes Changelog What is MariaDB 10.0?
…
[Read more]MySQL development engineers and support personnel, drawing on their extensive experience working with database loads and customer use cases, have identified the key areas that will enable you to optimize database performance. This information is available in the MySQL Performance Tuning training course.
As users continue to demand better performance and more functionality from web applications, you need to make sure that your database can keep up. The MySQL Performance Tuning course will teach you how to use the vast array of configuration options, monitoring tools, and techniques employed by MySQL database professionals to keep your applications fast, efficient, and safe.
You can take MySQL Performance Tuning training in the following
formats:
Long before MySQL, DBAs have been using Toad. Toad is short for Tool for Oracle Application Developers and I remember the Oracle DBAs raving about how TOAD made so many things simpler. Now it is many years later and Dell has released TOAD for MySQL.
On the product page we are promised Toad™ for MySQL is a freeware development tool that enables you to quickly and efficiently create and execute queries, automate database object management, and develop SQL code. Toad MySQL provides utilities to compare, extract, and search for objects. The MySQL tool also enables you to record and play back keyboard commands, and transfer data across MySQL databases. The MySQL developer tool increases efficiency by helping you manage projects, import/export data, and administer the database. Sounds pretty good!
But how does it stack up against MySQL …
[Read more]
The recently created Cameroon MySQL User Group in cooperation
with the local Java User Group are happy to announce the
MySQL/Java Tech Day covering both technical areas. This event is
the first event on Java & MySQL in Cameroon and we are very happy
to invite you to come if you are around.
Codership will give sneak preview of the new features and enhancement for the upcoming release 4
Galera Cluster for MariaDB and MySQL is a revolutionary step forward in high availability for web and OpenStack applications and the core component of the MariaDB Enterprise Cluster offering. Galera Cluster provides synchronous, multimaster, active-active clustering for InnoDB. No longer do you have to make trade-offs between data integrity/durability and failover time, nor do you have to accept a performance hit because you need high availability.
Galera Cluster version 3 was released in November 2013, and since then work on next-generation Galera clustering has started. Learn more about Galera Cluster features and benefits from Codership and MariaDB. You will also get an overview on new features and enhancement for the upcoming release 4.
The dates and locations for MariaDB roadshow are:
Helsinki …
[Read more]We are pleased to announce that MySQL Enterprise Monitor 3.0.20 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud in a few weeks. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.
You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.
You will also find the binaries on the Oracle Software Delivery Cloud in a few weeks. Choose "MySQL Database" as the Product Pack and you …
[Read more]
Severalnines primed for even stronger customer growth
Europe’s database ‘anti-startup’ sets big objectives to improve
open source Enterprise IT
London, UK, 26 February 2015 - Severalnines, a database clustering pioneer which helps businesses automate and manage highly available open source SQL and NoSQL database clusters, reported over 100 percent sales growth last year. The growth of its revenue and customer base was fuelled by winning enterprise accounts such as BT, Orange and Cisco. Today, Severalnines serves over 100 enterprise customers and is in use in over 7,000 database deployments by community users.
Severalnines’ flagship ClusterControl platform helps deploy, monitor, manage and scale SQL and NoSQL open source database clusters with cloud providers like AWS and Google, on Openstack, and on-premise deployments. …
[Read more]