… innodb_read_views_memory and innodb_descriptors_memory status variables in … where an unprivileged MySQL account owner could perform brute-force password …MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
…, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson…table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL… at Portland State University’s Smith Memorial Student Union, located at 1825 SW Broadway…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance… sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… everything EXCEPT a specified set of databases and tables. With this method, every event is still written …trouble is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s …ever want to use MySQL on top of something like that? I can’t imagine the performance being all …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be…MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be…MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… download from our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of… it will still replicate in case DROP TABLE statement is used on a temporary table. Bug fixed #1084702 (Seppo Jaakola). In case… #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would lead to memory corruption and server crash…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… it with by fsyncing to memory (Battery or capacitor-backed write…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL… on performance, only a upper bound. The best performance you…separate tables and there also exists a users_groups table to define…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack… that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls…is a hash table. A small fc_limit does however keep the certification index smaller in memory. It keeps …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL… available buffer pool memory but still fits into…mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
