…Server for MySQL version 5.6 release. Another thing to remember about MySQL 5.6 is – it comes with Performance… we found it is a good measure of the overhead, especially for simple queries…time=300 run For single thread MySQL 5.5 is 11% faster than MySQL 5.6. If you disable Performance Schema in MySQL…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… CPU to spare. We’re using Percona Server 5.5.15 for this test with…mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock run [root@localhost msb_ps_5_5_15]# time… we would not be able to measure small variances in performance reliably. Running Sysbench and MySQLDump…
Post: How to estimate query completion time in MySQL
April 22, 2008 By 16 Comments
…’ll write more about that later) I convinced MySQL to perform the query as a table scan of the … status, but MySQL doesn’t currently let you do that.) The solution was to measure how fast the …of output… | Handler_read_rnd_next | 429224 | So the server was reading roughly 43K rows per second, and …
Post: Announcing Percona Playback 0.5
November 26, 2012 By
…MySQL query-log and tcpdump files and run them on other MySQL server. With Percona Playback you can measure how a server or database upgrade, change in my.cnf or schema change can affect the overall performance of your database server…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
… nutshell, it is a lightweight way to measure response times on a server such as a database, memcached, Apache… HTTP and MySQL, this is the moral equivalent of a query’s response time. The statistics …have been on the code. We’ve performed tests on servers with high loads and observed minimal resource…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… Plus we only measured Power to keep …Times are given in seconds. Ratio is MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL… for Microsoft SQL Server. Of course this…MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
…at what the server is doing. For example, in Percona Server we have …, which has been available in MySQL for years. This is necessary …diagnose the kinds of sub-second performance stalls we are interested in. Without… done it many times with simple awk scripts and various statistical measures. What do…
Post: Why message queues and offline processing are so important
August 10, 2010 By 3 Comments
…on Goal-Driven Performance Optimization, you will notice that we define performance using …Time – This is the time required to complete a desired task. Throughput – Throughput is measured in tasks completed per unit of time… Or in plain English: The same MySQL servers can achieve much more work, if…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
…time I’ve wanted to know how MySQL scales as you add more memory to the server….bandwidth than MySQL can fully utilize at present. Therefore, to decrease the price-to-performance ratio and…measuring the different configurations the way Vadim has done. You can read the full details in our Scaling MySQL…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…. The reality is that this server setting is very subjective, and there is no good instrumentation in MySQL to guide your decisions… ratios. For performance analysis, you need to measure elapsed time, not just the number of times something happens. In the absence of timing information, and…
