# Run a 64-bit operating system. Do not exceed 2GB memory for the following # combination on 32-bit systems: # innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size + # read_buffer_size + binlog_cache_size) + max_connections*2MB # On dedicated db server assign up to 80% of free memory to innodb buffer # On combined web/db server take into account apache instances and php innodb_buffer_pool_size = 768M #Data Page Memory Buffer # Table metadata requires 2-16M, Magento only has abt 330 tables innodb_additional_mem_pool_size = 2M #Data Dictionary < 16M # SHOW GLOBAL STATUS Innodb_log_waits should be 0 or the next setting # innodb_log_file_size is too small. Holds changed data for lazy write to # innodb database. To change size, database must be flushed to disk, database # backed up, mysqld server must be downed, log files renamed, change # my.cnf and mysqld brought back up. Log files will be recreated in # proper number and size innodb_log_file_size = 100M #Transaction Log up to 1/4 Buffer Pool #innodb_log_files_in_group = 2 #Default is 2 # Buffer for transactions to be written to log file innodb_log_buffer_size = 2M #Transaction Memory Buffer 1-8M #Recommended (2xcores)+disks, KEEP LOW < 16 More is not better tune for #best performance innodb_thread_concurrency = 3 #Set this up before you install Magento. Create primary innodb table at 2GB #and secondary autoextend table for growth #Changing this after you've gone live requires eliminating the ibdata files and log files innodb_data_file_path = ibdata1:2048M;ibdata2:50M:autoextend #Amount to add on autoextend. Keep this large to keep blocks in file contiguous innodb_autoextend_increment = 512M |