…You will be thanked by a lot of people running MySQL in wild. I also wanted …take on server. There is no comparable variables of how many user variables are allocated (and how much memory they…126984 INDEX_LENGTH: 0 CREATE_TIME: 2012-03-21 05:52:02 UPDATE_TIME: NULL *************************** 3. row …
Post: Color code your performance numbers
June 2, 2010 By 4 Comments
… as it also clearly clarifies how bad the problem is. If your goal is 99% response time is 1sec and you’re seeing it 2 seconds what you really do not know is how many people fall in this 1-sec to 2 sec range. It could be very small number and so your performance is…
Post: Four ways to optimize paginated displays
September 24, 2008 By 26 Comments
… rows, showing page N of M” display that many people cherish. Don’t show all results. Not … you want to display — for example, fetch 21 rows and display only 20. If there’…how many results there are, and if caching is difficult then this is a simple way to avoid some of the costs. Estimate how many…
Comment: Master-Master or Master with Many Slaves
April 9, 2007 By 7 Comments
… just create as many shards as we need writes.” Well that if fine when. To often however people use too many slaves using replication Instead of partitioning. By the way, how many shards do you have and how many times you… Master-20-slaves you would have 21 copies which is significant waste. Speaking about Shards this is not MMM part – you can however…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…is limited to EXT2/3/4 while over systems like XFS will not continue if consistency problems are discovered. So how…: Mon Aug 22 23:03:21 2011 Last mount time: …next startup which is handy. Now I now some people are …is normally done once per so many mounts or so many days. Large partitions with many…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…people learn more details of query execution, normally hidden from everyone’s eyes. Currently it’s used by many… official database distribution starting 5.1.21 release. Below you will find the files…sources archive and the patch is. First you should determine how your current MySQL installation was…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…is capacity goal this is when the system is generally overloaded so everything is slow, when you’re just looking to see how…people are used to Search taking longer time than other interactions for many…20 | 4990 | 2.4441354725308 | 0.44270882435635 | | 21 | 6305 | 2.6316682707403 | 0.5236776389174 | |…
