My MySQL program is on /. If I move my databases to a partition (a separate hard-disk drive) mounted on /tee, then reads and writes (MySQL queries) take an exceedingly long time: many times more than the same reads and writes when the databases are on /. What can I do to improve this? Any advice would be most welcome.
Note that reading and writing /tee seems to be pretty quick other than in MySQL: for example,
/tee$ for i in {1..100}; do find >> find; done
took 18 seconds. (find |wc -l yields 15010.)
Note also that df -T yields:
Filesystem Type 1K-blocks Used Available Use% Mounted on
/dev/mapper/HCG--Linux--01-root ext4 124241852 117926300 0 100% /
none tmpfs 4 0 4 0% /sys/fs/cgroup
udev devtmpfs 8199904 4 8199900 1% /dev
tmpfs tmpfs 1641948 356 1641592 1% /run
none tmpfs 5120 0 5120 0% /run/lock
none tmpfs 8209724 0 8209724 0% /run/shm
none tmpfs 102400 0 102400 0% /run/user
/dev/sda1 fuseblk 2930232316 46281132 2883951184 2% /tee
/dev/sdb1 ext2 233191 160033 60717 73% /boot
Obviously, I want this question to be useful to future users with a similar problem, so a general answer addressing many users' concerns would be ideal. Hence, I didn't supply many details. But I don't know whether what I have provided is sufficient. I'll be very glad to supply any details that I need to provide to strike the correct balance so this is both answerable and broadly applicable, if someone comments on this question advising me what those details are.
