We received feedback from a number of users in the MySQL community that the command SHOW ENGINE INNODB MUTEX remains useful in a number of scenarios. We listened, and the command is scheduled to make a return in MySQL 5.7.8.
To lessen overhead, the command will now feature a mechanism to enable and disable metrics collection. This is documented in the manual here:
SET GLOBAL innodb_monitor_enable='latch'; SET GLOBAL innodb_monitor_disable='latch';
Thank you for helping make a better MySQL!
VMware Continuent enables demanding enterprise customers to process billions of business-critical transactions using economical MySQL relational databases. Learn how VMware Continuent adds high-availability, disaster recovery, and real-time data warehouse loading to off-the-shelf MySQL operating in vCloud Air.
We introduce vCloud Air basics, then do a deep dive into the VMware Continuent system
The following new license is now in effect:
SWANHART OPEN LICENSE
Clause #1:
The following companies:
Percona staffing llc, and any associated parent, child or
ancillary entities
May not download, retain, install, operate, or in any way
associate themselves with this software. This is without
exception. Any use must immediately and permanently cease.
Violation of this license will be pursued in a court of
law.
The remainder of the license is normal 3 clause BSD. The above
preamble overrides any relevant clauses in that license with
respect to rights to use the software.
Long live MariaDB!
Database schema changes are not popular among DBAs, not when you are operating production databases and cannot afford to switch off the service during a maintenance window. These are unfortunately frequent and necessary, especially when introducing new features to existing applications.
Schema changes can be performed in different ways, with tradeoffs such as complexity versus performance or availability. For instance, some methods would trigger a full table rewrite which could lead to high server load. This in turn would lead to degraded performance and increased replication lag in master-slave replication setups.
This is the fourth installment in the ‘Become a MySQL DBA’ series, and discusses the different approaches to schema changes in MySQL. Our previous posts in the DBA series include High …
[Read more]A Note On Good Practice
Even though I’ve been developing for some time now it never ceases to amaze me how many people don’t comment in their code. Most of us have fallen into the trap of “the code is self explanatory.” Sure, sometimes it is: if you’re writing “Hello World.” Even that can be questionable at times.
I once interviewed a seasoned developer who, when asked about how they document, replied “I think code should be self documenting.” I wanted to slap my forehead and send them packing right away. Code is never self-documenting. Never. Especially when you go back to it 4 weeks later. And if you think it is self documenting, the poor sap who has to maintain your code doesn’t.
With that said, I would like to make a plea to all non-documenters out there with good reasons on why you want to document.
Why Document? Visual Resting Place
Great …
[Read more]Are your databases more costly than they need to be? If you’re not sure, this webinar will show you how to find out, quickly and easily, with KPIs that indicate overprovisioning or opportunity for driving more efficiency from your databases.
Join us on July 9th at 2 PM EST (6 PM GMT), as Baron discusses database cost reduction. The key topics you’ll learn are:
After this webinar, you’ll understand how to measure, assess, and sometimes lower the cost of your database …
[Read more]
Prior to MySQL 5.7, the CREATE USER command had a number of
limitations:
All of these things could be done through other means, but
typically involved other statements, such as GRANT commands. Starting with MySQL 5.7.6, these can all be done through a
new and improved CREATE USER …
Compiling MySQL Workbench yourself is quite a common task for
Linux users, even though the application is available precompiled
for certain platforms ready from our download page and available
in our yum and apt repositories. In this blog post we show you
how to compile it on Windows.
Introduction
Doing a build on Windows is a totally different matter and most users never need to do that. It’s mostly intersting for those wanting own functionality or just being curious. But you should be an experienced Visual Studio user. It’s a complicated task and not a good start for a beginner. The key problem when building on Windows is that we cannot ship any 3rd party library we used. Instead you have to collect them all yourself. In order to ease that task we created the list below. Each library comes with a version number which usually specifies the minimum version to be used. Most of the time it’s not mandatory to use the exact …
[Read more]UMASK and UMASK_DIR are amongst few MySQL Environment variables which defines directory and file creation modes (file permissions). In this post we will understand using UMASK & UMASK_DIR for changing the database directory and file permissions from it's default to what we need.
The post UMASK & UMASK_DIR – changing default MySQL file dir permissions first appeared on Change Is Inevitable.
#DBHangOps 06/25/15 -- Even More Automation!
Hello everybody!
Join in #DBHangOps this Thursday, June, 25, 2015 at 11:00am pacific (19:00 GMT), to participate in the discussion about:
You can check out the event page at https://plus.google.com/events/c47c6h7c1jgl3ifptev1pnmrf5s on Thursday to participate.
As always, you can still watch the #DBHangOps twitter search, the @DBHangOps twitter feed, or this …
[Read more]