… some unique challenge to the database optimizer. The SSB benchmark consists of four …Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1….data is not cached (the cold run) but is slower in the hot (cached) run….open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…threads = 16 innodb_write_io_threads = 16 We call this configuration B. The next one contained four SSD-specific optimizations… time; I’m not entirely sure …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…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… increase 50 to 80 does not make much difference. Systems with…optimizing for higher concurrency workloads. Makes sense as servers have a lot more cores available these days. query_cache_type and query_cache_size… Buffer Pool Size scan resistant by default. Very welcome change ! thread_cache_size is …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…thread_cache_sizeblogpercona.commanual thread_concurrencyblogpercona.commanual thread_handlingblogpercona.commanual thread_stackblogpercona.commanual Threads_cachedblogpercona.commanual Threads_connectedblogpercona.commanual Threads_createdblogpercona.commanual Threads…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Optimal WT, RA PhysiclDev Type State Errors Vendor Model Size ========== ==== ======= ====== ======= ============…cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size…is not aware that it is not aligned…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…not have any indexes (not…optimizer-prune-level=0 partition=ON port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…Com_lock_tables’, ’102′ ‘Com_optimize‘, ’0′ ‘Com_preload_keys’, ’0…prunes’, ’4314′ ‘Qcache_not_cached‘, ’294363493′ ‘Qcache_queries_in_cache‘, ’177′ ‘Qcache_total_…size=32M # Only for MyISAM which isnt used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_size is bigger to help queries that don’t use indexes and that do use some of the new optimizer features. query_cache_size RAM is allocated even if query_cache_type is 0. So useful to… that’s not possible. More on this at https://blogs.oracle.com/supportingmysql/entry/mysql_server_5_6_default . thread_cache_size is quite…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL 2.15 SELinux | No SELinux detected Virtualized … CPU 3.00GHz Caches | 2×2048 KB I have and old table which was not optimized for prolonged period of… 30GB in size including indexes which is way more than buffer pool size and OS cache which is…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… on the server side but I guess something is not as well optimized with them as it could be which makes it…=100 table_cache = 6000 read_rnd_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log… because allocating it will likely be faster. query_cache_size = 0M – query cache disabled. Not a big surprise though as this is default value…
