List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:August 16 2011 11:57pm
Subject:Re: shall i jump from 5.1 to 5.5
View as plain text  
This is a poor benchmark because the query never changes. Query cache takes over after
first request. 

Sent from my iPad

On Aug 16, 2011, at 4:28 PM, "Alvin Ramos" <alvin.ramos@stripped> wrote:

> I know my previous email was vague, it was sent via smartphone.  I’ve got a
> simple PHP page pulling information from one of larger database tables:
> 
> 
> 
> PHP Code:
> 
> 
> 
> <html>
> 
> <head>
> 
> <basefront face="Arial">
> 
> </head>
> 
> 
> 
> <body>
> 
> 
> 
> <?php
> 
> 
> 
> // set server access variables
> 
> $host = "127.0.0.1";
> 
> $user = "web";
> 
> $pass = "password";
> 
> $db = "md ";
> 
> 
> 
> // open connections to database
> 
> $connect = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
> 
> 
> 
> // select database to use
> 
> mysql_select_db($db) or die ("Unable to select database!");
> 
> 
> 
> // create SQL query string
> 
> $query = "SELECT * FROM members limit 1000";
> 
> 
> 
> //execute query and obtain result set
> 
> $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
> 
> 
> 
> // are there any rows in the result?
> 
> if (mysql_num_rows($result) > 0)
> 
> {
> 
>        // yes
> 
>        // iterate through result set
> 
>        // format query results as table
> 
>        echo "<table cellpadding=10 border=1>";
> 
>        while($row = mysql_fetch_assoc($result))
> 
>        {
> 
>                echo "<tr>";
> 
>                echo "<td>" . $row['member_id'] . "</td>";
> 
>                echo "<td>" . $row['fname'] . "</td>";
> 
>                echo "</tr>";
> 
>        }
> 
>        echo "</table>";
> 
> }
> 
> else
> 
> {
> 
>        // no
> 
>        // print status message
> 
>        echo "NO rows found!";
> 
> }
> 
> 
> 
> // close connection
> 
> mysql_close($connect);
> 
> 
> 
> ?>
> 
> 
> 
> </body>
> 
> </html>
> 
> 
> 
> I’ve got apache benchmark then running 5 concurrent connections 10,000 times. 
> I changed the $host to the IP for the 5.5 server then to the 5.1 server and here are one
> of my many results:
> 
> 
> 
> 5.1 results:
> 
> 
> 
> Server Software:        Apache/2.2.3
> 
> Server Hostname:        aramos.dev
> 
> Server Port:            80
> 
> 
> 
> Document Path:          /mysqlfetch51.php
> 
> Document Length:        35808 bytes
> 
> 
> 
> Concurrency Level:      5
> 
> Time taken for tests:   3263.909079 seconds
> 
> Complete requests:      10000
> 
> Failed requests:        0
> 
> Write errors:           0
> 
> Total transferred:      359640000 bytes
> 
> HTML transferred:       358080000 bytes
> 
> Requests per second:    3.06 [#/sec] (mean)
> 
> Time per request:       1631.955 [ms] (mean)
> 
> Time per request:       326.391 [ms] (mean, across all concurrent requests)
> 
> Transfer rate:          107.60 [Kbytes/sec] received
> 
> 
> 
> Connection Times (ms)
> 
>              min  mean[+/-sd] median   max
> 
> Connect:        0    1   2.3      1     155
> 
> Processing:   593 1629 699.7   1524   13580
> 
> Waiting:      574 1611 699.7   1506   13562
> 
> Total:        595 1630 699.7   1526   13580
> 
> 
> 
> Percentage of the requests served within a certain time (ms)
> 
>  50%   1526
> 
>  66%   1725
> 
>  75%   1856
> 
>  80%   1944
> 
>  90%   2215
> 
>  95%   2559
> 
>  98%   4339
> 
>  99%   4741
> 
> 100%  13580 (longest request)
> 
> 
> 
> 5.5 results:
> 
> 
> 
> erver Software:        Apache/2.2.3
> 
> Server Hostname:        aramos.dev
> 
> Server Port:            80
> 
> 
> 
> Document Path:          /mysqlfetch.php
> 
> Document Length:        35808 bytes
> 
> 
> 
> Concurrency Level:      5
> 
> Time taken for tests:   3400.300474 seconds
> 
> Complete requests:      10000
> 
> Failed requests:        0
> 
> Write errors:           0
> 
> Total transferred:      359640000 bytes
> 
> HTML transferred:       358080000 bytes
> 
> Requests per second:    2.94 [#/sec] (mean)
> 
> Time per request:       1700.150 [ms] (mean)
> 
> Time per request:       340.030 [ms] (mean, across all concurrent requests)
> 
> Transfer rate:          103.29 [Kbytes/sec] received
> 
> 
> 
> Connection Times (ms)
> 
>              min  mean[+/-sd] median   max
> 
> Connect:        0    1   2.7      1     168
> 
> Processing:   595 1697 724.8   1598   14505
> 
> Waiting:      577 1679 724.8   1580   14486
> 
> Total:        596 1698 724.8   1600   14506
> 
> 
> 
> Percentage of the requests served within a certain time (ms)
> 
>  50%   1600
> 
>  66%   1799
> 
>  75%   1939
> 
>  80%   2028
> 
>  90%   2314
> 
>  95%   2640
> 
>  98%   4387
> 
>  99%   4805
> 
> 100%  14506 (longest request)
> 
> 
> 
> 
> 
> I’ve ran tests even against our web sites and its slower than the 5.1 server. 
> Any suggestions, anything I should change on the 5.5 server?  The hardware and OS is
> identical from the 5.1 server.  Thanks!
> 
> 
> 
> Alvin Ramos
> 
> 
> 
> From: wang@stripped [mailto:wang@stripped] On Behalf Of Singer X.J. Wang
> Sent: Tuesday, August 16, 2011 4:08 PM
> To: Alvin Ramos
> Cc: Prabhat Kumar; Reindl Harald; mysql@stripped
> Subject: Re: shall i jump from 5.1 to 5.5
> 
> 
> 
> Are you doing concurrent workloads?
> 
> 
> 
> On Tue, Aug 16, 2011 at 16:04, Alvin Ramos <alvin.ramos@stripped> wrote:
> 
> I've been running some bench marking between 5.1 and 5.5 myself and haven't notice
> any huge performance improvements on 5.5. Even though white papers claim it put performs
> 5.1. Any noticing the same or have some input in my findings?
> 
> Regards,
> Alvin
> 
> 
> On Aug 16, 2011, at 3:55 PM, Prabhat Kumar <aim.prabhat@stripped> wrote:
> 
>> correct. you have to understand the problem first.
>> but still its recommendable to always use latest stable version.
>> 
>> On Tue, Aug 16, 2011 at 10:02 AM, Reindl Harald
> <h.reindl@stripped>wrote:
>> 
>>> 
>>> 
>>> Am 16.08.2011 17:59, schrieb Luis Daniel Lucio Quiroz:
>>>> as far as my readings, they claim that 5.5 is the best
>>>> 
>>>> my question is, shall i jump from 5.1 to 5.5.
>>>> 
>>>> right now i have a performance problem, would 5.5 help me in that?
>>>> 
>>>> Regards,
>>>> 
>>>> LD
>>>> 
>>> why do you believe without any information you will get
>>> a useful answer? "i have a performance problem" is simply
>>> NO information if you even do not tell which storage engine
>>> and wich sort of problem in which context
>>> 
>>> if you should update can nobody answer for you because we
>>> do not know if you have any crappy apps / scripts which
>>> would have troubles?
>>> 
>>> we have upgraded some hundret webspaces and two dbmail-servers
>>> in februray becaus we know our self written applications and
>>> having test-environments, if you can do this can nobody say
>>> 
>>> 
>> 
>> 
>> --
>> Best Regards,
>> 
>> Prabhat Kumar
>> MySQL DBA
>> 
>> My Blog: http://adminlinux.blogspot.com
>> My LinkedIn: http://www.linkedin.com/in/profileprabhat
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 
> 
> --
> The best compliment you could give Pythian for our service is a referral.
> 
Thread
shall i jump from 5.1 to 5.5Luis Daniel Lucio Quiroz16 Aug
  • Re: shall i jump from 5.1 to 5.5Reindl Harald16 Aug
    • Re: shall i jump from 5.1 to 5.5Prabhat Kumar16 Aug
      • Re: shall i jump from 5.1 to 5.5Alvin Ramos16 Aug
RE: shall i jump from 5.1 to 5.5Alvin Ramos16 Aug
  • Re: shall i jump from 5.1 to 5.5Reindl Harald16 Aug
  • Re: shall i jump from 5.1 to 5.5Johnny Withers17 Aug
    • Re: shall i jump from 5.1 to 5.5Alvin Ramos17 Aug
      • Re: shall i jump from 5.1 to 5.5Reindl Harald17 Aug