June 19, 2013

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

May 22, 2013 By Leave a Comment

… threads) with fast IO (OCZ R4 1.6TB) and 128GB memory. For the hot test, the data fits in the buffer… in this series. Regardless, when the working set fits in memory, InnoDB almost always performs better, at least for this workload… innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT…

Filed Under: Benchmarks, MySQL Tagged With: , , , , , , ,

Post: Percona Server for MySQL 5.5.31-30.3 now available

May 24, 2013 By Leave a Comment

… quality. Percona Server has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status… the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server…

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

… replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is still written to the… is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s starting to swap…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Comment: Sphinx search performance optimization: attribute-based filters

June 12, 2013 By 11 Comments

… have about 1200 tables each with hundreds of thousands of records, for we use sphinx based on attributes, but memory consumption is…

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: Percona MySQL University @Portland next Monday!

June 12, 2013 By Leave a Comment

… – as well as go into more detail about using pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch… event will be held at Portland State University’s Smith Memorial Student Union, located at 1825 SW Broadway, Suite 327/8…

Filed Under: Events and Announcements, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona MySQL Training, Percona MySQL University, Percona Remote DBA Tagged With: ,

Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE

April 4, 2013 By 17 Comments

…_heap_table_size & tmp_table_size) , what values you experts are recomended ? TEMP TABLES Current max_heap_table_size = 128 M Current tmp_table_size…_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.

Filed Under: Insight for DBAs Tagged With: ,

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

April 24, 2013 By Leave a Comment

… shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost… the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock… scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187 (Alexey Kopytov). Removed trx…

Filed Under: MySQL, Percona Software

Post: Percona Server for MySQL 5.5.30-30.2 now available

April 10, 2013 By 10 Comments

… shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost… the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock… scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187 (Alexey Kopytov). Removed trx…

Filed Under: MySQL

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

April 17, 2013 By 2 Comments

… for download from our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost… it will still replicate in case DROP TABLE statement is used on a temporary table. Bug fixed #1084702 (Seppo Jaakola). In case… were started before running wsrep recovery, this would lead to memory corruption and server crash. Bug fixed #1132974 (Seppo Jaakola). Conflicting…

Filed Under: MySQL, XtraDB Cluster Tagged With: , ,

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

… themselves. When the working set outstrips the available buffer pool memory but still fits into the cache device, vCache shines. Compared… ­­–num­-threads=32 ­­–test=tests/db/oltp.lua ­­–oltp_tables_count=32 \ –oltp­-table­-size=10000000 ­­–rand­-init=on ­­–report­-interval=1…=95 ­­\ –mysql­-user=root –mysql­-socket=/tmp/mysql.sock ­­–mysql­-table­-engine=innodb ­­\ –oltp­-read­-only=off run The base MySQL…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,
« Older Posts