… 20000 concurrent users (2Mhz CPU, 2Gb RAM, 20kb static HTML, mem-cache, keep-alive, …). Can MySQL back-end support 20000 concurrent users…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 116 Comments
….0% si Mem: 8165752k total, 8077196k used, 88556k free, 493192k buffers Swap: 4096532k total, 276k used, 4096256k free, 6326856k cached PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND 11395 mysql…_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M log_queries_not_using_indexes = On…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…: specifically, the buffer pool. (There’s also an innodb_additional_mem_pool_size but it’s typically set pretty small, like… front in one call. And what about the query cache and the table cache and the size needed for each thread (thread… usually calculate the Big Ones like the buffer pool, query cache etc; leave some memory for other needs; and see what…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…:259 ‘Aborted_clients’, ’267108′ ‘Aborted_connects’, ’25997′ ‘Binlog_cache_disk_use’, ’145′ ‘Binlog_cache_use’, ’9638599′ ‘Bytes_received’, ’2671219831′ ‘Bytes_sent’, ’2416986544… used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache=512 # Default 64 was used…_size=8M # Lowered from 32M according to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… queries to the database, but the thing is that the cache is not up to date as we would due to… computer’s memory innodb_buffer_pool_size=4G innodb_additional_mem_pool_size=20M # Set the log file size to about…]# free -m total used free shared buffers cached Mem: 7175 7158 17 0 47 1818 -/+ buffers/cache: 5292 1882 Swap: 0 0 0…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual innodb_additional_mem_pool_sizeblogpercona.commanual …cache_hitsblogpercona.commanual Ssl_session_cache_missesblogpercona.commanual Ssl_session_cache_modeblogpercona.commanual Ssl_session_cache_overflowsblogpercona.commanual Ssl_session_cache_sizeblogpercona.commanual Ssl_session_cache…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… indexes, data size and workload – remember MyISAM uses OS cache to cache the data so you need to leave memory for it… you might find better use for memory available. innodb_additional_mem_pool_size This one does not really affect performance too… expensive, especially if you do not have Battery backed up cache. Many applications, especially those moved from MyISAM tables are OK…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… cx16 xtpr lahf_lm bogomips : 4788.59 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual…] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb…_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…_rnd_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size… innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size = 1600M innodb_log… buffer because allocating it will likely be faster. query_cache_size = 0M – query cache disabled. Not a big surprise though as this…
Comment: Choosing innodb_buffer_pool_size
September 24, 2010 By 38 Comments
… have set normal configuration in ini with query_cache=64mb and innodb_additional_mem_pool_size 16M innodb_flush_log_at_trx…_heap_table_size 64M max_allowed_packet 16M query_cache_limit 2M query_cache_min_res_unit slave_net_timeout innodb_data… seconds instead of 15 seconds. so i set again query_Cache=64M. Can any body suggest me to adjust the configuration…
