…may sound counter-intuitive at first: how would synchronous replication get behind? …single node writing in PXC to perform better. gcs.fc_factor If …on your cluster. The cost of increasing the fc_limit Keeping the … the certification index smaller in memory. It keeps the certification interval small…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
One common question I guess is how much should I see performance improved in case I increase memory say from 16GB to 32GB. The… hot latches and performance go down. Now back to original question – how do we predict the benefit from increasing the memory and so cache… not expect to gain much by increasing the memory. This however have to be watched carefully. Performance does not always stays the same…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…. Running small queries might only barely increase memory consumption for given thread, however if table will perform complex operations such as full table… get in practice and how memory consumption reacts to changing various variables. For example you may find out increasing sort_buffer_size from…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…where you need to know exactly how much memory the mysqld server (or any other program) … sharp memory increase after executing a particular query. Or, maybe mysqld is seemingly using too much memory overall…’ll likely find that the default options will perform well in most scenario’s. For the …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… a challenge faced by almost everyone how do you maintain your performance in the face of increasing data size? Here is where people… a challenge faced by almost everyone how do you maintain your performance in the face of increasing data size? Here is where people… data in memory. let’s look at the 1GB Setting: What, a performance regression? But we threw more memory at it!! How can that…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… in-memory. Benchmark on IO bound workload was performed with a buffer pool size of 1G, while benchmark on in-memory workload was performed… then see how the joins perform for each test case. Test Case A – Join a small table that fits in memory to a… BKA increases, as there are going to be a lot more random index lookups needed to be performed because of the increase in…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…it causing problems every so often. Q16: How Innodb decided how many pages to flush at each …patch that makes InnoDB’s flushes smoother and increase performance substantially. I assume there is lots of room…buying 40 8-core boxes with 32G of memory. Have any specific thoughts here? INNODB was …
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
…). This comes from the fact that MySQL performs changes in memory at a faster rate than it can…’s general recommendation for this case is to increase innodb_io_capacity and decrease innodb_max_…as a result of how it works, instead of performing 1 random write, InnoDB will perform 8 random writes. …
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
…. Efficient memory allocator should help to improve scalability, increase throughput and keep memory footprint under the control. In this post I’m going to check impact of several memory allocators on the performance… on charts below you will see how mysqld footprint is changed during…
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
… data quick do it on decent hardware. Especially memory size is important. If you need database on…_size increase. Innodb typically needs large innodb_buffer_pool_size and large innodb_log_file_size to perform… -sh” in the database data directory to see how much data is loaded per hour (assuming your…
