How can I use as much disk space as possible in MySql automatically?
I have a service that create a MySql database everyday. And the every database will be filled with about 40G data after created.
These databases are located in /data/mysql_data now. There is no doubt that /dev/sda4 will be full after decades of days. But as you can see below, I still has a lot spaces in /dev/sdb and /dev/sdc.
My question is: what's the best way to make MySql to use /dev/sdb (and then /dev/sdc) automatically after /dev/sda4 is full?
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 9.9G 4.9G 4.5G 53% /
/dev/sda3 20G 812M 18G 5% /usr/local
/dev/sda4 885G 220G 621G 27% /data
tmpfs 3.9G 68K 3.9G 1% /dev/shm
/dev/sdb 3.6T 783G 2.8T 22% /data1
/dev/sdc 3.6T 924G 2.7T 26% /data2
Thx a lot!
Last edited by unlike; 02-11-2014 at 07:02 AM.