… nothing wrong with a virtual-machine approach, but for the optimal production deployment you want two identical physical boxes with at… that trouble is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s starting to swap…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…memory profile slowly growing overtime, indicating a possible memory bug. Whatever the reason, there is a simple but powerful way to profile MySQL memory usage… ‘GA’ [generally available] packages may contain optimized or stripped binaries, which are optimized for speed rather than debugging). If the…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… estimate memory consumption by MySQL Server in given configuration. What is the formula they could use. The reasons to worry about memory usage are quite understandable. If you configure MySQL Server so it uses too small amount of memory it will likey… Query Parsing and optimization needs memory. This is usually small to be ignored but certain queries can have very large memory requrement for…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
…memory). Also, I was testing, as I said before, index condition pushdown. Let’s have a look at the EXPLAIN output: mysql…this is always preferred over the ICP optimization: mysql> EXPLAIN SELECT role_id FROM cast_… about index usage in the future, now that we have more complex optimization strategies….
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot… server ? We also speak about just pennies in terms of memory usage so why do not just default at 2000 ? innodb_file… etc referring to amounts of memory we have in the phones these days, I made in my Optimizing MySQL Configuration Webinar were heard 
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with … of indexes. The indexes can’t fit in memory anymore. How does this affect performance? A: Typically … IN-ranges in some cases for better index usage. Q: Is the b+ tree innodb index a …
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…’s not forget about the memory needed to parse and optimize and execute queries; mysqld …100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) …no formula to compute the maximum possible memory usage, and there cannot be because there are…
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
… out the usage is often better choice than hardware upgrade and it also can be done easily. Is MySQL, Queries, Architecture optimized well… full table scan and make given query faster. You add memory to avoid disk IO and make lookups faster. The goal… to understand what needs to be done (gettings SSD, upgrading memory, upgrading CPUs). There are number of balancing questions you have…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… memory. This however have to be watched carefully. Performance does not always stays the same and the goal may not be optimizing… be increasing memory is helpful to solve this problem. If it is IO bound (high IO system utilization, low CPU usage) one… subsystem utilization on 5% of CPU usage ? This is the true challenge becomes because MySQL has no tools to analyze working set…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be …IO capacity or high in memory fit. For large number of applications optimizing IO performance will be number…want your runaway logs or extreme temporary space usage to stop the database, but they usually …
