Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Instant Magento Performance Optimization How-to
  • Table Of Contents Toc
  • Feedback & Rating feedback
Instant Magento Performance Optimization How-to

Instant Magento Performance Optimization How-to

By : Nayrolles Mathieu (USD), Mathieu Nayrolles
3.9 (14)
Buy this Book
close
close
Instant Magento Performance Optimization How-to

Instant Magento Performance Optimization How-to

3.9 (14)
By: Nayrolles Mathieu (USD), Mathieu Nayrolles
Buy this Book

Overview of this book

The optimization of an attractive commercial website is a non-trivial task that demands time and knowledge. Optimization is a critical point for all growing businesses because a misconfiguration could make you lose money, a lot of money. If your server is overloaded, a browser that wants to turn into a buyer will not be able to, and you will lose customers. "Instant Magento Performance Optimization How-To" is a practical, hands-on guide that provides you with a number of clear, step-by-step exercises to help you reach a high performance level for your Magento stores and keep your customers satisfied.This book looks at tweaks and tips used to boost your Magento Performance, and breaks down the confusion that surrounds the subject.You will learn how to compress your pages, styles, and scripts by almost 80%. We will also take a look at controversial optimization settings such as Magento core compilation or enabling all caching systems. You will discover new applications that improve performance. If you wish your e-businesses to grow and want to keep your customers satisfied, you definitely need this book.
Table of Contents (7 chapters)
close
close
close
Instant Magento Performance Optimization How-to
Icon
Instant Magento Performance Optimization How-to
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewer
Icon
About the Reviewer
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Lock Free Chapter
1
Instant Magento Performance Optimization How-to
chevron up
Icon
Instant Magento Performance Optimization How-to
Icon
Merging CSS files (Must know)
Icon
Merging JavaScript (Must know)
Icon
Logging files (Must know)
Icon
Compiling (Must know)
Icon
Managing the index (Must know)
Icon
Removing PayPal's logo (Must know)
Icon
Using the Magento caching system (Must know)
Icon
Enhancing the expiration date (Should know)
Icon
Keeping your connections alive (Should know)
Icon
Storing your sessions in the database (Should know)
Icon
Configuring MySQL (Should know)
Icon
Using a memory-based filesystem for caching (Become an expert)
Icon
Compressing your code – gzip (Become an expert)
Icon
Installing a PHP accelerator (Become an expert)
Icon
Clustering (Become an expert)
Icon
Balancing load (Become an expert)
Icon
Replicating the database (Become an expert)
Icon
Checking the configuration (Must know)
Icon
Clearing caches (Must know)
Icon
Logging (Must know)
Icon
Using template hints (Must know)
Icon
Using the Profiler (Should know)
Icon
Using a debugger (Should know)

Configuring MySQL (Should know)

The MySQL default configuration is really safe. Indeed, MySQL developers want their product to be run on all servers, even smaller ones. If you have a server with RAM greater than 1 GB, you can definitely improve your MySQL. You can also, periodically, select all the tables in your MySQL Manager and apply the repair and optimize commands.

How to do it...

Open the file named my.cnf in the root directory of your MySQL installation and modify it as follows:

key_buffer = 512M
max_allowed_packet = 64M
table_cache = 512
sort_buffer_size = 4M
net_buffer_length = 8K
read_buffer_size = 4M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
tmp_table_size = 128m
query_cache_size = 96m
query_cache_type = 1
thread_cache_size = 8
max_connections = 400
wait_timeout = 300
thread_concurrency = (Computer CPU'S * 2)

How it works...

The efficiency of these settings depends on the number of articles and categories present on your website, but the key point is to allow MySQL to use the server's RAM in a more intensive way. When a query is cached, its result (that is, the data sent to the client) is already known and stored somewhere in the cache. Therefore, the MySQL server can directly send the response without processing the request.

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Instant Magento Performance Optimization How-to
End of Section 1
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon