… later. Another way to say “aggregate” is to say “pre-compute.” If you have time-critical queries for your app to… ready to get when needed? This might or might not be aggregation. Denormalize Pre-computing and careful denormalization need to go together. Figure out what other types of data you’ll need in those…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
…? We have, too. As consultants, a lot of times we need to get a quick overview of the whole replication hierarchy… 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute-1.amazonaws.com Version 5.1.43-60.hardy.7… 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute-1.amazonaws.com Version 5.1.43-60.hardy.7…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…, I do not think looking for the secret fomula to compute your possible memory usage is the right approach to this… Server to consume at peak. This can be easily computed by memory needed for OS, File Cache and other applications. For 32bit… be created to accomodate query executions Query Parsing and optimization needs memory. This is usually small to be ignored but certain…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… posts recently asking something like “what’s the formula to compute mysqld’s worst-case maximum memory usage?” Various formulas are… us remember. And at a minimum, most servers these days need to consider the added memory for InnoDB: specifically, the buffer… bunch). My point is there simply is no formula to compute the maximum possible memory usage, and there cannot be because…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… cheaper but they are also easier to use than Mini Computer systems from IBM. Directly attached storage is more simple to… people” – we would hire smartest guy out where who can compute optimal join combination for any 15 way join in their… data store applications, especially for specific needs when for example large amounts of data need to be analyzed which requires large amount…
Comment: To UUID or not to UUID ?
March 14, 2007 By 28 Comments
… compute the hashcode on the client and then lookup that value from an index JUST on the GUID column. Since you need… via name you can totally skip this step and just compute the GUID on the client and then query it from… costs CPU. It’s worth noting though that you can compute about 10k URLs per second on modern hardware. Probably even…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
…management practices covering monitoring, alerting, security and documentation are also needed to insure a successful solution. In other words, no solution… a high-availability setup is special computer architecture designed to improve the availability of a computer service, like a MySQL database.Â…
Comment: Interesting MySQL and PostgreSQL Benchmarks
December 1, 2006 By 20 Comments
… single path over the CPU. We tend to think of computers as serial, but in fact they are highly parallel even… function on some information that’s in main memory. The computer may then be able to optimize the disk read into… parallel execution, it knows more information about what blocks are needed before the disk read is completed. With this extra information…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
… are looking for. First thing which needs to be understand is – cache hit ratio can be computed differently for different engines. For… same time you have some performance critical transaction which frequently needs IO. Well in this case global key hit ratio may… per second (mysqladmin extended -i10 -r is your friend in computing this) while there is no other IO – no matter what…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… per session buffer that is allocated every time it is needed. The problem with the sort buffer comes from the way… used an old PII 350 MHz computer, I think for such CPU bound benchmarks, an old computer is better, if there are… disabled. I also verified that during the whole process, the computer never swapped and I pre-warmed the file cache before…
