….59 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: I tested MySQL-5.1.30…_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…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…thread_stack= 150M key_buffer = 256M key_buffer_size = 256M myisam_sort_buffer_size = 16M join_buffer_size = 64M read_buffer_size = 16M sort_buffer_size…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…benchwork/benchmarks/sysbench/bin/sysbench –num-threads 1 –max-requests 0 –max-time 300 –thread-stack-size 32K –init-rng on –…auto –mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim/benchwork/var/mysql_benchwork.sock –mysql-user user –mysql-password –mysql-db sbtest –mysql-…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…_size = 64M thread_cache_size = 80 query_cache_size = 32M thread_concurrency = 8 query_cache_type = 1 query_cache_limit = 32M thread_stack=256K myisam_data_pointer_size=6 net_buffer_length = 8K log-slow-queries=/var/lib/mysql/astdb01.as.osti…
Comment: FreeBSD tests
August 4, 2006 By 15 Comments
… I used next configs: –port=3306 \ –socket=/tmp/mysql.sock \ –user=root $LOGERR \ –datadir=$FSPATH \ –basedir=$BASEPATH \ …size=1M \ –max_heap_table_size=64M \ –sort_buffer_size=64K \ –join_buffer_size=1M \ –thread_cache=16 \ –thread_concurrency=16 \ –thread_stack=196K \ –query_cache_size…
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
… key_buffer_size = 32M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 64 query_cache_limit = 0 #query_cache_size = 64M query_cache_size = 0 query_cache_type = 0 join_buffer_size = 512K log_slow_queries = /usr/mysql/logs/mysql-slow.log
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
…this as equivalent to the number of threads inside InnoDB, or to the Threads_running SHOW STATUS counter, without much…stalls to quite severe stalls as I/O requests stack up and other things block against them. If …that size, you might cause a lot of I/O, and there is a chance that will cause MySQL to…
Comment: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…connections*(thread_stack + join_buffer_size + sort_buffer_size + binlog_cache_size…) is so much misleading. In particular, the join_buffer_size, sort_buffer_size are …better to stick with realistic approximations, and hope to allocate MySQL a little *less* than you would usually allow for, …
Comment: Using MyISAM in production
July 6, 2006 By 36 Comments
…environment by stressing application and mysql. Here is the stack trace 0x808d903 handle_segfault +…one_connection + 615 0x82e654c pthread_start_thread + 220 0x830fe0a thread_start + 4 We looked at…| query_cache_min_res_unit | 4096 | | query_cache_size | 524288000 | | query_cache_type | ON | | query_…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…look from the top of the stack. If you look at MySQL log you may find some queries… For small and medium size applications you can log all requests to MySQL table for larger ones …times – mysql, memcache, sphinx, web services etc. For web applications doing processing in a single thread the following…
