Book Image

Magento 1.8 Development Cookbook

By : Bart Delvaux, Nurul Ferdous
Book Image

Magento 1.8 Development Cookbook

By: Bart Delvaux, Nurul Ferdous

Overview of this book

<p>Magento is an open source e-commerce platform which has all the functionality to function from small to large online stores. Its architecture makes it possible to extend the functionalities with plugins where a lot of them are shared by the community. This is the reason why the platform is liked by developers and retailers.</p> <p>A practical developer guide packed with recipes that cover all the parts of Magento development. The recipes will start with the simple development exercises and get the more advanced as the book progresses. A good reference for every Magento developer!</p> <p>This book starts with the basics. The first thing is to create a test environment. Next, the architecture, tools, files and other basics are described to make you ready for the real work.</p> <p>The real work starts with the simple things like theming and catalog configuration. When you are familiar with this, we will move on to more complex features such as module and database development. When you have survived this, we will move on to the last part of making a shop ready for launch: performance optimization and testing. This book will guide you through all the development phases of Magento, covering the most common pitfalls through its recipes.</p>
Table of Contents (19 chapters)
Magento 1.8 Development Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Optimizing the database and MySQL configuration


When scaling a Magento website, you will have one part that will be a hard job and that is the MySQL database. You can scale your shop with multiple servers but the database is a central storage of all the data of the website, which is not so easy to scale because everything needs to be in sync. In this recipe, we will optimize the Magento MySQL database and the MySQL server.

Getting ready

Log in to phpMyAdmin and navigate to the next page that shows the information about the database.

How to do it...

The first step is to optimize the table structures of the Magento database. Take a look at the following procedure:

  1. When you are in phpMyAdmin, click on the Magento database, and you will see the table overview.

  2. At the bottom of this page, click on the check all button.

  3. When you click on the drop-down list, you can repair the table and optimize it, as shown in the following screenshot:

    Tip

    Make sure you run this action for all the tables in the Magento...