… is because virtual machines tend to handle process scheduling and timing much differently than traditional hardware, and I’ve seen situations… not responsive? A: The easiest way to do this is to simply connect to it and attempt to run a simple query…, if you can connect and run a simple query and receive a response back in a reasonable (what is reasonable is determined…
Comment: MySQL Partitioning - can save you or kill you
June 3, 2013 By 45 Comments
Hi Great article and had fun reading all the responses. After implementing what was suggested I have also managed to reduce my query time greatly. I will bookmark this blog for future reference. Best regards Ian
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… Percona Server providing some great illustration on the topic. This time I want to target an opposite question: why MySQL performance… offers the best response times (MySQL server does not use multiple threads to execute query in parallel at this point). Response times at the variety… you might not understand why the system is showing worse response times when you are actually running it in real life with…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… the following tools: pt-query-digest, to select the queries you should try to improve to get optimal response times pt-archiver, to efficiently… administration challenges, such as: Selecting which queries you should try to optimize to get better response times How to efficiently purge data from…
Post: Query Response time histogram - new feature in Percona Server
July 11, 2010 By 11 Comments
… of queries response times into Percona Server, and our software engineer Oleg Tsarev implemented this feature. The feature adds new INFORMATION_SCHEMA table QUERY_RESPONSE_TIME ( full docs are on page response_time_distribution), which looks like time count 0.000001 53 0…
Post: What do we optimize with mk-query-digest ?
December 15, 2009 By 2 Comments
… time which you can see which are unrelated to query itself – general system overload, row level locks, table locks all could cause query response time to be unreasonable. If Slowest query is not interactive query…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… query features like BETWEEN or IN. It is also possible to spread your data over multiple machines, scaling out to improve query response times significantly. These queries are a great test of Shard-Query features. It is currently approaching RC…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… impact in our query response times and throughput. Setting up a cluster using the AMI images You can easily test Shard-Query for yourself… first number is wall time, the second exec time, the third parse time). $ echo “select count(*) from ontime_fact;” | ./run_query Array ( [count(*)] => 135125787…-packet=1M net-buffer-length=16K #we value throughput over response time, get a good plan optimizer-prune-level=0 partition=ON…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
… information about the response time of the requests within that time period. Here “response time” means, for a given TCP connection, the time elapsed from the… HTTP and MySQL, this is the moral equivalent of a query‘s response time. The statistics we chose to output by default are the count, median, average, min, max, and standard deviation of the response times…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
… query is executing. You should not forget that improving queries also means improving the stability of the response time, and not only having low response times sometimes. In this case, a stable 160ms response time…
