… in our query response times and throughput. Setting up a cluster using the AMI images You can easily test Shard-Query for yourself… table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… makes it better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my…_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…
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… key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer pool caches both…. 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…
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… Engine. This may have unbound memory requirements retriving result sets from remove queries. Blobs may require 3x time of memory. This is…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have …16M binlog_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 =…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…Cache Type Cache Gets/sec Array Cache 365000 APC Cache 98000 File Cache 27000 Memcached Cache (TCP/IP) 12200 MySQL Query Cache (TCP/IP) 9900 MySQL Query Cache…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
… the right query in the right way. But vanilla MySQL does have its…information about the queries‘ execution plan (which includes things like whether Query cache was used…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: Query Profiling with MySQL: Bypassing caches
September 12, 2007 By 6 Comments
… 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… 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: 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… 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
… scalability issue. Let’s see how MySQL performance changes for the last workload if we set innodb_buffer_pool_instances=8 or…=/var/lib/mysql/mysql.sock skip-grant-tables server_id=1 local_infile=1 datadir=/mnt/fio320 innodb_buffer_pool_size=24G innodb…_io_capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock (post edited by Fred Linhoss…
