MySQL server memory usage troubleshooting tips
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 seeing many issues regularly related to heavy server loads – OR OOM killer got invoked and killed MySQL server due to high Memory usage… OR with a que
MySQL performance optimization: Don't guess! Measure with Percona Cloud Tools
In our practice we often see that MySQL performance optimization is done in a sort of “black magic” way. A common opinion is: “If there is a performance problem – then it must be a database issue, because what else could it be? And if this is a database issue, then it must involve IO problems because the reason for a slow database is always a slow IO…” Following this logic might actually give a r
Percona Server: Thread Pool Improvements for Transactional Workloads
In a previous thread pool post, I mentioned that in Percona Server we used an open source implementation of MariaDB’s thread pool, and enhanced/improved it further. Below I would like to describe some of these improvements for transactional workloads. When we were evaluating MariaDB’s thread pool implementation, we observed that it improves scalability for AUTOCOMMIT statements. However, it does n
LVM read performance during snapshots
For the same customer I am exploring ZFS for backups, the twin server is using regular LVM and XFS. On this twin, I have setup mylvmbackup for a more conservative backup approach. I quickly found some odd behaviors, the backup was taking much longer than what I was expecting. It is not the first time I saw that, but here it was obvious. So I recorded some metrics, bi from vmstat and percent of cow
Benchmarks of Intel 320 SSD 600GB
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Setting up XFS on Hardware RAID -- the simple edition
There are about a gazillion FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options. I wanted to try to put some of that information together in a condensed and simplified format that will work for the majority of use cases. This is not meant to cover every single tuning option, but rather to cover the important bases in a simple and easy to unders
Multiple MySQL instances on Fusion-io ioDrive
It is known that MySQL due internal limitations is not able to utilize all CPU and IO resources available on modern hardware. Idea is to run multiple instances of MySQL to gain better performance on Fusion-io ioDrive card. Full report is available in PDF For tests we used tpcc-mysql package, which generates TPCC-like workload on MySQL systems. Server hardware: Dell PowerEdge R815 Storage: Fusion-i
InnoDB Flushing: Theory and solutions
I mentioned problems with InnoDB flushing in a previous post. Before getting to ideas on a solution, let’s define some terms and take a look into theory. The two most important parameters for InnoDB performance are innodb_buffer_pool_size and innodb_log_file_size. InnoDB works with data in memory, and all changes to data are performed in memory. In order to survive a crash or system failure, InnoD
Innodb row size limitation
Now you insert some test data into it: mysql> INSERT INTO example -> VALUES ( ->Â Â NULL, ->Â Â 'First example', ->Â Â 'First comment', ->Â Â 'First title', ->Â Â 'First subtitle', ->Â Â 'First content', ->Â Â 'First header', ->Â Â 'First footer', ->Â Â 'First disclaimer', ->Â Â 'First copyright', ->Â Â 'First stylesheet', ->Â Â 'First terms' -> ); Query OK, 1 row affected (0.03 sec) A
MySQL on Amazon RDS part 1: insert performance
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see SSD versus EBS death match), and one of them wanted to evaluate RDS as a replacement. It is built on the same technologies, but the hardware and networking are supposed to be dedicated to RDS, not shared with the general us
Sample Datasets for Benchmarking and Testing
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Effect from innodb log block size 4096 bytes
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Write performance on Virident tachIOn card
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Impact of the number of idle connections in MySQL
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
RAID vs SSD vs FusionIO
In benchmarks passion (see my two previous posts) I managed to setup all three devices (RAID was on board; Intel X25-E SSD connected to HighPoint controller, FusionIO card) on our working horse Dell PowerEdge R900 (btw, to do that I had to switch from CentOS 5.2 to Ubuntu 8.10, as CentOS was not able to start with attached SSD card to HighPoint controller) and along with other tests I ran tpcc-lik
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.
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
