… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad… available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it… the RPM package dependencies issues. Bug fixed #1186831. Reduced the overhead from the Handle Corrupted Tables check as it was missing…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… zones and ZFS and this provides a very low virtualization overhead. I learned quite a lot about these technologies while looking… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … PK imposes an additional overhead, and because cluster performance is somewhat dependent on the slowest node – this overhead can easily become visible… is because because synchronous replication inside PXC has an additional overhead, this means the SQL_THREAD will not be able to…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…-30.2 milestone at Launchpad. New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey… automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…MySQL in about 2x times. Both MySQL 5.5.30 and MySQL …perf – see profile below: # Overhead Samples Command Shared Object # …….. ………. ……. ………………. …………………………………………………………………………………………………………………….
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… in read-only transactions, start suffering from the trx_list overhead created by concurrent updates. Once we step away from this… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing… automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… to the following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT… perfect case for read-only optimization in MySQL 5.6 and as you can see MySQL 5.6 shines in this benchmark… scalability is the same as in the previous benchmark. The overhead of maintaining the descriptors array is negligible as compared to…
Comment: Solving INFORMATION_SCHEMA slowness
May 5, 2013 By 25 Comments
Dave005, past versions of MySQL have had many performance complaints about I_S, besides the overhead of InnoDB statistics refresh. You may get some insight by reading the following bug logs: http://bugs.mysql.com/bug.php?id=19588 – reported fixed in MySQL 5.1.21 but many people…
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
… that uses a separate service for a message queue, not MySQL at all. E.g. ActiveMQ, RabbitMQ, Resque, etc. All applications… sets of events in a single transaction to reduce the overhead of the RTT. I was just trying to think of…
