All of Percona’s open-source software products, in one place, to download as much or as little as you need.
When Do InnoDB Table Statistics Update?
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
MySQL 5.5 and MySQL 5.6 default variable values differences
mysql [localhost] {msandbox} (test) > select var55.variable_name,left(var55.variable_value,40) value55, left(var56.variable_value,40) var56 from var55 left join var56 on var55.variable_name=var56.variable_name where var55.variable_value!=var56.variable_value; +---------------------------------------------------+------------------------------------------+------------------------------------------+
Disaster: MySQL 5.5 Flushing
We raised topic of problems with flushing in InnoDB several times, some links: InnoDB Flushing theory and solutions MySQL 5.5.8 in search of stability This was not often recurring problem so far, however in my recent experiments, I observe it in very simple sysbench workload on hardware which can be considered as typical nowadays. Hardware: HP ProLiant DL380 G6, with 72GB of RAM and RAID10 on 8 di
Announcing MySQL Monitoring Plugins from Percona
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
EC2/EBS single and RAID volumes IO benchmark
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Understanding MySQL Memory Usage with Performance Schema
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Home
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
How to Recover a Single InnoDB Table from a Full Backup
Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In this particular scenario is faster to recover single tables than a full backup. This is easy with MyISAM but if your tables are InnoDB the process is a little bit different story. With Oracle’s stock MySQL you cannot move your ibd files freely from one server to an
Backing up binary log files with mysqlbinlog
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Configuring MySQL For High Number of Connections per Second
One thing I noticed during the observation was that there were roughly 2,000 new connections to MySQL per second during peak times. This is a high number by any account. When a new connection to MySQL is made, it can go into the back_log, which effectively serves as a queue for new connections on operating system size to allow MySQL to handle spikes. Although MySQL connections are quite fast compa
Getting MySQL Core file on Linux
Core file can be quite helpful to troubleshoot MySQL Crashes yet it is not always easy to get, especially with recent Linux distributions which have security features to prevent core files to be dumped by setuid processes (and MySQL Server is most commonly ran changing user from “root” to “mysql”). Before you embark on enabling core file you should consider two things – disk space and restart time
Real-Life Use Case for "Barracuda" InnoDB File Format
In one of his recent posts Vadim already gave some information about possible benefits from using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could be useful for large warehousing tasks. One of our clients had really many problems with one of his servers. This is pretty powerful server (Intel Xeon E5430 / 8Gb RAM / BBU-enabled R
How to load large files safely into InnoDB with LOAD DATA INFILE
Recently I had a customer ask me about loading two huge files into InnoDB with LOAD DATA INFILE. The goal was to load this data on many servers without putting it into the binary log. While this is generally a fast way to load data (especially if you disable unique key checks and foreign key checks), I recommended against this. There are several problems with the very large transaction caused by t
How to use tcpdump on "Very" Busy Hosts
Tcpdump Packet Loss on Busy ServersOften I run into problems when trying to use mk-query-digest with tcpdump on “very” busy hosts. You might be thinking, “very busy is a relative and unquantifiable term,” and you’d be right, so I’ll phrase this differently. Let me give a little background to the problem first. Mk-query-digest tries to handle dropped or missing packets gracefully, but even so they
SSD: Free space and write performance
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
Percona XtraBackup 1.6.3
Percona Xtrabackup 1.6.2 released!
Maatkit's mk-query-digest filters