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.
>
