… running MySQL in wild. I also wanted to share some troubleshooting techniques I use. Plot Memory Usage First I would like to see MySQL memory…you might see instead is flushing tables regularly or reducing table cache reduces memory consumption to be withing the reason. Connection Related Allocations…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are …? We also speak about just pennies in terms of memory usage so why do not just default at 2000 ? …an optimal value or is it just looking to reduce number of different buffer sizes used. sync_master_info …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… The #14 and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is… system is already have low wait ratio increasing amount of memory for example is unlikely to help. One helpful way to… with different memory amount having same workload. You will often see increasing amount of memory not only helps you to reduce wait time…
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…” calls was reduced from 8346769 (5.5) to just 266 (5.6), reducing the executing time… statistics computation and monitoring variables about index usage in the future, now that we …
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… see as response to these requirements ? From MySQL side we have further development of MySQL Cluster to be more usable for web… Wave is appliances – you can see Violin Memory appliance which can be used with MySQL to get very fast IO and so… on the scale of Big Table with Map Reduce. Indeed I think MySQL Replication usage will reduce, but I would not expect Memcached to…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
…MySQL. Popular cache methods The MySQL query cache When the query cache is enabled, MySQL…place them into the cache. Additionally, memory pressure may cause unexpected invalidation of…pages is a good way to reduce the number of round trips … bottlenecks: disk IO and CPU usage. Disk IO is expensive, and…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… memory allocated to get to address space limit and MySQL will crash when one of internal memory … allows to run queries with uncontrolled resource usage. Host Block You can have given client … heavily you can reduce system performance beyond being functional. General Overload As MySQL does not have …
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
…, but it is temporary in nature, usually existing only in memory for a short time. This concept extends from relational algebra… conceptually so too is the output of a SQL statement. MySQL even includes a SQL statement that makes this perfectly clear… is already joined together and pre-aggregated, CPU and memory usage may be reduced compared to computing the results. You can often generate…
Post: Scaling: Consider both Size and Load
July 13, 2010 By 5 Comments
…accounts. You can see the CPU,IO and Network usage is below 10% of capacity – does it mean …can be reduced by code changes, such as there have been a lot of advanced in scalability of MySQL by…portion of your database (or working) set fits in memory, hence having CPU bound workload. As your data …
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
… for big application changes. Is current hardware usage balanced ? Say you have 10 servers one … needs to be done (gettings SSD, upgrading memory, upgrading CPUs). There are number of balancing …from 4 Core systems to 8 Core reduced performance for many MySQL systems even though hardware itself was…
