OOM relation to vm.swappiness=0 in new kernel
I have recently been involved in diagnosing the reasons behind OOM invocation that would kill the MySQL server process. Of course these servers were primarily running MySQL. As such the MySQL server process was the one with the largest amount of memory allocated. But the strange thing was that in all the cases, there was no swapping activity seen and there were enough pages in the page cache. Iron
Percona Toolkit collection: pt-visual-explain
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Profiling MySQL Memory Usage With Valgrind Massif
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Download insightful MySQL presentations from Percona Live London 2013
The MySQL community came together last month for two days of outstanding technical tutorials and sessions at Percona Live London. And now many of those MySQL presentations are available for free download. This year’s London conference saw a 20 percent spike in attendance compared with last year, with MySQL professionals from 31 countries gathering in the U.K. capital for compelling keynotes (inclu
Introducing Percona Cloud Tools for MySQL
I am proud to announce Percona Cloud Tools, the next generation of tools for MySQL. I have been developing tools for MySQL for 10 years. For the last 5 years, I have been developing Percona Toolkit (formerly “Maatkit”). Almost 1 year ago, we began developing Percona Cloud Tools (PCT), first in-house, then in private beta, and now in public beta. Here is the TL;DR: Percona Cloud Tools is a web s
A closer look at Percona Server 5.6
Yesterday we announced the GA release of Percona Server 5.6, the latest release of our enhanced, drop-in replacement for MySQL. Percona Server 5.6 is the best free MySQL alternative for demanding applications. Our third major release, Percona Server 5.6 offers all the improvements found in MySQL 5.6 Community Edition plus scalability, availability, backup, and security features some of which are f
Considering TokuDB as an engine for timeseries data
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Enabling crash-safe slaves with MySQL 5.6
Being able to configure slaves to be crash-safe is one of the major improvements of MySQL 5.6 with regards to replication. However we noticed confusion on how to enable this feature correctly, so let’s clarify how it should be done. In short1. Stop MySQL on slave 2. Add relay_log_info_repository = TABLE and relay_log_recovery = ON in my.cnf 3. Restart MySQL and relax The detailsTo fully understand
Percona Monitoring Plugins 1.0.4 release: Now with Galera graphs
Percona is glad to announce the release of Percona Monitoring Plugins 1.0.4. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts. Changelog: * Added Galera/MySQL Monitoring Template for Cacti * Added “Disk Read/Write Time per IO Request (ms)” graph * Added “MySQL InnoDB Buffer
Benchmarking Percona Server TokuDB vs InnoDB
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Rotating MySQL Slow Logs Safely
This blog post is part two of two. Like part one, published Wednesday, this is a cross-post from Groupon’s engineering blog. Thanks again to Kyle Oppenheim at Groupon. In my last post, I described a solution for keeping the caches of a MySQL standby server hot using MySQL slow logs with long_query_time set to 0. Here are a some lessons we learned when logging a high volume of queries to the slow l
Actively monitoring replication connectivity with MySQL's heartbeat
Until MySQL 5.5 the only variable used to identify a network connectivity problem between Master and Slave was slave-net-timeout. This variable specifies the number of seconds to wait for more Binary Logs events from the master before abort the connection and establish it again. With a default value of 3600 this has been a historically bad configured variable and stalled connections or high latenc
Zero-Downtime Schema Changes In MySQL
The recording of yesterday’s webinar, as well as a PDF of my slide deck, is now available. You can watch the recording and get the slides here. I got a lot of questions, and did not have enough time to answer all of them, so let me try to answer some of the remaining questions here. Q: Isn’t it possible to take all the locks required in the beginning to prevent dead locks? So you would get a lock
How to Monitor MySQL with Percona's Nagios Plugins
In this post, I’ll cover the new MySQL monitoring plugins we created for Nagios, and explain their features and intended purpose. I want to add a little context. What problem were we trying to solve with these plugins? Why yet another set of MySQL monitoring plugins? The typical problem with Nagios monitoring (and indeed with most other monitoring systems) is the alert spam. I’ve spoken to a lot o
MySQL Performance Blog � What to tune in MySQL Server after installation
My favorite question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many people fail to provide any reasonable answer to this question, and how many servers are where in wild which are running with d
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
