… designed to look solely at vCache performance under some different sets of MySQL configuration parameters. For example, given that the front… tried three additional sets of experiments. First, the baseline configuration plus: innodb_read_io_threads = 16 innodb_write_io_threads = 16 We call…_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native… thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack… defaults, as I understand from documentation TokuDB comes with good settings out-of-box, but I am ready to tune something…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…stack_traceblogpercona.commanual skip_symbolic_linksblogpercona.commanual skip_thread…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… innodb-thread-concurrency=0 innodb-thread-concurrency-timer-based innodb-thread-sleep-delay=0 innodb-use-sys-stats-table innodb-write-io-threads=4…-links 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-timeout=86400 To be continued You can now set…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… [Note] WSREP: Start replication 130221 17:59:06 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 130221… see no messages after this, something went terribly wrong… stack_bottom = 0 thread_stack 0×30000 /usr/sbin/mysqld(my_print_stacktrace+0×33)[0×8415893…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… to 6GB, so you have 2GB left for your threads. Each thread connecting to MySQL server will needs its own buffers. About 256K is allocated at once even if thread is idle – they are used by default thread stack, net buffer etc. If transaction is… the value changes so you know memory requirements with current settings and increase/decrease values appropriately. Some may say, Hey we…
Post: Speedup your LAMP stack with LigHTTPD
May 21, 2006 By 14 Comments
… could frequently be bottleneck for your LAMP stack, or you might be wasting resources on …language modules is light, futhermore you may use threaded worker models to keep overhead lower. However …differently. You also may have different routing policies set for these servers – you want Web pages …
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… and the table cache and the size needed for each thread (thread stack, etc)? Those take memory too. The query cache can use… some “global buffers” that aren’t really global. Suppose you set sort_buffer_size to 128K — I can quite well connect…(@a, 1); +—————–+ | get_lock(@a, 1) | +—————–+ | 1 | +—————–+ 1 row in set (3.63 sec) Now I’ve got a 100M user…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… are having any wrong value or we can do some settings Here is mysql configuration (We are having only 1 mysql…-errors = 1062 back_log = 75 # skip-innodb max_connections = 600 #thread_stack= 150M key_buffer = 256M key_buffer_size = 256M myisam_sort… = 65536 query_alloc_block_size = 131072 default-storage-engine = InnoDB #thread_concurrency = 32 innodb_buffer_pool_size = 4096M innodb_lock_wait…
Comment: InnoDB memory allocation, ulimit, and OpenSUSE
August 31, 2010 By 7 Comments
… the binary itself and the shared libraries. Some for the thread stacks. Some for other internal needs of MySQL. Some waste from… add up eventually. The bottom line is that if you set a ulimit on MySQL memory usage, you are likely to… experiment. On a test server (do not try in production), set a ulimit that is barely big enough to make mysqld…
