… threads) with fast IO (OCZ R4 1.6TB) and 128GB memory. For the hot test, the data fits in the buffer… working set fits in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11… table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… at http://bugs.percona.com/ key_buffer_size=52428800 read_buffer_size=131072 max_used_connections=13 max_threads=2002 thread_count=6… that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4432877 K bytes of memory Hope that’s ok; if not, decrease some variables in the equation. Thread pointer: 0x7f9234000990 Attempting backtrace. You can use…
Comment: MySQL and Percona Server in LinkBench benchmark
May 15, 2013 By 18 Comments
…’s) driver seems to use main memory as data cache as much as possible. If the free memory is large as buffer pool… throughput might depend on main memory size stronger rather than buffer pool size. We should pay attention also for main memory size of the server.
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… MySQL as if it were using SSD storage or to just use an optimized HDD storage …the working set outstrips the available buffer pool memory but still fits into the cache device, …size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… summary, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and… of free memory but the push to S3 involves a split operation to create files of 5GB since the backup size is… 10am. Fri Mar 22 10:03:22 UTC 2013 procs ———–memory———- —swap– —–io—- –system– —–cpu—– Fri Mar 22 10:03:22…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… safe values ? or can i increase (max_heap_table_size & tmp_table_size) , what values you experts are recomended ? TEMP TABLES Current…_table_size to reduce the number of disk-based temporary tables Note! BLOB and TEXT columns are not allow in memory tables. If you are using these columns raising these values might not impact…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…taken for applications to avoid using Donor/Desynced nodes, particularly when using a blocking SST … the cost of certification depends only the size of the transactions, which translates into …however keep the certification index smaller in memory. It keeps the certification interval small, which…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global buffers, such as innodb_buffer_size… how much memory they use). Memory Tables MEMORY tables can take memory. There are implicit MEMORY tables which are allocated for query execution, which size can be…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… buffers etc all need memory. I would put this to 256M for small sized boxes to 5% of memory size on the big boxes… a bit to be on the safe size and scale appropriately. The third important memory consumer would be OS cache. You want… they usually play on the safe side, having enough “free” memory used as Cache and Buffers. Kevin Burton wrote a good post…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…: “It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections”. This was never true…’s keep going! Any stored code (triggers, stored routines, etc) uses memory to execute; so do temporary tables. The following query creates…… I can also set a bunch of user variables — they use memory too. And they can be really big (but no bigger…
