Mysql out of disk space

Posted by Paddy on Server Fault See other posts from Server Fault or by Paddy
Published on 2010-03-22T10:39:38Z Indexed on 2010/03/24 1:43 UTC
Read the original article Hit count: 601

Filed under:

mysql-management

|

diskspace

|

ruby-on-rails

I have just finished developing a rails app which has a mysql db as a backend.
The app is meant for high traffic and will store lots of information. I am planning to set up my own web server and host the site from it.

If in future my disk space runs out i would want to expand by adding more space.
But say if my mysql database is housed in my /disk0s1 and by adding a new drive i have more partitions (and hence more disk space), how then would i extend my database to store information on those partitions too, and at the same time prevent any information from being written on the original partition. Should i go for multiple databases? if so how?

If i went for a hosting solution i wouldn't be bothering about this as i would just have to worry about making payments for the extra space :)
I always wondered how space is added on-the-go by these webhosts.
Is there any specific mysql configuration that i have to make?

© Server Fault or respective owner

Related posts about mysql-management

Mysql out of disk space

as seen on Server Fault - Search for 'Server Fault'
I have just finished developing a rails app which has a mysql db as a backend. The app is meant for high traffic and will store lots of information. I am planning to set up my own web server and host the site from it. If in future my disk space runs out i would want to expand by adding more space… >>> More
mysql never releases memory

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a production server clocking about 4 million page views per month. The server has got 8GB of RAM and mysql acts as a database. I am facing problems in handling mysql to take this load. I need to restart mysql twice a day to handle this thing. The problem with mysql is that it starts with some… >>> More
How to know about MySQL 'refused connections'

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am using MONyog to montitor my two mysql servers. I get alert emails from MONyog when something goes wrong. There is an error I could not find out why. It says: Connection History: Percentage of refused connections) - 66.67% the percentage is not important, this is just about having… >>> More
Mysql out of disk space

as seen on Stack Overflow - Search for 'Stack Overflow'
I have just finished developing a rails app which has a mysql db as a backend. The app is meant for high traffic and will store lots of information. I am planning to set up my own web server and host the site from it. If in future my disk space runs out i would want to expand by adding more space… >>> More
How to make mysql accept connections externally

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a VPS and I want to make mysql DB accept connection externally (from my PC for instance). I have Debian Linux installed on the server. I checked some tutorials online and they said to comment out: bind-address = 127.0.0.1 But this didn't seem to help! is there anything specific… >>> More

Related posts about diskspace

diskspace in ubuntu

as seen on Super User - Search for 'Super User'
I have installed windows and ubuntu side by side .and given the diskspace of 10GB in an another drive partition.after using two moths i have installed some software to it no it's not starting and writing on the screen that there is no diskspace so could not be started . what can i do now?but at starting… >>> More
scritp to create automatically ext4 and swap in unallocated diskspace

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
i've to install a number of machines. Some machines have windows 7 installed. Some machines not. The machines have 0 or 2 or 3 partitions. Every machine has enough free diskspace (20 to 250 GB) I installed an "golden client" and build an tar archiv of this client. Now, every client boots up a small… >>> More
nginx tmp file folder runing out of diskspace

as seen on Server Fault - Search for 'Server Fault'
I get mysql diskspace error Can't create/write to file '/tmp/#sql_777_0.MYI' (Errcode: 28) mainly because my ngnix server is writing file into the tmp folder which doesn't get clean up.. i added this command as per instructions on the nginx manual to the crontab but doesn't seems to be doing… >>> More
Mysql out of disk space

as seen on Server Fault - Search for 'Server Fault'
I have just finished developing a rails app which has a mysql db as a backend. The app is meant for high traffic and will store lots of information. I am planning to set up my own web server and host the site from it. If in future my disk space runs out i would want to expand by adding more space… >>> More
Checkpoint FW-1disk full

as seen on Server Fault - Search for 'Server Fault'
Hi, The logging filled the disk of the managment node. This cause the firewall nodes to start logging locally. After deleting some old logs, restarting the managment node logging is still being done locally at the firewall nodes. I have already done a fw fetchlogs on all firewall nodes to get the… >>> More