… name “mr unhappy”. The comment did not provide constructive feedback. If you have problem with software – please report bugs to https… answer on questions about XtraDB Cluster in our mailgroup http://groups.google.com/group/percona-discussion
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… provides binaries for Ubuntu 12.04, they are coming soon. If you want to know more how to migrate to XtraDB… release, but this is a software, so bugs are expected. If you encounter them, please report to our bug tracking system….com/downloads/Percona-XtraDB-Cluster/ Documentation Codership Wiki General Discussion group Launchpad project Bug reports
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
…_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size…-26′ group by field1; 14 rows in set (15 min 54.29 sec) Please help to improve performance and suggest if any…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… time-based types, as well as microseconds in SHOW PROCESSLIST Group commit for the binary log makes the server much faster… to this list. For example, Percona Server has the same group commit fix, and MySQL 5.6 offers microsecond timestamp support… pluggable authentication; you just have to pay for the plugin if you want the official Oracle one; or you can use…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… second table. This means many point queries, say for example if table1 yields 1000 rows then 1000 index lookups are performed… means MySQL can employ many other optimizations like for example if columns other then the secondary key columns are required to…_orderdate < '1995-03-09' and l_shipdate > ’1995-03-09′ group by l_orderkey, o_orderdate, o_shippriority order by revenue…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… it brings. Multi Range Read With traditional secondary index lookups, if the columns that are being fetched do not belong to… enough only a single range lookup will be needed, however if the buffer size is small as compared to the combined…’ month) and l_returnflag = ‘R’ and c_nationkey = n_nationkey group by c_custkey, c_name, c_acctbal, c_phone, n…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 2, 2012 By 16 Comments
… Galera one approach is to compare with semisync replication. Even if Galera offers much more than semisync have a look at… green line ist MariaDB 5.5.20 with group commit and xtradb. Even if they are faster. Galere performs awesome and you…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… release, but this is a software, so bugs are expected. If you encounter them, please report to our bug tracking system….com/downloads/Percona-XtraDB-Cluster/ Documentation Codership Wiki General Discussion group Launchpad project Bug reports Previous posts on this topic: Percona…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 12 Comments
….39 sec) This method indeed works great if you have relatively small number of groups which you can fetch on the application… that table instead if amount of groups is much larger). The other idea came to my mind is using GROUP BY WITH ROLLUP… an extra count. So if MySQL does not allow us to use ORDER BY together with GROUP BY WITH ROLLUP can we…
Post: Pretending to fix broken group commit
February 2, 2009 By 11 Comments
…. We wrote also about it before, see “Group commit and real fsync” and “Group commit and XA”. The problem is the InnoDB… data in disk. So what can be wrong if you run –innodb-unsafe-group-commit — as I said there is possibility… urge to use –innodb-unsafe-group-commit, I propose to have BBU on your RAID. But if it appears you don’t…
