php-general Digest 23 Apr 2013 17:14:16 -0000 Issue 8206
php-general Digest 23 Apr 2013 17:14:16 - Issue 8206
Topics (messages 320962 through 320972):
Re: Load testing an app
320962 by: Adam Richardson
320970 by: Andrew Ballard
A little confused
320963 by: Chris Knipe
320964 by: Stuart Dallas
320965 by: Chris Knipe
320966 by: Stuart Dallas
320967 by: shiplu
320968 by: Chris Knipe
Re: mysql_connect noob question
320969 by: Tedd Sperling
320971 by: Glob Design Info
320972 by: Jim Giner
Administrivia:
To subscribe to the digest, e-mail:
php-general-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-general-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-gene...@lists.php.net
--
---BeginMessage---
On Mon, Apr 22, 2013 at 10:41 PM, Andrew Ballard aball...@gmail.com wrote:
The other developer in our office spent some time profiling the site with
xdebug and found that an exec() call to netsh used on a couple pages seems
to take 2-4 seconds to complete. Unfortunately, those exec() calls are the
one function that we cannot test in our development environment. We are
considering some optimizations, but since load on the production server is
at a seasonal low we want to duplicate the problem so we can measure the
impact of any changes we make. We spent most of today hammering the site
with JMeter today in an attempt to reproduce the issue. While we were
easily able to slow the site to a crawl (some samples taking over 2 minutes
to complete), the server returned to normal as soon as the test concluded
and it never became totally unresponsive like it did this past fall.
If you can't test the exec calls, directly, I'd refactor the functionality
that calls exec() so you could pass in replacement functionality that
creates that artificially creates the pause in your development environment:
function callnetsh($args, $func) {
$func($args);
}
// in dev environment, pass in $func that doesn't call exec but just sleeps
for the expected duration
callnetsh(['some', 'args'], function($args){
sleep(4);
});
We're both new to JMeter. I know a single test server may not be able to
create enough simultaneous requests to accurately simulate real traffic,
but I'm fairly confident that our tests involved far more (roughly-)
simultaneous connections than we were experiencing live. (The first test
used 20 threads; we gradually increased the threads for each test to 500
threads before we quit for the day.) The site is on a private subnet, so
distributed and/or cloud-based testing are probably not options.
2 quick notes:
If you have a linux box available, I like the simplicity of siege, but
jmeter is nice, too:
http://www.joedog.org/siege-home/
If the exec() calls were not being executed (e.g., they were bypassed) and
weren't being accounted for in terms of processing time, then these tests
would likely fail to recreate the load issues with similar numbers.
The site is running PHP 5.3 on IIS/Windows Server 2003. The netsh calls are
to a DHCP server on a separate Windows server, and the database is SQL
Server 2008 (previously 2000).
PHP 5.4 offers performance improvements. I don't suspect the migration from
SQL Server 2003 to 2008 caused any of these issues.
So, any ideas we can try?
We'd probably have to know more about what the netsh calls were doing.
Adam
--
Nephtali: A simple, flexible, fast, and security-focused PHP framework
http://nephtaliproject.com
---End Message---
---BeginMessage---
On Tue, Apr 23, 2013 at 2:29 AM, Adam Richardson simples...@gmail.com wrote:
On Mon, Apr 22, 2013 at 10:41 PM, Andrew Ballard aball...@gmail.com wrote:
The other developer in our office spent some time profiling the site with
xdebug and found that an exec() call to netsh used on a couple pages seems
to take 2-4 seconds to complete. Unfortunately, those exec() calls are the
one function that we cannot test in our development environment. We are
considering some optimizations, but since load on the production server is
at a seasonal low we want to duplicate the problem so we can measure the
impact of any changes we make. We spent most of today hammering the site
with JMeter today in an attempt to reproduce the issue. While we were
easily able to slow the site to a crawl (some samples taking over 2 minutes
to complete), the server returned to normal as soon as the test concluded
and it never became totally unresponsive like it did this past fall.
If you can't test the exec calls, directly, I'd refactor the functionality
that calls exec() so you could pass in replacement functionality that creates
that artificially creates the pause in your development environment:
I'm not sure the issue is solely because of the delay. At any rate, we
were running the load test yesterday against the production system
that was
Re: [PHP] Load testing an app
On Mon, Apr 22, 2013 at 10:41 PM, Andrew Ballard aball...@gmail.com wrote:
The other developer in our office spent some time profiling the site with
xdebug and found that an exec() call to netsh used on a couple pages seems
to take 2-4 seconds to complete. Unfortunately, those exec() calls are the
one function that we cannot test in our development environment. We are
considering some optimizations, but since load on the production server is
at a seasonal low we want to duplicate the problem so we can measure the
impact of any changes we make. We spent most of today hammering the site
with JMeter today in an attempt to reproduce the issue. While we were
easily able to slow the site to a crawl (some samples taking over 2 minutes
to complete), the server returned to normal as soon as the test concluded
and it never became totally unresponsive like it did this past fall.
If you can't test the exec calls, directly, I'd refactor the functionality
that calls exec() so you could pass in replacement functionality that
creates that artificially creates the pause in your development environment:
function callnetsh($args, $func) {
$func($args);
}
// in dev environment, pass in $func that doesn't call exec but just sleeps
for the expected duration
callnetsh(['some', 'args'], function($args){
sleep(4);
});
We're both new to JMeter. I know a single test server may not be able to
create enough simultaneous requests to accurately simulate real traffic,
but I'm fairly confident that our tests involved far more (roughly-)
simultaneous connections than we were experiencing live. (The first test
used 20 threads; we gradually increased the threads for each test to 500
threads before we quit for the day.) The site is on a private subnet, so
distributed and/or cloud-based testing are probably not options.
2 quick notes:
If you have a linux box available, I like the simplicity of siege, but
jmeter is nice, too:
http://www.joedog.org/siege-home/
If the exec() calls were not being executed (e.g., they were bypassed) and
weren't being accounted for in terms of processing time, then these tests
would likely fail to recreate the load issues with similar numbers.
The site is running PHP 5.3 on IIS/Windows Server 2003. The netsh calls are
to a DHCP server on a separate Windows server, and the database is SQL
Server 2008 (previously 2000).
PHP 5.4 offers performance improvements. I don't suspect the migration from
SQL Server 2003 to 2008 caused any of these issues.
So, any ideas we can try?
We'd probably have to know more about what the netsh calls were doing.
Adam
--
Nephtali: A simple, flexible, fast, and security-focused PHP framework
http://nephtaliproject.com
[PHP] A little confused
Hi All, $_SESSION['ExpiryDate'] = 2013-04-23; echo date_format($_SESSION['ExpiryDate'], D, \t\h\e jS \o\f M Y); Required Result: Mon, the 23rd of Apr 2013 I get however: PHP Warning: date_format() expects parameter 1 to be DateTime, integer given in I've had a look at the date/time function list, but I cannot seem to find any way to convert $_SESSION['ExpiryDate'] to an DateTime?? -- Chris. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] A little confused
On 23 Apr 2013, at 11:07, Chris Knipe sav...@savage.za.org wrote: $_SESSION['ExpiryDate'] = 2013-04-23; echo date_format($_SESSION['ExpiryDate'], D, \t\h\e jS \o\f M Y); Required Result: Mon, the 23rd of Apr 2013 I get however: PHP Warning: date_format() expects parameter 1 to be DateTime, integer given in I've had a look at the date/time function list, but I cannot seem to find any way to convert $_SESSION['ExpiryDate'] to an DateTime?? http://php.net/strtotime -Stuart -- Stuart Dallas 3ft9 Ltd http://3ft9.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] A little confused
Yes, strtotime() does convert the $_SESSION value to a unix epoc, as expected. However, date_format still complains that the argument is a Integer value, instead of a DateTime. On Tue, Apr 23, 2013 at 12:09 PM, Stuart Dallas stu...@3ft9.com wrote: On 23 Apr 2013, at 11:07, Chris Knipe sav...@savage.za.org wrote: $_SESSION['ExpiryDate'] = 2013-04-23; echo date_format($_SESSION['ExpiryDate'], D, \t\h\e jS \o\f M Y); Required Result: Mon, the 23rd of Apr 2013 I get however: PHP Warning: date_format() expects parameter 1 to be DateTime, integer given in I've had a look at the date/time function list, but I cannot seem to find any way to convert $_SESSION['ExpiryDate'] to an DateTime?? http://php.net/strtotime -Stuart -- Stuart Dallas 3ft9 Ltd http://3ft9.com/ -- Regards, Chris Knipe
Re: [PHP] A little confused
On 23 Apr 2013, at 11:13, Chris Knipe sav...@savage.za.org wrote:
Yes,
strtotime() does convert the $_SESSION value to a unix epoc, as expected.
However, date_format still complains that the argument is a Integer value,
instead of a DateTime.
Sorry, I didn't read your email properly and didn't realise you were trying to
use DateTime objects.
$datetime = new DateTime('2013-04-23');
If all you're doing is formatting the date you'll find using
date($unix_timestamp) far more efficient than date_format($datetime_object).
-Stuart
--
Stuart Dallas
3ft9 Ltd
http://3ft9.com/
On Tue, Apr 23, 2013 at 12:09 PM, Stuart Dallas stu...@3ft9.com wrote:
On 23 Apr 2013, at 11:07, Chris Knipe sav...@savage.za.org wrote:
$_SESSION['ExpiryDate'] = 2013-04-23;
echo date_format($_SESSION['ExpiryDate'], D, \t\h\e jS \o\f M Y);
Required Result: Mon, the 23rd of Apr 2013
I get however: PHP Warning: date_format() expects parameter 1 to be
DateTime, integer given in
I've had a look at the date/time function list, but I cannot seem to find
any way to convert $_SESSION['ExpiryDate'] to an DateTime??
http://php.net/strtotime
-Stuart
--
Stuart Dallas
3ft9 Ltd
http://3ft9.com/
--
Regards,
Chris Knipe
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] A little confused
On Tue, Apr 23, 2013 at 4:07 PM, Chris Knipe sav...@savage.za.org wrote: echo date_format($_SESSION['ExpiryDate'], D, \t\h\e jS \o\f M Y); Why not construct DateTime object echo date_format(new DateTime($_SESSION['ExpiryDate']), D, \t\h\e jS \o\f M Y); Or $dt = new DateTime($_SESSION['ExpiryDate']); echo $dt-format(D, \t\h\e jS \o\f M Y); I personally like the later. It takes less characters to do more. -- Shiplu.Mokadd.im ImgSign.com | A dynamic signature machine Innovation distinguishes between follower and leader
Re: [PHP] A little confused
Thanks for the replies guys - figured it out! Using date() directly with strtotime() and the appropriate formating works :) date(D, \\t\h\e jS \o\\f M Y, strtotime($_SESSION['ExpiryTime'])) On Tue, Apr 23, 2013 at 12:16 PM, shiplu shiplu@gmail.com wrote: On Tue, Apr 23, 2013 at 4:07 PM, Chris Knipe sav...@savage.za.org wrote: echo date_format($_SESSION['ExpiryDate'], D, \t\h\e jS \o\f M Y); Why not construct DateTime object echo date_format(new DateTime($_SESSION['ExpiryDate']), D, \t\h\e jS \o\f M Y); Or $dt = new DateTime($_SESSION['ExpiryDate']); echo $dt-format(D, \t\h\e jS \o\f M Y); I personally like the later. It takes less characters to do more. -- Shiplu.Mokadd.im ImgSign.com | A dynamic signature machine Innovation distinguishes between follower and leader -- Regards, Chris Knipe
Re: [PHP] mysql_connect noob question
On Apr 21, 2013, at 3:33 PM, Glob Design Info i...@globdesign.com wrote: What question did I not answer? That proves that you're not listening -- you are total waste of time for anyone trying to help. Welcome to my ignore file. tedd _ tedd.sperl...@gmail.com http://sperling.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Load testing an app
On Tue, Apr 23, 2013 at 2:29 AM, Adam Richardson simples...@gmail.com wrote: On Mon, Apr 22, 2013 at 10:41 PM, Andrew Ballard aball...@gmail.com wrote: The other developer in our office spent some time profiling the site with xdebug and found that an exec() call to netsh used on a couple pages seems to take 2-4 seconds to complete. Unfortunately, those exec() calls are the one function that we cannot test in our development environment. We are considering some optimizations, but since load on the production server is at a seasonal low we want to duplicate the problem so we can measure the impact of any changes we make. We spent most of today hammering the site with JMeter today in an attempt to reproduce the issue. While we were easily able to slow the site to a crawl (some samples taking over 2 minutes to complete), the server returned to normal as soon as the test concluded and it never became totally unresponsive like it did this past fall. If you can't test the exec calls, directly, I'd refactor the functionality that calls exec() so you could pass in replacement functionality that creates that artificially creates the pause in your development environment: I'm not sure the issue is solely because of the delay. At any rate, we were running the load test yesterday against the production system that was having problems last fall. I wish we had a test system where we could test everything end-to-end, but unfortunately we can't duplicate the DHCP part of the production environment. 2 quick notes: If you have a linux box available, I like the simplicity of siege, but jmeter is nice, too: http://www.joedog.org/siege-home/ Hahahaha. This system AND the DHCP both USED to run on linux boxes. This task was much simpler then, because the DHCP table was a text file that we parsed and updated directly from PHP. It was decided to standardize on a single platform to make system maintenance and security management simpler, and most of our client/server stack was already Windows. If necessary, I could probably spin up a virtual box for testing though. The site is running PHP 5.3 on IIS/Windows Server 2003. The netsh calls are to a DHCP server on a separate Windows server, and the database is SQL Server 2008 (previously 2000). PHP 5.4 offers performance improvements. I don't suspect the migration from SQL Server 2003 to 2008 caused any of these issues. I can't imagine the DB upgrade would have caused it. I think at the same time he switched to using Zend_Db (not the full framework, just the DB library) over top of the SQL Server driver for PHP for database queries. So, any ideas we can try? We'd probably have to know more about what the netsh calls were doing. This particular call is querying DHCP for a list of leases within a specific scope so we can get the MAC address of the client. Once we authenticate the user, calls on later pages expire the current lease for that MAC address on a private subnet and create a semi-permanent lease on the public subnet. Our testing yesterday stepped through the process beginning with this initial DHCP query (which was the long running process identified in profiling) and the next few very simple pages but stopped short of actually making any changes to the network assignment. With a single user, the first page takes a couple seconds and the next few pages are 50ms. During testing yesterday, we had the system stressed enough to stretch those times out past a couple minutes. It looks like we're going to have to continue the test into the next part of the sign-up process, but that will take some time to learn about JMeter conditional logic. I suspect we'll have to wait a couple weeks until students are gone before we can actually run that level of testing. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
Well all, it turns out the *correct* answer to my question, which no one answered, and which only degenerated into a kindergarten-like argument is: You need to add the port # to the *end* of the mysql_connect() call. i.e.: $link = mysqli_connect( $host, user, pass, $database, $port ); Glad to see the maturity level of posters on this list, as in most of IT these days is that of a bunch of squabling 5-year olds. On 4/23/13 5:47 AM, Tedd Sperling wrote: On Apr 21, 2013, at 3:33 PM, Glob Design Info i...@globdesign.com wrote: What question did I not answer? That proves that you're not listening -- you are total waste of time for anyone trying to help. Welcome to my ignore file. tedd _ tedd.sperl...@gmail.com http://sperling.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect noob question
On 4/23/2013 10:39 AM, Glob Design Info wrote: Well all, it turns out the *correct* answer to my question, which no one answered, and which only degenerated into a kindergarten-like argument is: You need to add the port # to the *end* of the mysql_connect() call. i.e.: $link = mysqli_connect( $host, user, pass, $database, $port ); Glad to see the maturity level of posters on this list, as in most of IT these days is that of a bunch of squabling 5-year olds. On 4/23/13 5:47 AM, Tedd Sperling wrote: On Apr 21, 2013, at 3:33 PM, Glob Design Info i...@globdesign.com wrote: What question did I not answer? That proves that you're not listening -- you are total waste of time for anyone trying to help. Welcome to my ignore file. tedd _ tedd.sperl...@gmail.com http://sperling.com Tedd - you got off easy on this post. You should have seen the shouting tirade I received offline from this guy. What a putz! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] A little confused
Am 23.04.13 12:07, schrieb Chris Knipe:
Hi All,
$_SESSION['ExpiryDate'] = 2013-04-23;
echo date_format($_SESSION['ExpiryDate'], D, \t\h\e jS \o\f M Y);
Required Result: Mon, the 23rd of Apr 2013
I get however: PHP Warning: date_format() expects parameter 1 to be
DateTime, integer given in
I've had a look at the date/time function list, but I cannot seem to find
any way to convert $_SESSION['ExpiryDate'] to an DateTime??
Take a look at this:
http://de3.php.net/manual/en/datetime.createfromformat.php
Or try this
http://de3.php.net/manual/en/function.strtotime.php
$_SESSION['ExpiryDate'] = 2013-04-23;
$int_timestamp = strtotime($_SESSION['ExpiryDate']);
echo date('D, \t\h\e jS \o\f M Y', $int_timestamp );
Use SINGLE QUOTES!
--
Chris.
--
Marco Behnke
Dipl. Informatiker (FH), SAE Audio Engineer Diploma
Zend Certified Engineer PHP 5.3
Tel.: 0174 / 9722336
e-Mail: ma...@behnke.biz
Softwaretechnik Behnke
Heinrich-Heine-Str. 7D
21218 Seevetal
http://www.behnke.biz
signature.asc
Description: OpenPGP digital signature
