Optimizing MySQL database for Magento on Amazon EC2 server
For KOOLSKOOL we use Amazon EC2 server. Magento is a very powerful ecommerce platform but like any real world application, it needs real server bandwidth.One of the simple ways to optimize the speed is to optimize the MySQL server. The configuration I have used on my EC2 large server is as follows. (This is not a dedicated MySQL server and I am also running apache on this) old_passwords=1 key_buffer = 384M max_allowed_packet = 1M table_cache = 32M sort_buffer_size = 10M read_buffer_size = 10M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 16 query_cache_type = 1 query_cache_size = 48M max_connections=500 wait_timeout=120 tmp_table_size = 64M max_heap_table_size = 64M innodb_log_file_size = 100M innodb_log_buffer_size = 4M innodb_buffer_pool_size = 2048M innodb_additional_mem_pool_size = 20M innodb_flush_log_at_trx_commit = 1 innodb_flush_method=O_DIRECT innodb_thread_concurrency=8 [mysqld_safe] #log-error=/var/log/mysqld.l...