distal-attribute
distal-attribute
distal-attribute
distal-attribute

How to Adjust database size

setman590 posted 9 months ago in General
Hi guys,

I was trying to find out how to make one of my database's larger. I noticed that a file in one of my databases is 2.7MiB.It is still in the green right now, but not sure for how long. Someone told me to run : SHOW VARIABLES LIKE '%buffer%';

This is what comes up

bulk_insert_buffer_size 8388608
innodb_buffer_pool_instances 1
innodb_buffer_pool_size 112197632
innodb_change_buffering all
innodb_log_buffer_size 2097152
join_buffer_size 131072
key_buffer_size 57671680
myisam_sort_buffer_size 72351744
net_buffer_length 16384
preload_buffer_size 32768
read_buffer_size 65536
read_rnd_buffer_size 262144
sort_buffer_size 262144
sql_buffer_result OFF

Still new at this, so I don't know what to adjust.

Thanks
fyrye posted 9 months ago
In the case of MySQL, you would need to edit your my.cnf file and edit the server variables then restart the database server.

There is technically only a true limit on database size based on the hard drive space the database server is saving data to.

SHOW VARIABLES LIKE '%datadir%';
datadir

SHOW VARIABLES LIKE 'innodb_data%';
innodb_data_file_path

innodb_data_home_dir

If you see max:** in the innodb_data lookup, you would need to increase the max value.

Buffer is only the memory buffer (temporary) used by the database as records are retrieved to lessen the load on the disk. And the buffer is cleared on server restart. This is more of a performance setting of the database server.

Please login to leave a reply, or register at first.