June 18, 2013

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

March 29, 2013 By 10 Comments

…warmup time when the entire cache is cleared (think restarting a memcache node).  This is where a persistent cache can be invaluable. …Zend_Cache_Backend_Libmemcached Here is the rough code for this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching‘ => true…

Filed Under: MySQL Tagged With: , , , ,

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

… vCache can be declared the clear winner. Base MySQL & Benchmark …innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb…size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 …

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

March 29, 2013 By 10 Comments

… set cache life time as 12hours. Can this apply to the MySQL innodb memcache? i.e. will the cache being delete off innodb table after 12hours or they remain permanent? for doing cache clearing off… a comparison between performance of 5.6 memcached innodb write/read vs 5.6 innodb write/read with no memcached layer? Currently…

Filed Under: MySQL Tagged With: , , , ,

Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

April 2, 2013 By 10 Comments

…, in my mind, the cache settings allow for two distinctly different modes of operation and use cases. ‘innodb_only’ appears to be… same box). ‘caching‘ covers both (although favors traditional mode as it goes to the cache first). The default is ‘innodb_only’ which is… benchmark? based on this, it seems important to have a clear picture why/how you are using these settings related to…

Filed Under: MySQL Tagged With: , , , ,

Post: Virident vCache vs. FlashCache: Part 1

May 16, 2013 By 3 Comments

… InnoDB buffer pool (thus leading to a lot of buffer pool disk reads) but still small enough to fit into the cache… “1″ to the do_sync sysctl of the cache device triggers a cache flush, but it happens in the background, and while… “idle” dirty blocks are cleaned from the cache device. It is not entirely clear whether or not these mechanisms operate in the…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… mysql 98304 Feb 20 16:09 FTS_00000000000000ad_BEING_DELETED_CACHE.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16… global innodb_ft_aux_table=’test/dir_test_innodb‘; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from information_schema.innodb_ft… number of rows in I_S.innodb_ft_index_table is changing, so it’s pretty clear that I do actually have…

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

Post: InnoDB benchmarks

January 3, 2007 By 15 Comments

…-innodb and next startup options were used: libexec/mysqld –no-defaults –user=root –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max-connections=1500 –table-cache=512 Description of… MHz : 1995.004 cache size : 4096 KB 16GB of RAM Disks do no matter, as I ran clear CPU-bound benchmarks. The…

Filed Under: Benchmarks Tagged With: ,

Post: The perils of InnoDB with Debian and startup scripts

January 28, 2009 By 13 Comments

… buffer pool and the OS cache from competing. My chosen strategy for this was to set innodb_flush_method=O_DIRECT. We…. Why is that happening? Look at SHOW INNODB STATUS: ===================================== 090128 8:29:03 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the… chose in this case? mysql> KILL 7; Immediately afterward everything cleared up.

Filed Under: Insight for DBAs Tagged With: ,

Post: A case for MariaDB's Hash Joins

May 31, 2012 By Leave a Comment

…_DIRECT query_cache_size=0 query_cache_type=0 MySQL 5.6.5 Configuration innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size=512M innodb_log… to finish in the IO bound workload. Anyhow we can clearly see from the above chart that Hash join comprehensively beats…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , ,

Post: Aligning IO on a hard disk RAID – the Benchmarks

June 9, 2011 By 13 Comments

…_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files… innodb_write_io_threads = 8 innodb_io_capacity = 200 port = 3306 back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache… I launched the system that I was benchmarking, I could clearly see the difference in production as I had another machine…

Filed Under: MySQL
« Older Posts