… zones and ZFS and this provides a very low virtualization overhead. I learned quite a lot about these technologies while looking… few slave instances each of production database servers and will perform the backups. The write load is not excessive so a… is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption…for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699…dependencies issues. Bug fixed #1186831. Reduced the overhead from the Handle Corrupted Tables check as…
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 … without 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
… on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and… automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… – see profile below: # Overhead Samples Command Shared Object # …….. ………. ……. ………………. …MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… transaction. Why is that a major problem for MySQL scalability? The scan is performed under kernel_mutex (or trx_sys->mutex in… scalability is the same as in the previous benchmark. The overhead of maintaining the descriptors array is negligible as compared to… the alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and… automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
….g. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but nothing unexpected. So… in read-only transactions, start suffering from the trx_list overhead created by concurrent updates. Once we step away from this…_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and…
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: Why MySQL Performance at Low Concurrency is Important
March 31, 2013 By 8 Comments
…/mysql-56-single-threaded-read-only.html. All of the conclusions assume a benchmark with fast (100 to 200 usecs) queries: * performance_schema overhead is too high for benchmarks * innodb_checksum_algorithm=CRC32 is…
