… = $totalTimeFetch / 1000000; While this benchmark doesn’t show any multi-threading or other advanced operation, it is using identical code to… 0.288257 ms per/cmd 0.2843 ms min per/cmd 0.3026 ms max per/cmd 0.0183 ms range per/cmd InnoDB Memcache….5129 ms max per/cmd 0.0802 ms range per/cmd Keep in mind that the entire data set fits into the buffer pool…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… reads, vCache with time-based flushing consistently hit about 27000 per second, whereas without time-based flushing it averaged about 12500… = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… 16 threads (8 cores on a single socket x 2 threads per socket), while the second one use 16 cores (8 cores per socket per…_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M… = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size…_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… is often less than 1MB per thread with default buffers, and you really do not need to increase per thread buffers unless you have complex queries. Sorting 10 rows will be as fast with 1MB sort buffer as with… is important if you’re deaing with large Blobs (your max_allowed_packet is large) Processing of 256MB of blob may…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… others are effectively a “max size” and the corresponding buffers are allocated only as big as needed (key_buffer_size). There are many… of the buffers that are allocated per-thread (i.e. per-connection), this one is allocated per-join-per-thread, in special cases. A join buffer is allocated…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…max_rwlock_instancesblogpercona.commanual performance_schema_max_table_handlesblogpercona.commanual performance_schema_max_table_instancesblogpercona.commanual performance_schema_max_thread_classesblogpercona.commanual performance_schema_max_thread…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…% dirty buffers and they are hitting their max checkpoint age. The way this increases dirty buffer flushing… controls the amount of dirty page flushing per second (and other background tasks like read-ahead…this too high. innodb_write_io_threads: Controls how many threads will have writes in progress…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… have multiple dedicated purge threads. Percona Server 5.1 supports multiple purge threads too, although using … the relevant my.cnf settings were innodb_buffer_pool_size=16G innodb_log_file_size=…_DIRECT innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table max_connections=…
