cooking, programming and everyday life xrado

Saturday, August 28, 2010

xrado goes dual head

:) funny title. Yes I got equiped with two new 24" led monitors. You probably know, that two (or more) monitor increase productivity, but I haven't seen it on my own until recently. So I decided to replace my old 21,5" Samsung LCD. It's much more space to work now, less windows switching and loosing focus. I decide to pay a few bucks more to get LED LCD. They are tinner, lighter and most important, both together consume less power then my previous monitor. It's not a big thing but I have one minus for HD resolution. Monitors just got too wide while losing on their height. I don't like that so much, but as I said it's not a big thing.  ...anyway lately I'm stuck with a lot of work. Hope those two will help me gain some productivity.  

Wednesday, July 14, 2010

php slow log

A few days ago a friend called me, asking me how could he find the slowest PHP scripts on its server? ..and didn't think of anything. Of course there are tools like xdebug, but they are only useful in development. If you have a server with hundred websites and you are trying to find out what it taking the most of your cpu time, you will probably need something like mysql slow query log. 

I remembered that php.ini has auto_prepend_file and auto_append_file setting, and that can help me wrap every php request with the timer. I made two simple scripts that wont add much extra overhead. It works exactly as mysql slow log. You just set up the SLOW_LOG_TIME and SLOW_LOG_FILE destination. All php requests that take more than SLOW_LOG_TIME will be logged. 

php.ini

auto_prepend_file = "/path_to/before.php"
auto_append_file = "/path_to/after.php"

before.php

<?php
define('SLOW_LOG_START',microtime(TRUE));

after.php

<?php
// Settings
define('SLOW_LOG_TIME', 0.5); // (sec)
define('SLOW_LOG_FILE', '/tmp/php_slow.log');

// Logging
define('SLOW_LOG_END', microtime(TRUE));
$time = SLOW_LOG_END - SLOW_LOG_START;
if ($time > SLOW_LOG_TIME)
{
	$log = date('Y-m-d H:i:s')."\t".round($time,3)."\t".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI']."\n";
	file_put_contents(SLOW_LOG_FILE, $log, FILE_APPEND);
}
sample output with SLOW_LOG_TIME set to 0.1 sec ( on my home server P4 Celeron 2Ghz, 1Gb Ram )
2010-07-08 23:15:19	0.178	xrado.hopto.org/post/baked-lasagna-and-potatoes-kebab-style-seitan
2010-07-08 23:16:32	0.115	xrado.hopto.org/post/extract-emails
2010-07-08 23:16:34	0.13	xrado.hopto.org/
2010-07-08 23:16:38	0.121	xrado.hopto.org/post/going-freelance
...

Actually this wont tell you which are the slowest script, but you'll get the list of PHP requests that take the most processing time. That will give you the clue where to start looking.

Final notes:

  • do not set SLOW_LOG_TIME too low, otherwise your log will be screaming, your server too, depending on number of requests you get
  • check syntax in before.php and after.php, any error can break all your sites
  • remove auto_prepend_file and auto_append_file whey you are done, otherwise logs can go big and you don't need extra disk load

It will be nice to see your timings before and after the optimization.

Wednesday, April 07, 2010

Asparagus and potato

Scratched legs, a handful of asparagus and here's dinner for two.
Asparagus and potato
Ingredients: potatoes, asparagus, onion, salt & pepper and some fresh chives and rabish on top.

Thursday, February 18, 2010

Extract emails

I was doing research on possible customers and end up with the long list of names, contacts and emails. While i was thinking about how i'm gonna assemble the mailing, i came a cross the thought i'll have to collect them again and copy / paste each email to compose form. Ehhh. Then i got the idea how to pass this annoying task. A few lines of javascript and regex and i got a script that collects emails, remove duplicates, get them lower case and separated by commas. Perfect!
window.addEvent('domready',function(){
	$('button').addEvent('click',function(e){
		var emails = [];
		$('text').get('value').replace(/(("[\w-\s]+")|([\w-]+(?:\.[\w-]+)*)|("[\w-\s]+")([\w-]+(?:\.[\w-]+)*))(@((?:[\w-]+\.)*\w[\w-]{0,66})\.([a-z]{2,6}(?:\.[a-z]{2})?))|(@\[?((25[0-5]\.|2[0-4][0-9]\.|1[0-9]{2}\.|[0-9]{1,2}\.))((25[0-5]|2[0-4][0-9]|1[0-9]{2}|[0-9]{1,2})\.){2}(25[0-5]|2[0-4][0-9]|1[0-9]{2}|[0-9]{1,2})\]?)/ig, function(match){
			match = match.toLowerCase();
			if(emails.indexOf(match) != -1) emails.push(match);
		});
		$('text').set('value',emails.join(', '));
	});
});
DEMO  ...paste the text containing emails and press format button.
pages:  1   2   3   4   5   6   7   8   9   10