…/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock records for… a program is worth a 1000 instructions. Please do this for us. I am sure there are many in this situation…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… have heard that Oracle made the decision not to support MySQL for IBM i any longer. This is certainly understandable. However, there… MySQL for IBM i. It’s a 100% compatible drop-in replacement. Everything works on Zend DBi just as it works on MySQL, with… on MySQL will run identically on Zend DBi with no modification, and vice versa. In addition, Zend DBi will remain compatible with MySQL in…
Comment: Moving Subtrees in Closure Table Hierarchies
May 2, 2012 By 7 Comments
Hi Bill, I’m using the closure table hierarchy to store regions in a database using MySQL and I’m wondering how can I create a unordered list with indentation (for each level) with the datas. I… in html. With the tree traversal, it is easy to do so because you’re “walking the path”. I’m using MySQL, PHP…
Comment: Load management Techniques for MySQL
May 10, 2012 By 3 Comments
Another option for using a dedicated slave is to write all batch jobs to use Gearman MySQL UDF interface to apply update transactions to… better yet, you could use Percona MySQL Cluster to have a dedicated master for all batch job processing and use Gearman Workers to apply updates to this dedicated master, using…
Post: Testing Fusion-io ioDrive - now with driver 3.1
May 7, 2012 By 2 Comments
In my previous post with results for Fusion-io ioDrive we saw some instability in results, I …. So there are results for driver 3.1 (with comparison to previous driver 2.3) Random writes: For random writes there is not… improvement in throughput, in both in quality and absolute value. For response time – in some cases, there is 2x improvement. So…
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
… by default uses 25W (turbo=0). To force full power, I load a driver with turbo=1. I also use “maxperformance” formatting for Virident, which gives less capacity (1.2TB visible for user), but reserves…
Comment: Version 1.0 of Percona Monitoring Plugins Released
April 27, 2012 By 7 Comments
Hi Baron, I see that the pmp-check-mysql-innodb plugin for Nagios leaves a lot of files (e.g. pmp-check-mysql-innodb.1196) in /tmp. Is that a desired feature? Thanks Daysen
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… very frequent cases with performance problems with MySQL is what they happen every so often or … is really time critical process I would not use more than 4 parallel processes heavily writing to…good idea. It also often helps with monopolizing replication thread. For example if I need to delete …
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
….5.23, which comes with bug fixes and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes…, useful when you start all nodes from the same sources (i.e. backup) Ability to pass list of IP addresses for a… from downloads area or from our repositories. For this release we will provides binaries for Ubuntu 12.04, they are coming soon…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… sounds like a potential MySQL bug. Are you sure this is really happening? I would be extremely surprised for such a bug… the tool that disables binary logging at all. Are you using the 2.0 version of this tool? It was completely… version 2.1. Q: qw() as use of () is deprecated That sounds like you’re using an old version of the tool…
