… two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But at…_open_cache = 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 = 1000 query_cache_size = 0 query_cache_type = 0…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… – Linux kernel net.ipv4.tcp_max_syn_backlog This is size of kernel buffer for all sockets. Default I have on… create a new thread or take one out of the thread cache. From this point on MySQL processes network communication in multiple threads and can benefit from multiple cores but this work done by main thread does…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 23 Comments
… queue for new connections on operating system size to allow MySQL to handle spikes. Although MySQL connections are quite fast compared to many… not served, which means even very short stall in main thread which is accepting connections will cause for some connection attempts… if you’re working with many connections per second is thread_cache which impacts cost of connections dramatically. You want it to…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_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 to… for your threads. Each thread connecting to MySQL server will needs its own buffers. About 256K is allocated at once even if thread is…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql… key_buffer_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=512…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…size = 8M read_buffer_size = 2M query_prealloc_size = 65536 read_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size…
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… growth of Threads_Created variable I boost it higher. The goal 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…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…=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-output = FILE log-slow-queries=/tmp/mysql…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…System needs you also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which can be…pool size choice. You do not want OS to cache what Innodb is caching already. Innodb cache is more efficient compared to OS cache …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…: 4788.59 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: I tested MySQL-5.1….query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table_size=…
