… fast machine with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1.6TB) and 128GB memory…_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size…_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. First, the baseline configuration plus: innodb_read_io_threads = 16 innodb_write_io_threads = 16 We call this configuration B. The next… binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native… binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
….51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression’ => true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached’, $frontendOpts, $memcacheOpts); $timer->start(); for ($i = 0…++) { $obj = $cache->load(“key_$i”); } } $totalTimeFetch = $timer->stop(); $avgTimeFetch = $totalTimeFetch / 1000000; While this benchmark doesn’t show any multi-threading or other…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… a chart with top mutexes for each server at 64 threads: For MySQL 5.5.30 top mutex is &doublewrite->mutex…_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes… Percona Playback added a connection pool option via –dispatcher-plugin-thread-pool that will allow connection reuse. This is necessary when… same chunk again. We expected everything to be cached if we warmed the cache with the exact same data. All the graphs…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… G6 (8cores/16 cpu threads) Cisco UCS C250 (12cores/24 cpu threads) Dell PowerEdge R720 (16 cores/32 cpu threads) All are NUMA… the single-node configuration used 16 threads (8 cores on a single socket x 2 threads per socket), while the second one…_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… show bits/sec (bug 1132900) * Extended “MySQL Threads” graph with all kind of threads (bug 1157911) * Some Cacti single-item graphs were… rebuilt the poller cache under Cacti -> System Utilities. Also the following Cacti graphs need to be recreated: MySQL “MySQL Threads”, Linux “Network…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… the size of the partitions, the whole partition can be cached, as opposed to a single table, where probably only recently read records will be cached, resulting in more disc reads. 2. If you need to… on a partitioned table, as Mysql can fire off one thread per partition (at least I have seen this happen in…
Comment: Why MySQL Performance at Low Concurrency is Important
March 31, 2013 By 8 Comments
… at http://mysqlha.blogspot.com/2013/03/mysql-56-single-threaded-read-only.html. All of the conclusions assume a benchmark… a big win * 5.6 was ~9% slower for a cached database whether or not the PS was disabled
