Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 34577 10 Older Entries
Efficient Use of Indexes in MySQL
+0 Vote Up -0Vote Down

The slides of “Efficient Use of Indexes in MySQL” talk we delivered on SFMySQL Meetup.

This is an introductory talk for developers on MySQL indexes. In my opinion it’s quite important to understand how InnoDB organizes data. If you know how MySQL accesses data it’s easier to write optimal queries.

When working with queries I imagine secondary indexes as a table with records sorted by secondary key fields. This is a powerful concept that helps to understand MySQL logic. It’s also easy to understand complex optimizations like …

  [Read more...]
SHOW ENGINE INNODB MUTEX is back!
Employee +1 Vote Up -0Vote Down

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!

Business-critical MySQL with DR in vCloud Air
+0 Vote Up -0Vote Down

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

Become a MySQL DBA blog series - Common operations - Schema Changes
+0 Vote Up -0Vote Down

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.  …

  [Read more...]
Comments = Sanity
+0 Vote Up -0Vote Down

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 …

  [Read more...]
Free Webinar! 5 Ways to Reduce Database Infrastructure Cost
+0 Vote Up -0Vote Down

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:

  • Evaluating your current efficiency.
  • Determining if there’s an opportunity to lower your database costs.
  • Five simple steps to achieve maximum cost efficiency from your databases: query efficiency, consolidation, reduction of diversity, …
  [Read more...]
Building a Better CREATE USER Command
Employee_Team +1 Vote Up -0Vote Down

Prior to MySQL 5.7, the CREATE USER command had a number of limitations:

  • No way to set both authentication plugin and password
  • No way to disable a user
  • No way to define user resource limitations
  • No way to set a non-default password expiration policy
  • No way to require SSL/x509

All of these things could be done through other means, but typically involved other statements, such as GRANT

  [Read more...]
For the brave: compiling Workbench 6.3 using Visual Studio 2013 on Windows
Employee_Team +2 Vote Up -0Vote Down

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 …

  [Read more...]
UMASK & UMASK_DIR – changing default MySQL file dir permissions
+0 Vote Up -0Vote Down

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.

Percona XtraDB Cluster (PXC): How many nodes do you need?
+0 Vote Up -0Vote Down

A question I often hear when customers want to set up a production PXC cluster is: “How many nodes should we use?”

Three nodes is the most common deployment, but when are more nodes needed? They also ask: “Do we always need to use an even number of nodes?”

This is what we’ll clarify in this post.

This is all about quorum

I explained in a previous post that a quorum vote is held each time one node becomes unreachable. With this vote, the remaining nodes will estimate …

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 34577 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.