dotmanila

I can haz your backups and ur datuh :-)

Reduce Stack Frame Depth from XDebug Trace Output

April 17, 2013 · by Jervin R · in Linux, PHP

Earlier, I’ve written about how to dump code trace from your PHP application using XDebug, however, more often that not, you get lengthy results and you simply want to get an overview up to certain depth. I’ve created a simple…

Check (Rough) Progress of Your CSV Import to MySQL

April 16, 2013 · by Jervin R · in Linux, MySQL

If you are importing large CSV or SQL dumps to MySQL, chances are you were looking for ways to see how far the import has gone. If you know how many rows there are from the file being imported, you…

Identify Bottleneck on your PHP Scripts with XDebug Code Trace

April 9, 2013 · by Jervin R · in PHP

XDebug has been around for a while and I have been looking to try its features for a while. This time, I was able to poke around briefly with dumping code traces for my PHP code. 1. Make sure to…

Achieve 100% Uptime, The Ultimate Solution

April 1, 2013 · by Jervin R · in Uncategorized

. . . you did not just fall for this

Cacti Graphs for Apache Not Working? Check Your IPv6

October 14, 2012 · by Jervin R · in Apache, Cacti

I was wondering earlier why my Apache Cacti graphs were all graphing 0s. Looking to test manually, I see it’s either 0s or -1s like below. [revin@forge ~]# /usr/bin/php -q /usr/share/cacti/scripts/ss_get_by_ssh.php –host xx.xx.xxx.xxx –type apache –items g1,g3 g1:-1 g3:-1 Looking…

Apache Running on Multiple Ports and Percona Cacti Templates for Apache

Apache Running on Multiple Ports and Percona Cacti Templates for Apache

August 23, 2012 · by Jervin R · in Apache

For some users, running Apache on different ports is more economical than adding multiple IPs to the same server i.e. when you have several Apache servers behind a load balancer where the public IP is in front of the load…

Optimizing OR’ed WHERE Clauses Between JOIN’ed Tables

July 14, 2012 · by Jervin R · in MySQL

OR conditions are normally difficult to optimize when used on different columns, a pain when the columns are of range conditions and worst when done between 2 or more different tables. Look at my example below, the original query  is…

Recent Comments

  • Reduce Stack Frame Depth from XDebug Trace Output on Identify Bottleneck on your PHP Scripts with XDebug Code Trace
  • daphatmac on Apache Running on Multiple Ports and Percona Cacti Templates for Apache

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Copyright © 2013 dotmanila

Powered by WordPress and Origin