… is simple – because SQL_NO_CACHE only bypasses query cache but it has no change on other caches, which are MySQL Caches – Innodb Buffer Pool and… to clean MySQL table cache (but not Innodb table meta data) or you can do “set global key_buffer_size=0; set global key_buffer_size=DEFAULT…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…not be in date_id order’; /*!40101 SET character_set…query response times and throughput. Setting up a cluster using the AMI images You can easily test Shard-Query…cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… MySQL Settings are probably what is the most interesting: MySQL…size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql… be faster. query_cache_size = 0M – query cache disabled. Not a big …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask… is not to have threads created in normal operation. query_cache_size If your application is read intensive and you do not have application level caches this can be great help. Do not set it…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…_size, innodb_log_buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL… swapping – not what you would like to see. Monitor how the value changes so you know memory requirements with current settings and…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…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…not during mkfs. This is your best option if you have a proper alignment in partition table but you did not set…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…cache experiements and has compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark to compare full full stack, cached or not…sets are cached from query cache. Pretty impressive. So what my recommendations would be about using these caches for your application ? Cache…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…queries‘ execution plan (which includes things like whether Query cache was used or not…query. The tmp table size needed per query is 270.35k, which is not much considering the fact that tmp_tbl_size variable is set…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… MySQL common sense however does not always works – we’ve seen performance issues with large query_cache_size also sort_buffer_size and read_buffer_size may not… cache size. The next step for me was to see if the problem was fixed in MySQL 5.1 – in this version table_cache… has a very similar task of managing its own cache of file descriptors (set by innodb_open_files) As the time allows…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… , to disable flushing of neighborhood pages (not available in MySQL 5.5.8). The problem with…’s see how MySQL performance changes for the last workload if we set innodb_buffer_pool… max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock (post edited…
