PHP/MySQLi Debugger Tool?

  • Bogey
  • Genius
  • Genius
  • Bogey
  • Posts: 8397
  • Loc: USA

Post 3+ Months Ago

Is there a PHP/MySQLi debugger tool out there that I could use to see the amount of SQL queries i run per page, the total generation time it takes to generate each page and other statistics? One I could use on XAMPP locally on my machine? Thank you!
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9090
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

With my local setups I use Xdebug to step through PHP programs I write. I use WAMP and Eclipse PDT, and they work well together for this. Xdebug also has a profiler included that might allow you to do what you are looking for, I am not entirely sure:

http://xdebug.org/docs/profiler

For my newer stuff I am working on I actually have a built-in visual profiler that works with Codeigniter's profiler and ends up looking like this:

Attachments:
profiler-load-time.jpg

Shows the load time of the page, and how long some of the major components took to load.


Attachments:
profiler-memory.jpg

Shows the memory usage of the PHP that ran to produce the page.


Attachments:
profiler-mysql-queries.jpg

Shows the MySQL queries, how long each part took on a query, and then at the bottom the total execution time to run all the queries.



Since you have access to the beta version of Ozzu, you are welcome to play with it while everyone still has access to that tool there. If you goto the beta website you will see a little green bug in the bottom corner. Click on it after you load any page and you can see all the statistics about it.

While my version is highly customized, it is based off of Particletree's PHP Quick Profiler, so you might check that out if you want to have a version for your website.

Hope that helps!

Post Information

  • Total Posts in this topic: 2 posts
  • Users browsing this forum: No registered users and 136 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.