…=52428800 read_buffer_size=131072 max_used_connections=13 max_threads=2002 thread_count=6 connection_count=6 It is possible that… see no messages after this, something went terribly wrong… stack_bottom = 7f9244a8fdb8 thread_stack 0×40000 /usr/sbin/mysqld(my_print_stacktrace+0×35)[0x7d0765…:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run…_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
…=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0 –num-threads=32 –rand… thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack…_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…constantly referring to the amazing MySQL manual, especially the option and variable reference table. But…startblogpercona.commanual skip_sslblogpercona.commanual skip_stack_traceblogpercona.commanual skip_symbolic_linksblogpercona.commanual skip_thread_priorityblogpercona.commanual slave_compressed_…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… MySQL crashes accessing the wrong memory area, you will even see some stack trace, probably something like this from main thread: stack_bottom = (nil) thread_stack…/sbin/mysqld[0x516a61] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you…
Post: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
… profiler has become a key tool in helping us analyze MySQL when customers are having trouble. We have our own implementation… running server: GDB forklifts the process and gets a stack trace from every thread, then lets it go on working. But this… on big servers with a lot of memory and many threads, it can take much longer (I’ve seen tens of…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… 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…: List of rarely considered MySQL Server Memory Requirements Thread buffers can be allocated more than once for each thread. Consider for example subqueries…
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… table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But at…_in_group = 2 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_io_capacity = 20000 innodb_io_capacity…_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…show up as abnormally high values of Threads_connected or Threads_running. That’s a good place to…makes it easy to gather snapshots of waiting (stack traces) and CPU consumption (oprofile). That’s important… many things that can cause a stall in MySQL, and they usually begin microscopically and get …
