Tag Archives: database

Apr 15

  • Created: Apr 15, 2011 2:33 PM

Logging Database Queries in Magento

Logging Database Queries in Magento
In previous weeks, we’ve covered some debugging tools for both MySQL and PHP that can be very helpful in troubleshooting problems with your LAMP-based web applications. However, there is a little known feature in the Varien library installed with Magento that will automagically log database queries to a file. This feature not only provides a great deal of insight into the behind-the-scenes functionality of Magento, it also helps you to debug slow-running queries and other Model-based performance problems. Read more

Mar 11

  • Created: Mar 11, 2011 12:00 PM

Upgrading to Magento 1.5.0.1

Upgrading to Magento 1.5.0.1
Magento version 1.5.0.1 was released on February 9th, 2011. It adds a number of performance improvements in the areas of dataflow and checkout, and comes with the hot new Magento Mobile module installed. While we have not run into the same sorts of upgrade woes that plagued the 1.3 and 1.4 releases, the upgrade method itself has changed due to the new Magento Connect version 2.

Here at Nexcess, we perform upgrades via the command line, as it is quicker and we can better see what is happening should anything go wrong. The old tool for upgrading via SSH was the “pear” installer that came bundled with Magento. With the release of Magento 1.5.x, this tool will no longer work. Read more