One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. …. Introduce Throttling Sometimes even single process overloads system too much in this case throttling by having relatively short queries and introducing…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… IO, the test is done just after a secure erase operation on the card. The card is doing stable 380 MiB… the performance variance we see it is a good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand it better. If you are interested more in…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… from the fact how MySQL‘s Transactions work with DDL, In particular ALTER TABLE. When ALTER TABLE is Performed in many cases it will… is example: SESSION1: mysql> show tables; +——————–+ | Tables_in_dumptest | +——————–+ | A | | B | | C | +——————–+ 3 rows in set (0.00 sec) mysql> select count(*) from A… cost of having database read only for the duration of operation. You can also use Percona Xtrabackup, LVM or other database…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… or downtime. As you know, MySQL locks tables for most ALTER operations, but pt-online-schema-change performs the ALTER without any locking… to forecast scalability and performance The new Percona Toolkit release is available for download today. It is also in our YUM and… code from Launchpad, and file bug reports on Launchpad. PS: in addition to Percona Toolkit’s release today, there is also…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… you wish to join together in an equi-join, then the way hash join algorithm will operate is that first a hash… for the best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, but you need to appropriately increase read_rnd_buffer_size/mrr_buffer_size because these have an impact on MRR performance…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t always great in comparison to what… not demand much I/O, either in operations per second or in throughput. If you require many operations per second, then it is likely… is that there is not a huge performance difference between EC2+EBS+MySQL versus RDS, in most cases, unless you use Percona Server…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… ? If yes this could cause problems with replication lag (and performance in general). Typical problems for replication include setting sync_binlog=1…. Same may happen with operating system and other system software involved. In could be even system which queries mysql. I’ve seen monitoring…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
…. As Vadim points out in this and this whitepapers you can get a lot better performance with multiple MySQL instances on powerful storage… MySQL and Oracle deployments, yet as MySQL is getting better and better handling large scale systems (both in terms of performance and operationally) and as MySQL…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… Thinking Clearly About Performance by Cary Millsap. So how we can use this data to estimate capacity of MySQL system ? We can… to estimated (or benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data… time per query is 5ms; it is requiring in average 0.54 read operation per second which takes 4ms which adds up…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
…MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance…
