385
385
mysql_config['key_buffer'] = self.human_to_bytes('32M')
386
386
total_memory = self.human_to_bytes(self.get_mem_total())
388
dataset_bytes = config.get('dataset-size', None)
388
log("Option 'dataset-size' has been deprecated, instead by default %d%% of system \
389
available RAM will be used for innodb_buffer_pool_size allocation" %
390
(self.DEFAULT_INNODB_BUFFER_FACTOR * 100), level="WARN")
389
392
innodb_buffer_pool_size = config.get('innodb-buffer-pool-size', None)
391
394
if innodb_buffer_pool_size:
392
395
innodb_buffer_pool_size = self.human_to_bytes(
393
396
innodb_buffer_pool_size)
395
log("Option 'dataset-size' has been deprecated, please use"
396
"innodb_buffer_pool_size option instead", level="WARN")
397
innodb_buffer_pool_size = self.human_to_bytes(
398
if innodb_buffer_pool_size > total_memory:
399
log("innodb_buffer_pool_size; {} is greater than system available memory:{}".format(
400
innodb_buffer_pool_size,
401
total_memory), level='WARN')
400
403
innodb_buffer_pool_size = int(
401
404
total_memory * self.DEFAULT_INNODB_BUFFER_FACTOR)
403
if innodb_buffer_pool_size > total_memory:
404
log("innodb_buffer_pool_size; {} is greater than system available memory:{}".format(
405
innodb_buffer_pool_size,
406
total_memory), level='WARN')
408
406
mysql_config['innodb_buffer_pool_size'] = innodb_buffer_pool_size
409
407
return mysql_config