by Peter Zaitsev | Feb 14, 2007 | Insight for DBAs
I was working with customer today which has MySQL on a system with some 64GB or RAM running MyISAM, so they set key_buffer_size to 16G… and every few days MySQL crashes. Why ? Because key_buffer_size over 4GB in size is not really supported (checked with latest... by Francisco Bordenave | Sep 30, 2020 | Insight for DBAs, MySQL, Storage Engine
In this post, we will discuss what to do when you add more memory to your instance. Adding memory to a server where MySQL is running is common practice when scaling resources. First, Some Context Scaling resources is just adding more resources to your environment, and... by Vadim Tkachenko | Jan 18, 2018 | Insight for DBAs, Insight for Developers, MySQL, Security
In this blog post, we’ll look at does the Meltdown fix affect performance for MySQL on bare metal servers. Since the news about the Meltdown bug, there were a lot of reports on the performance hit from proposed fixes. We have looked at how the fix affects... by Bradley Mickel | Oct 9, 2017 | Insight for DBAs, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source, production-ready, and enterprise-grade MySQL alternative. Learn More In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration... by Alex Poritskiy | Jul 11, 2017 | MySQL, Open Source, Percona Software
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.I was recently working on a high memory usage issue for one of our clients, and made some interesting discoveries: high memory usage with no bounds. It was really... by Peter Zaitsev | May 3, 2016 | MySQL
In this blog post, we’ll discuss some of the best practices for configuring optimal MySQL memory usage. Correctly configuring the use of available memory resources is one of the most important things you have to get right with MySQL for optimal... by Sveta Smirnova | Aug 17, 2015 | Insight for DBAs, MySQL, Percona Software
In MySQL QA Episode #12, “MySQL is Crashing, now what?,” Roel demonstrated how to collect crash-related information that will help Percona discover what the issue is that you are experiencing, and fix it.As a Support Engineer I (Sveta) am very happy... by Nilnandan Joshi | Jan 24, 2014 | Insight for DBAs, MySQL, Percona Services
There are many blog posts already written on topics related to “MySQL server memory usage,” but nevertheless there are some who still get confused when troubleshooting issues associated with memory usage for MySQL. As a Percona support engineer, I’m... by Vadim Tkachenko | Sep 5, 2013 | Benchmarks, MySQL
This post is a continuation of my research of TokuDB’s storage engine to understand if it is suitable for timeseries workloads.While inserting LOAD DATA INFILE into an empty table shows great results for TokuDB, what’s more interesting is seeing some... by Justin Swanhart | May 22, 2013 | Benchmarks, MySQL
This blog post is part two in what is now a continuing series on the Star Schema Benchmark.In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered... by Ernie Souhrada | May 17, 2013 | Benchmarks, Hardware and Storage, MySQL
This is the second part in a two-part series comparing Virident’s vCache to FlashCache. The first part was focused on usability and feature comparison; in this post, we’ll look at some sysbench test results.Disclosure: The research and testing conducted... by Vadim Tkachenko | May 7, 2013 | Benchmarks, MySQL
After compiling Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload (which is TokuDB’s strong suit) with some roll-up... by Vadim Tkachenko | Oct 8, 2012 | Benchmarks, MySQL
MySQL 5.6.7 RC is there, so I decided to test how it performs in tpcc-mysql workload from both performance and stability standpoints. I can’t say that my experience was totally flawless, I bumped into two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL... by Bill Karwin | Aug 24, 2012 | Insight for Developers, MySQL, Percona Events
I presented a webinar this week to give an overview of several Full Text Search solutions and compare their performance. Even if you missed the webinar, you can register for it, and you’ll be emailed a link to the recording.During my webinar, a... by Peter Zaitsev | Mar 21, 2012 | Insight for DBAs, MySQL
One of the most painful troubleshooting tasks with MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable... by Aurimas Mikalauskas | Jun 9, 2011 | MySQL
In the first part of this article I have showed how I align IO, now I want to share results of the benchmark that I have been running to see how much benefit can we get from a proper IO alignment on a 4-disk RAID1+0 with 64k stripe element. I haven’t been... by Baron Schwartz | Jan 8, 2011 | Insight for DBAs, MySQL
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables, or look for content in the Percona documentation or forums. So I present to you what is now my... by Baron Schwartz | Jul 5, 2010 | Insight for DBAs, MySQL
When examining MySQL configuration, we quite often want to know how various buffer sizes are used. This matters because some buffers (sort_buffer_size for example) are allocated to their full size immediately as soon as they are needed, but others are effectively a... by Baron Schwartz | Feb 28, 2010 | Insight for DBAs, MySQL
I have not caused a fist fight in a while, so it’s time to take off the gloves. I claim that somewhere around of 99% of advice about tuning MySQL’s key cache hit ratio is wrong, even when you hear it from experts. There are two major problems with the key... by Baron Schwartz | Feb 12, 2009 | Insight for DBAs
I vaguely recall a couple of blog posts recently asking something like “what’s the formula to compute mysqld’s worst-case maximum memory usage?” Various formulas are in wide use, but none of them is fully correct. Here’s why: you...