I have a master mysql server which has approached 80% of the available disk space. Total disk space size is 200GB. Though, it's not an immediate concern but I have to deal with at some point soon. the data directory is mounted on to logical volume.
--- Logical volume ---
LV Path /dev/mysql/data
LV Name data
VG Name mysql
LV UUID UNse6Y-QgCX-Ap6D-UXvr-VXs5-r8dc-g91Vhn
LV Write Access read/write
LV Creation host, time localhost, 2012-09-19 15:22:49 +0100
LV Status available
# open 2
LV Size 200.00 GiB
Current LE 51200
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 256
Block device 253:3
And this is mounted under /data directory.
/dev/mapper/mysql-data /data reiserfs defaults,noatime,nodiratime,notail,data=writeback 0 1
Unfortunately, the binary logs are located inside the the /data directory.
# grep -i log-bin /etc/my.cnf
log-bin = /data/binlog/mysql-bin.log
I am looking for the best option to increase the disk space and or moving the binary logs to a separate disk location without having to restart mysql or with minimal downtime?
The database version is:
mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+---------------------+
| Variable_name | Value |
+-------------------------+---------------------+
| protocol_version | 10 |
| version | 5.1.61-log |
| version_comment | Source distribution |
| version_compile_machine | x86_64 |
| version_compile_os | redhat-linux-gnu |
+-------------------------+---------------------+
5 rows in set (0.00 sec)
Is there any good solution? Please help.