Testing ERPnext 700,000 rows of data

Install / Update Deployment
16
  • Fine Tuning

max_connections = 10
max_allowed_packet = 128M
sort_buffer_size = 64M
bulk_insert_buffer_size = 128M
tmp_table_size = 256M
max_heap_table_size = 256M

  • MyISAM

key_buffer_size = 512M
myisam_sort_buffer_size = 1G
read_buffer_size = 64M
read_rnd_buffer_size = 32M

query_cache_limit = 2M
query_cache_size = 256M

*Inno DB
innodb_buffer_pool_size = 1G