MySQL Configuration Changes to boost Magento Performance

MySQL Configuration Changes to boost Magento Performance

innodb_buffer_pool_size  50% of available RAM

innodb_thread_concurrency = 2 * [numberofCPUs] + 2
innodb_flush_log_at_trx_commit = 2
thread_concurrency = [number of CPUs] * 3
thread_cache_size = 32
table_cache = 1024
query_cache_size = 64M
query_cache_limit = 2M
join_buffer_size = 8M
tmp_table_size = 256M
key_buffer = 32M
innodb_autoextend_increment=512
max_allowed_packet = 16M
max_heap_table_size = 256M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_max_extra_sort_file_size = 10G
myisam_repair_threads = 1

 

As seen on:  http://www.mgt-commerce.com/blog/magento-on-steroids-best-practice-for-highest-performance/

 

MySQL Configuration Changes to boost Magento Performance

Magento Re-index manually

Use this shell command to kick off manual re-indexing of the Magento DB.  

php shell/indexer.php --reindex


Keep an eye on any error messages. Magento not that grate in reporting on hanged re-indexing jobs.
MySQL Configuration Changes to boost Magento Performance

Creating SSL SAN certificates and CSRs using OpenSSL

For information about creating SSL SAN certificates and CSRs using the Configuration utility or tmsh in 11.1.x and later, refer to the following article:

Subject Alternative Name (SAN) certificates or Unified Communication (UCC) certificates allow control of the subject alternative name field to secure multiple domains through the use of a single certificate. This type of certificate is similar to a wildcard certificate; however, it allows you to specify multiple alternative domains instead of a single domain, as in a wildcard certificate.

Creating a self-signed SAN/UCC certificate or certificate request

Note: You may want to check with your Certificate Authority (CA) to see if tools are available to make this process easier. While you can perform this process from the command line using OpenSSL, there are quite a few steps involved. Creating multiple certificates using this method may be time consuming.

(more…)

READY FOR A CHANGE?

If you're ready to change the way your small business feels about technology, then we'd love to hear from you.