…the RPM Percona-Server-shared-compat package naming issue that could lead to unresolved package …the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password…warning is now returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] …A warning is now returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES … Bug fixed #1169494. Fixed the RPM package dependencies issues. Bug fixed #1186831. Reduced the overhead from …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… service if the active master server has an issue. At Groupon, our standard MySQL database configuration follows this active/passive pattern. There… to outages. Specifically, at Groupon, our servers would be heavily I/O bound after failover as the buffer pool pages were loaded…. wget -q -O – http://master_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… 5.6.11 spent in LRU_scan. I tried to increase innodb_lru_scan_depth …MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues…innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… to 100x slowdown imposed by Helgrind). For this purpose, I have patched mysql-test-run.pl to accept a new option: –helgrind… spin stats join the company of the buffer pool and I/O stats. ==9090== Thread #18: lock order “0xF14460 before 0xF141E0″ violated… future changes that might make the issues not-so-minor. Additionally, I‘d consider backporting and using MySQL 5.5 atomic operation primitives…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I‘ve decided to write some simple steps you can… what you should expect from the system. What I usually look for MySQL is performance in random reads and random writes. Sequential… use 2GB in 128 files (because we already discovered synchronization issue with O_DIRECT). This sounds small but as controller cache is…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… to look at MySQL Assuming I don’t see anything noteworthy here, I‘ll move on to the MySQL server. I mean, …a text file. I‘ll attach this text file to the issue in our CRM system so I (or someone else… know a lot about the I/O subsystem. And by now I know that I should concentrate in certain areas — …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead of double buffering and I…. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it to load IO subsystem very effectively being able to issue many… good performance from O_DIRECT as from buffered mode ? It turns out it is not always the case. I came to this…
Post: Virtualization and IO Modes = Extra Complexity
March 21, 2011 By 12 Comments
…. Calling fsync() at the end of test, Enabled. Using synchronous I/O mode Doing random write test Threads started! Time limit exceeded…. Calling fsync() at the end of test, Enabled. Using synchronous I/O mode Doing random write test Threads started! Time limit exceeded… this ? I did not have a time to research whenever the problem is related to VirtualBox or some configuration issue. Things may…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…, …, etc. And again, that makes a prediction of how many I/O operations there are impossible. Furthermore, this optimization is not needed… are supposed to fix the buffer pool scalability issue. Let’s see how MySQL performance changes for the last workload if we… from commenter I put also results with different innodb_io_capacity for MySQL 5.5.8. It is 500 ( which I used in…
