… it works on MySQL, with no need to rewrite applications, management scripts, or anything else. There is no difference in query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run… on the IBM i platform. We think that Zend DBi will be a great service to IBM i MySQL users who want…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… will try synchronous IO varying amount of threads and with measurements every 1 sec to see how bad are drops. So there… draw boxplots, which show 25-50-75 percentiles. So there is no grow in throughput after 2 threads, and the result averages… SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It will be the same as my talk…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… triggers?) About cleanup.. What about manual aborting a run. will that cleanup ? Q: dose the tool exit gracefully … temporary table or triggers. It is designed to be resumable, although we don’t yet have a “… in the server and the tool, so there is no code in the tool that disables binary logging …
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… after the part on which range condition is applied cannot be used for filtering records. For example, suppose you have a…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
…. Client applications can continue reading and writing the table with no interruption. With this new version of the tool, one of… user, but the benefit is that in the future we will be able to add features to these tools rapidly, for example… and there will be many talks about various parts of the toolkit: A 3-hour tutorial about the toolkit on Tuesday Daniel will talk…
Post: High Availability Deep Dive tutorial at PLMCE
April 6, 2012 By Leave a Comment
… availability solution with MySQL, Florian Haas from and myself myself will be co-presenting next Tuesday a tutorial on the topic. It… advance information which you will find useful. As our tutorial is going to be highly interactive, every attendee will have the opportunity to… show up early then that will be no problem. At least one of us should be there by 8:45 at the latest. See you there!
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
….6, when the workload fits entirely in memory, because there is no extra cost for memory access at random locations versus memory… fit in the buffer the more sequential the access pattern will be. There is one MRR related variable introduced in MySQL 5.6… it here, but will cover it in my next post which will be on Block Access Join Algorithms. Conclusion There is a huge speedup…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… increase amount of resources prepared statements take on server. There is no comparable variables of how many user variables are allocated (and… per connection and they will be gone when connection is closed, other correspond to global memory allocation and will result in increased memory…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and… does not show reliable latency though, as it appears there is no a reliable way in the Linux asynchronous IO library to… SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It will be the same as my talk…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…Cluster and Galera will be a big topic on coming MySQL User Conference, both Codership and Percona development team will be there, you will have a…with databases created in MySQL / Percona Server Application compatibility. There is no or minimal application changes required to start work with Percona…
