…quality. Percona Server has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB …the 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
… about using pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used… event will be held at Portland State University’s Smith Memorial Student Union, located at 1825 SW Broadway, Suite 327/8…… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the working set fits in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version used: 5.6… sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you… to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is still written to the… that trouble is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s starting to…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
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… 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: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…or work around it with by fsyncing to memory (Battery or capacitor-backed write cache), etc… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL … maintained in separate tables and there also exists a users_groups table to define the relationship…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by design… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding…, which is a hash table. A small fc_limit does however keep the certification index smaller in memory. It keeps the certification…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… i converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp table , server has 4G ram, which almost…_heap_table_size to reduce the number of disk-based temporary tables Note! BLOB and TEXT columns are not allow in memory tables. If you are using these columns raising these values might not impact your ratio of on disk temp tables.
