SELECT DATE(creation_date) `dt`, creation_date, last_modified, SEC_TO_TIME( UNIX_TIMESTAMP(last_modified) - UNIX_TIMESTAMP(creation_date) ) `duration`, `action`
FROM sms_out_message_analyze
GROUP BY `dt`, `duration`
HAVING `dt` = '2011-01-12'
LIMIT 1500;
In my blog, i would discuss the problem i face in daily routine. Following are some of them: mysql error, mysql replication, mysql database corrupted repair, innodb tablespace corruption, mysql storage engines, mysql optimization and tuning, reinstall mysql linux server, linux command for dummies, linux administration tips, mysql administration tips, Linux server benchmarking
Friday, January 28, 2011
Monday, January 24, 2011
How to determine your apache current configuration
/usr/sbin/httpd -l --> List compiled in modules
/usr/sbin/httpd -V --> Shows the compile settings
/usr/sbin/httpd -V --> Shows the compile settings
Subscribe to:
Posts (Atom)