… is how MySQL will execute the join. If it will fist lookup Table2 using some other index and when go to Table1 to lookup… to index on (vendor_id) alone. The cases when you really should worry about performance impact of extending index is when you increase…` IN (5)” regarding indexes and performance? A: Recent MySQL versions are smart enough to convert id IN (5) to ID=5 (for single item…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…e. for what function) it was allocated, how it got there (a backtrace, please…your mysql client), you would execute whatever steps you think are necessary to increase …to match the snapshot frequency etc. to your specific requirements. However, you’ll likely find that the default options will perform…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
… wrote about memory allocators and how they can affect MySQL performance in general. This time I would like to explore this topic from a… at 64/128 threads to ~3500tps 16vcpu – increase in throughput and quite stable results for jemalloc and tcmalloc up to 4096 threads (~6300tps…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…to manage the distinct values for each group in the view. This will increases the time it takes to…to refresh: mysql> …how you can combine both types of views together. The complete method examples show how to…performance during refresh by accessing summarized data. I hope this helps you understand how…
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
… make sense but this is how it is. I also tried to increase cardinality by having all rows to have different group_id and… better performance by joining data to yet another table though why it does not work for multiple group remains question to check with MySQL… have something to learn about MySQL Optimizer gotchas 
At the same time I figured out how to make MySQL Optimizer to do what we want to do…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… growing application sooner or later have to decide on couple few questions on how to tackle application performance. These questions are: Should we Optimize… Scale-Up you by getting more powerful MySQL Server hardware the cost is going to be increasing dramatically after certain hardware size. For…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
… [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those… Queries per second avg: 1.615 ————– Please suggest me how to increase the performance of my server???? There are almost 20-30 user’s…
Post: The four fundamental performance metrics
April 27, 2011 By 15 Comments
…MySQL. In the best case, we want to know everything about the system’s activity: we want to know how many things happened, how…to model scalability with the Universal Scalability Law, perform…
Comment: What to tune in MySQL Server after installation
June 29, 2009 By 118 Comments
Please Anyone suggest me how to increase the performance of my MYSQL server. Day by day the number of slow queries are increasing on!…. Threads: 1…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… ‘Up’ queue is outbound replication. This generally increases when some other node is having …clusters having performance issues where I noticed that the Ops and Bytes went to Zeros on…to 2.5k to start seeing replication conflicts regularly. Hopefully this is helpful for you to get an idea of how to…
