…/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock records for edit/update, so…
Comment: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
May 21, 2012 By 10 Comments
hi ~ Ovais Tariq ,do you have dbt-3 Implementation document ?
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… index maintenance. This experiment isn’t measuring the cost of index … answer a random query, assuming you can get each index query down to…With a 55GB buffer pool, we would expect the primary table to simply fit. But with…. The correct URL for version you used is http://tokutek.com/downloads/…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
…’s why we don’t use RHEL/CentOS, because they come with generally outdated software and it’s hard to use newer versions or….x (depending what ‘x’ we use then, we’re currently on 3.0). But I agree with you that there’s a difference… can actually get the fix, regardless of whether or not you‘re on a slow track with RHEL or on a faster track with…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… available. You can watch …locks required in the beginning to prevent dead locks? So you would get a lock wait instead of a dead lock…log and thus isn’t replicated, why ? without any replication filters or relevant args, the replication breaks reliably on the __tmp_x table…logging at all. Are you using…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
…use percona server 5.5.20, I would be testing xtradb cluster with three nodes. I went through your documentation provided with…example default_storage_engine, query_cache_size, e.t.c…. Is it something built in or …get paid support from percona, but at-least you can answer this one or provide a link …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… the configuration that I used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4… the table has decreased the insert rate by 3x, and its not even consistent. While with the table having no secondary indexes, you can see…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… you put too heavy of concurrent load on it the response times will increase and user experience will suffer. So what you can… are some specific techniques to use. Do push concurrency too high Many developers will test script with multiple level of concurrency and… queries and introducing “sleeps” between them can be a good idea. It also often helps with monopolizing replication thread. For example if…
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 16, 2012 By 11 Comments
Gilles, you can filter what tables to replicate using regular replication filter i.e. replicate_*, for it does not affect a node propagation. The new node still will copy all databases and instances.
Comment: mysql-proxy, urgh performance and scalability ?
May 13, 2012 By 27 Comments
… server. was wondering if you can help in installation and configuration, tutorials or anything, as i tried installing with percona server and it…
