… of MHA. Q: How do you monitor MySQL to determine when it’s not responsive? A: The easiest way to do this… a response back in a reasonable (what is reasonable is determined by your environment), it’s a safe bet that MySQL is…, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, I got some…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… the queries you should try to improve to get optimal response times pt-archiver, to efficiently purge purge data from huge tables… on “5 Percona Toolkit Tools for MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of…, real-world MySQL database administration challenges, such as: Selecting which queries you should try to optimize to get better response times How to…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… great illustration on the topic. This time I want to target an opposite question: why MySQL performance at low concurrency is important… 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: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… saying something like, “12 full-time engineers are working on MySQL server.” The MySQL Certification program was announced. MySQL 4.0.12 was just… release in the MySQL 4.0 series, and for the first and only time in a MySQL version you could buy MySQL in a… back but now delivered by Karen Padir, the new manager responsible for MySQL business at Sun. A lot of Sun hardware and…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… impressive; the next two graphs show 95th and 99th-percentile response time, but there really isn’t much difference between the two… latency just over 3ms. How well does it perform with MySQL? Exact results vary, depending upon the usual factors (read/write… compare the performance of the P320h on a standard TPCC-MySQL test to the original FusionIO and the Intel i910 with…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… waste time and lose performance because of this. I am one of those people. When MySQL 5.6 spends a lot of time… good performance results. Prior to 5.6 foreground threads were responsible for moving pages to the free list via buf_flush… them. http://bugs.mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql.com/bug.php…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… waste time and lose performance because of this. I am one of those people. When MySQL 5.6 spends a lot of time… good performance results. Prior to 5.6 foreground threads were responsible for moving pages to the free list via buf_flush… them. http://bugs.mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql.com/bug.php…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file …s no fencing and when the servers are not responsive because of swapping is pretty bad for a …, iostat, etc all saving to disk with the current time stamp in front of each line. I quickly …
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… simple protocols such as 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: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most important they often… often can see it as higher IO load (IO utilization, response time) while less work is being done in terms of requests… bit different workload and when backup taken at the wrong time may be responsible for unexpected MySQL replication lag.
