…a more complicated test which runs this query concurrently many times or even workload consisting of several query…the query which performs differently between MySQL Server versions you should: Check Query Plan Run EXPLAIN to see if plans for the query are the same. Changing Query Execution…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…a backtrace, please!), and at what point in time the allocation happened. For example; you may have noticed a sharp memory increase after executing a particular query…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…of the problem in MySQL 3.23 when there would only handful of places where memory could be allocated but it is a…query execution, which size can be controlled by tmp_table_size and which also only exist for duration of query execution…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the…the data which is being accessed by the queries or query execution…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…the queries over both data centers. The response time should only be increased by the…Query instance is a essentially a proxy for the distributed set based SQL operations executed on the nodes under the proxy. The databases do 99.9% of the…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
…The first thing you need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries…put too heavy of concurrent load on it the response times will increase and user experience… relatively short queries and introducing “sleeps” between them can be a good idea…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…the field that is used to join the two tables? A: The question in this case is how MySQL will execute the…The cases when you really should worry about performance impact of extending index is when you increase…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…MySQL‘s PID file, such as a buggy init script that attempts to start the server when it’s already running, or executing the…of operation, so you can (for example) get the incremental increase in a variable such as Queries and alert on a queries…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…the MySQL manual here. Put simply, the events can be one of two types: Statement based – in which case these are write queries…a time. That being said, one solution to fix IO-bound replication is to increase the amount of…
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
…Query OK, 1 row affected (0.00 sec) When MySQL executes the new view it will be able to restrict the rows examined based on the…the TEMPTABLE algorithm is used. The technique outlined in this post can be used to make a trade off between increased query…
