May 21, 2012

Comment: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

hi ~ Ovais Tariq ,do you have dbt-3 Implementation document ?

Post: Benchmarking single-row insert performance on Amazon EC2

InnoDB log flushing, which can cause downward spikes in performance. Other then that, I have also disabled query cache toits not even consistent. While with the table having no secondary indexes, you can see that the insert rate is

Comment: Announcement of Percona XtraDB Cluster 5.5.23

… addresses list feature is a very good idea ! I’d like to know if a feature that will permit to skip some bases (innodb or myisam) in the cluster will be announced soon ? Because actually we have to create another mysql instance to do this and it‘s…

Comment: Testing Fusion-io ioDrive - now with driver 3.1

…: when you configure MySQL, what portion of it resides on the Fusion-IO card? Do you just have your datadir on there? Or is it more complex than that? I’m new to Fusion-IO and I am going to do some testing with a couple of MySQL servers with

Comment: Benchmarking single-row insert performance on Amazon EC2

… higher with this partitioning, however since you‘ll have to look in each of the ten partitions to query one of the indexes. If you keep….net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that it measures query performance too, so if you fail to actually…

Comment: Benchmarking single-row insert performance on Amazon EC2

Interesting results, and well presented. Would you mind sharing the command line you used for your iiBench clients? Also, did you run a test with innodb_flush_log_at_trx_commit = 1?

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

with MySQL 5.5 (Ubuntu Server 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysqlyou use the server instance one time as as a slave, it will do so. In the function is

Comment: Choosing proper innodb_log_file_size

… and DBs are writing to the same physical disk at the same time as you because it is *V*PS. I have had past experience… and shared hosting are unreliable in that context – tuning might work superb today, average tomorrow, and occasionally backfire too.

Post: Announcement of Percona XtraDB Cluster 5.5.23

with bug fixes and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes toyou want to know more how to migrate to XtraDB Cluster, we will be giving a free webinar on June 6th. This is

Comment: Announcement of Percona XtraDB Cluster 5.5.23

Panagiotis, it is supported on level as MyISAM supports Dave, it works like global table lock for MyISAM table. As MyISAM is not transactional there is not much we can do it.