Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 17831 10 Older Entries

Displaying posts with tag: mysql (reset)

CPU governor performance
+1 Vote Up -0Vote Down

In this blog, we’ll examine how CPU governor performance affects MySQL.

It’s been a while since we looked into CPU governors and with the new Intel CPUs and new Linux distros, I wanted to check how CPU governors affect MySQL performance.

Before jumping to results, let’s review what drivers manage CPU frequency. Traditionally, the default driver was “acpi-cpufreq”, but for the recent Intel CPUs and new Linux kernel it was changed to “intel_pstate”.

To check what driver is being used, run the command

cpupower frequency-info

 .

cpupower frequency-info
analyzing CPU 0:
driver: …
  [Read more...]
smartctl and Samsung 850 EVO
+0 Vote Up -0Vote Down

I have 3 small servers at home for performance testing. Each is an Intel NUC with 8G of RAM and a core i3 via 5i3RYH.  These work quietly under my desk. I have been collecting results for MongoDB and MySQL to understand storage engine performance and efficiency. I use them for single-threaded workloads to learn when storage engines sacrifice too much performance at low concurrency to make things better at high concurrency.

  [Read more...]
London in May 2016
+0 Vote Up -0Vote Down

I’m happy to be back in London in May 2016, to talk at two events:

  1. The London MySQL Meetup GroupMonday May 9 – 6.30 PM – 9.00 PM – options for High Availability in the ecosystem that one would consider today. This is a cut down from my Percona Live tutorial, which had about 88 registered attendees and about that amount showed up and asked questions even through the break and after. I had a lot of fun, and I expect I will have similar fun in London talking about this area that has changed a lot in …
  [Read more...]
My top author list for Planet MySQL
+0 Vote Up -0Vote Down

Who are the top individual authors of influential recent posts to planet MySQL?  The planet MySQL page includes a list of the top 20 authors as well as a list of the top 10 vendor blogs.  However, since posts to the vendor blogs make up at least 1/4 of all of the posts, and the authors of vendor blog posts are not included in the top author list, I decided to compute my own top author list.  I include the hidden authors from the vendor blogs when computing my top author list.

The first problem is to identify the hidden authors for posts from each vendor blog.  This requires that the author information be extracted …

  [Read more...]
Video of my Percona Live Talk: Why would I run MySQL/MariaDB on POWER anyway?
+0 Vote Up -0Vote Down

Good news everyone! There’s video up for the talk I gave at Percona Live in April 2016 up: Why would I run MySQL/MariaDB on POWER anyway?

The talk is a general overview of POWER and why MySQL/MariaDB may be a good fit.

InnoDB flushing and Linux I/O
+0 Vote Up -0Vote Down

Since documentation is not very clear to me on the topic of InnoDB flushing in combination with Linux IO (specifically the write system call), I decided to put together this article in hopes of shedding some light on the matter.

How Linux does I/O

By default, the write() system call returns after all data has been copied from the user space file descriptor into the kernel space buffers. There is no guarantee that data has actually reached the physical storage.

The fsync() call is our friend here. This will …

  [Read more...]
How to Deal with MetaData Lock
+1 Vote Up -0Vote Down

What is MetaData Lock?

MySQL uses metadata locking to manage concurrent access to database objects, and to ensure data consistency when performing modifications to the schema: DDL operations. Metadata locking applies not just to tables, but also to schemas and stored programs (procedures, functions, triggers, and scheduled events).

In this post I am going to cover metadata locks on tables and triggers, that are usually seen by DBAs during regular operations/maintenance.

Kindly refer to these 4 different connections to MySQL Instance:

 

The screenshot shows that the uncommitted transaction may cause metadata lock …

  [Read more...]
Percona Server 5.7: multi-threaded LRU flushing
+0 Vote Up -0Vote Down

In this blog post, we’ll discuss how to use multi-threaded LRU flushing to prevent bottlenecks in MySQL.

In the previous post, we saw that InnoDB 5.7 performs a lot of single-page LRU flushes, which in turn are serialized by the shared doublewrite buffer. Based on our 5.6 experience we have decided to attack the single-page flush issue first.

Let’s start with describing a single-page flush. If the working set of a database instance is bigger than the available buffer pool, existing data pages will have to be evicted or flushed (and then evicted) to make …

  [Read more...]
Docker for Mac beta and MySQL - First impressions
+2 Vote Up -0Vote Down

Using Docker for development is a great way of ensuring that what you develop will be the same that you deploy in production. This is true for almost everything. If you develop on Linux, the above statement holds. If you develop on a different operating system (OSX or Windows) there are several restrictions.

I showed one of those issues in a recent article (MySQL and Docker on a Mac: networking oddity.) When you want to export a port from a service running in the container, the …

  [Read more...]
How VividCortex Uses the New Generated Virtual Columns Feature in MySQL
+1 Vote Up -0Vote Down

In an industry as fast-growing and interconnected as database technology’s, it’s exciting to track how innovations in one platform can ignite beneficial, rippling effects on other, surrounding systems. At VividCortex we frequently find ourselves faced with opportunities to improve our monitoring solutions based on how database technologies (such as MySQL, Redis, PostgreSQL, etc) develop and integrate new upgrades.

When those platforms that we monitor -- already powerful, tried and true -- equip themselves with new features, we work to discover how VividCortex can leverage those features and make our own …

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

Planet MySQL © 1995, 2016, 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.