Magento provides a really handy options to scale well. The feature which i am going to talk about is very little know. Magento allows to add mysql slave server to put load of “read” queries on different server. The mysql server has to do a lot of things like adding and updating records at high [...]
Magento allows to configure multiple ways to search in catalog. For community edition these options are “Like”, “Fulltext” and “Combine”. Like is the default method selected, but this is not the best method and is more resource consuming. For better performance and results, “Fulltext” should be selected in this configuration. You can configure selection time [...]
Magento provides a rich admin panel to manage all aspects of store(s). Admin panel operations are resource consuming because it does not use much cache etc. The pages also consume more memory. So its good idea to dedicate a separate web server for admin panel operations. This way one may customize certain setting for admin [...]
There are few things which can be done in php configuration to help speed up Magento site. Realpath Cache: A lot of file I/O is done to run Magento site. This file I/O can be improved with faster hard disk. There is more can be done to improve this. PHP configuration allows to configure size [...]
One important feature Magento provides for improved performance is “Flat Products and Categories”. Magento stores data of single product in multiple tables. Like name is stored in catalog_product_entity_varchar table, id is stored in catalog_product_entity_int table, price is stored in catalog_product_entity_decimal table. Under this scheme, in order to fetch a product data must be fetched from [...]
This is the first of the series “Magento Performance”. In this post focus will be on tuning up MySQL server to make it optimal for Magento site. MySQL is most potential area for optimization. Optimizing its configuration can give good boost in performance. There are several configurations which should be considered. Memory Magento uses InnoDB [...]
Magento performance is really a difficult topic to write about. Performance has been in discussion and under a lot of criticism since the start. In my opinion its performance has been under heavy criticism unjustifiably, because there are a lot of rich features which come at some cost. Magento is continuously improving on performance, and [...]
Magento’s Enterprise Edition 1.8 is released. One interesting feature it introduces is “Solr” for full text searching. Solr is open source, very fast full text search engine from Apache project. More Solr features include hit highlighting, clustering, db integration, faceted search, and rich document (e.g., Word, PDF) handling. Solr is very similar to SPHINX. You [...]
Have anyone ever got 4294967293 private message on a single forum? I am certain that no one have got this much messages. Recently my account link in Magento forum showed me that I have 4294967293 messages in my inbox (see the image). Actually there were no messages at all. This is probably due to invalid [...]
While working on importing products in Magento, I was getting timeout errors a lot like Fatal error: Maximum execution time of 60 seconds exceeded in c:\xxxxxxx\lib\Zend\Db\Statement\Pdo.php on line 228 etc etc. This error was mostly generated when importing products, exporting products re indexing large indexes like fulltext search index etc. One solution I found on [...]
