… doublewrite) 64 around 13000 16 around 12000 4 around 6000 — mysql-5.6-dev (doublewrite) 64 around 16000 16 around 12000 4 around 5500 mysql-5.6-dev (wo doublewrite) 64 around 20000 16 around… as 2x times 
) * I added these settings for this workload-hardware innodb_io_capacity = 20000 innodb_io_capacity_max = 100000 innodb…
Comment: MySQL and Percona Server in LinkBench benchmark
May 11, 2013 By 18 Comments
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
… that I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a master/slave. I… write 100,000 queries in about 50-60 seconds to mysql 5.1 and in about 6-9 seconds on mariadb…=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1.67-1.el6_3.x86_64 MariaDB-server…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… let me start pointing out common causes of replication lag Hardware Faults Hardware faults may cause reduced performance causing replication to lag… serve performance degradation. Configuration Changes Have you changed MySQL configuration ? OS Configuration or Hardware configuration or could have anyone changed it without…
Post: Speaking at Percona Live London 2012: Choosing Hardware for MySQL
November 19, 2012 By 4 Comments
…. This year, I will talk about ‘Choosing Hardware For MySQL‘. Of course, the most important hardware components will be covered: CPU, Memory, Network… how MySQL uses hardware (and how it does not), how it optimizes random IO operations on disk, what scalability means for MySQL, what…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… right decision. Second is the configuration issue – which can be hardware configuration such as redundant network paths, STONITH, as well as… production… and by that time you will likely have your hardware, MySQL server, HA solution server all changed and you might need…. This is not only the case though – there are many hardware failure and misconfiguration scenarios which can result in performance problem…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… of this discussion we will diminish it to workload and hardware specific constant. For example we can use factor of 0… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S… easily understand what kind of hardware will take you to reach appropriate performance, what kind of hardware provides better balance of CPU…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… getting any significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5 should be rather… fine. Q: What are the key concerns upgrading MySQL 4.1 to MySQL 5.5? This is jumping over 2 Major versions…. It also can be used for testing if hardware if there is little extra hardware available. If you’re doing performance testing…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
…MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL…SuSE. Another such case can be related to hardware. Any newly released component may simply lack …
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… setup a small Arch Linux ARMv6-based hardware device which runs Percona Server for MySQL, in a space not much bigger than… & NTSC) connector. Once you have your hardware, here is how to get Percona Server for MySQL up and running: Insert the SD… mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… “better” hardware. It is best if you can isolate the problem to one of these – make sure changing only MySQL version on the same hardware with same settings causes regression. You can always… it without side load. Setting up 2 MySQL Servers side by side (for example with MySQL Sandbox) can especially be helpful. Once…
