Archive: debug

Just came across this forum post of MySQL that looks to be a gold mine of information related to performance tuning MySQL. For reference I am copying and pasting the full thing here though all credit goes to the above. Book: High Performance MySQL (2nd Edition) http://www.highperfmysql.com/ MySQL Performance Tuning – Best Practices: http://jpipes.com/presentations/perf_tuning_best_practices.pdf MySQL [...]

If you need to track down exactly how and when a particular change happened and you are not even sure exactly where it is (perhaps because its no longer present but you are not totally sure where it was supposed to be) then this little trick can be a life saver. You can search git [...]

I’ve just spent to long trying to fix an infuriating problem with a simple fix. If you create a new theme from scratch and suddenly realise that none of your magento javascript is working, it could be because you’ve included jQuery and forgotten to include the noConflict argument. If you have included jQuery, then make [...]

If you prefer a coding style that doesn't let you get away with as much as PHP does by default then you may like this trick. As standard PHP will let you get away with quite a lot of things that are probably not a good idea. Some times that can be great, allowing you [...]

Magento has some great exception logging functionality which is invaluable when trying to figure out why things aren't working. However, like a lot of settings in Magento, its tucked away in the configuration and its not always easy to remember how to enable it. So here it is: System->Configuration->Developer->Log Settings Once its enabled, the log [...]

If you are working with collections and would like to verify that the actual SQL being used is what you expect it to be then this little tip might prove really handy. For any collection you can call the method getSelect(). This retrieves the actual Select object that handles the query. If you cast this [...]

If you develop using Zend Framework you will know that it is sometimes tricky to see exactly whats going on in terms of SQL queries. After trying a few different ideas including subclassing the database classes or other complex systems, the easiest I have found is this: 1. Edit your app.ini config file and add [...]