… 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: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…thread and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple purge threads… settings were innodb_buffer_pool_size=16G innodb_log_file_size=1900M innodb_flush_log_at_…_file_per_table max_connections=2000 table_cache=2000 Percona Server 5.1 Results For …
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: 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=…
