News Categories
News (53) database (1) optimization (1) optimization tips (1) halloween (1) e-commerce (2) online marketing (1) product description (1) MageWorx community manager (1) MageWorx team (1) Facebook contest (1) MageWorx competition (1) Magento customers (1) magento extension (1) brand marketing (1) business promotion (1) pinterest (1) content marketing (1) link building resources (1) seo resources (1) social marketing (1) ecommerce (2) magento merchants (1) mageworx clients (1) 404 error page (1) page not found (1) web design (1) Facebook creative ideas (1) Facebook timeline (1) Timeline cover (1) happy customers page design (1) reviews page design (1) testimonials page design (1) success stories (10) ecommerce trends (1) social shopping (1) magento design (1) magento showcase (1) magento store examples (1) ecommerce tips (2) infographic (1) magento brands (1) digital marketing (1) seo optimization (1) Uncategorized (1) image optimization (1) image seo (1) rich snippets in magento (1) Magento Extensions (3) extended reports extension (1) magento extensions (2) shipping suite extension (1) Magento store (1) mageworx (1) mageworx giveaway (1) how to sell online (1) Magento improvement in 2014 (1) steps to success (1) ecommece in gif (1) magento experts (1) magento experts on twitter (1) halloween magento fun (1) Meet Magento New York (1) easter egg hunt (2) easter game (2) easter (1) magento (4) magento extentsions (1) online contest (1) shoppimon review (1) magento seo (1) seo suite ultimate (1) seo suite ultimate update (1) community management (1) magento community (1) sherrie rohde interview (1) meet magento (2) magento 2.0 (1) mm14ch (1) switzerland (1)
RSS Feed
News
Nov
9
How to optimize database to speed Magento up | Small tips
Posted by antoine on 09 November 2011 08:22 AM

Trying to provide quality support of all our extensions, we work with a great number of Magento stores. Every customer is unique for us and we try to offer individual approach to everyone. We also examine each Magento store performance and the reasons of slow work. We found some common reasons, which can be applied almost to every store. The problem is quite simple. It’s database default settings that don’t allow your Magento to work like you want. These settings are:

  • innodb_buffer_pool_size
  • innodb_additional_mem_pool_size
  • key_buffer_size

Most Magento stores have the default values for them (8Mb, 1Mb and 8Mb accordingly). We’ll try to describe what settings mean and how you can change them.

1) Let’s start with “key_buffer_size”. It is responsible for the buffer of the indexes of MyISAM database. These indexes are used in Magento only for fulltext search products in the tables like “catalogsearch_fulltext” and others. That’s why we recommend to set the size of “key_buffer_size” setting to be equal to the size of this table (“catalogsearch_fulltext”). If you regularly add more products, the size of this table will be increased. It’s better to specify the value for “key_buffer_size” with some reserve for such changes.

If you setup several Magento on one server, this setting should be the sum of sizes of “catalogsearch_fulltext” table in all your Magento stores.

2) The next setting is “innodb_buffer_pool_size”. It’s one of the most important parameters for work with innoDB tables and indexes.

Example: if your server has 1Gb RAM, it’s better to allow the following settings to use 30-40% of this memory: innodb_buffer_pool_size + innodb_additional_mem_pool_size + key_buffer_size

innodb_buffer_pool_size = 320 Mb
innodb_additional_mem_pool_size = 30 Mb
key_buffer_size = 50 Mb

There are also many other minor settings that you should check. But for that we recommend to contact your hosting provider or system administrator. Please note, that none extension will speed up your Magento if you do not optimize your database.


Comments (2)
Paul
21 February 2012 07:11 AM
Hey, love your extensions, great job.

I have a question you might have an answer for, we've been looking for weeks finding a solution, or at least some more information. Please check here if you can/want to help others with the same question:
http://www.magentocommerce.com/boards/viewthread/273623/


Thanks a lot,
Paul.
MageWorx Support
22 February 2012 09:49 AM
Hello Paul,

It's better to submit a support ticket with this request. Our team will look into your database and try to help you.
Post a new comment 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.