…executed on the intermediate server, thus resulting in less binary log data …MySQL and OS-level status variables that you might want to keep an eye on to prevent a problem before it occurs. For example, if you see a large … Or if you watch your MySQL server’s memory usage and you see …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…forced to correct the problem before it can commit….it with by fsyncing to memory (Battery or capacitor-backed …MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL… really will open a large window where rows … join the same group? Results In both of …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…MySQL takes much more memory than you would expect, causing swapping or other problems. This simple problem on the surface becomes challenge with MySQL…MySQL in wild. I also wanted to share some troubleshooting techniques I use. Plot Memory Usage First I would like to see MySQL memory…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…rather large set of applications. Many applications in MySQL have very large …MySQL Query Cache now stores queries in local memory, which is great however memory…fast compression, such as QuickLZ. Results sets for most queries is… the problem for very expensive queries. The good thing about MySQL Query…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… site preparing for massive growth. To make sure it handles large data sets as part of the process we work on… controls memory which passes via PHP memory management which does not apply to MySQL result set. OK there is “easy” fix for this problem, you can use mysql_unbuffered…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… your possible memory usage is the right approach to this problem. The reasons… is rather maximum amount of memory MySQL will allocate for this operation….memory requirements retriving result sets from remove queries. Blobs may require 3x time of memory. This is important if you’re deaing with large…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
… testing on a large data set against two MySQL column-store storage …results of queries over the large data set Speed of results of queries over the large…one query did not have enough memory to complete on InfiniDB. Overall, …I will try to reproduce the problems on InfiniDB into easily reproducible …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…while being employed by MySQL. These are great results, plus they …size to deal with implicit memory tables. innodb_file_per_table …= 1600M – another Benchmark optimization. Such large logs typically will cause …problem for benchmark specs. But what really surises me here is why not ZFS ? The ZFS MySQL…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read only … want results most relevant for your situation. In this example I spotted the query pattern responsible for large…24 real cores. The workload was completely in memory in this test. I have compared Percona Server…
Post: How Much memory do you use to run MySQL
November 2, 2012 By 8 Comments
… of issues with MySQL Server related to amount of memory you have in the system – these range from problems with large size Query Cache to bad drop table performance with large Innodb… when it will be frozen so we do not get results from multiple years mixed.
