…/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: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other…, 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…
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… have any exemple in one of them) so maybe a query to reorder datas and then put it in an array…
Comment: mysql-proxy, urgh performance and scalability ?
May 13, 2012 By 27 Comments
… have given up on mysqld, and now moving towards mysql-proxy as a solution for production server. was wondering if you can help…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
…. I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first graph… question is how much MySQL can use. In his keynote Mark Callaghan mentioned that Fusion-io cards they use are highly underutilized. With the performance variance we see it is a good question how does it affect MySQL performance…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
Partitioning probably reduces the stress on the insert buffer. Does XtraDB/Percona Server have an option to use more IO for insert buffer merges when the ibuf gets too big?
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
…, this time I use a different server. For this benchmark it is Cisco UCS C250, while for previous results I used HP ProLiant DL380 G6. Second note is, that I use a mode “turbo=1″ for Virident card…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… is not MySQL problem, might be even not problem with your MySQL configuration, queries and …. Here are some specific techniques to use. Do push concurrency too high Many…queries and introducing “sleeps” between them can be a good idea. It also often helps with monopolizing replication thread. For…
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… 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 identically…
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…
