Results 1 to 5 of 5
  1. #1

    mysql partition full - symlink?

    Hey guys. My /tmp is completely full.. I know this is where mysql stores its databases. Someone told me once before it's possible to symlink it to something on another partition / so no code or anything has to change. Ever heard of this? any help would be greatly apreciated. Thanks!

  2. #2
    I thinks you should umount your /tmp partition.
    Support Facility | 24/7 web hosting technical support services
    Technical support | Server management | Data migration

    Technical Articles

  3. #3
    Join Date
    Dec 2006
    Yes, you can symlink mysql database files or folders, but unless you've done something bizarre in your my.cnf configuration, databases should not be in /tmp

  4. #4
    Join Date
    Nov 2005
    MySQL does not store databases in /tmp, however it does occasionally use it for temporary space during complicated queries. A full /tmp can cause MySQL to be unhappy.

    Rather than trying to figure out how to make more room on /tmp, you should probably be looking to see *why* /tmp is so full. The point of /tmp is for *temporary* storage, so if some large files are stuck there for a long time then it is usually an issue elsewhere on your server.

  5. #5
    Join Date
    Jan 2005
    Scotland, UK
    If you have a pretty large data set it's possible your /tmp partition is just too small, create a new directory mysql can write to on a bigger partition and define tmpdir in mySQL (you will need to restart mySQL as this is a read only var).
    Server Management -
    Infrastructure Management, Web Application Performance, mySQL DBA. System Automation.
    WordPress/Magento Performance, Apache to Nginx Conversion, Varnish Implimentation, DDoS Protection, Custom Nginx Modules
    Check our wordpress varnish plugin. Contact us for quote: [email protected]

Similar Threads

  1. /var partition full due to big MySQL Database
    By sh4ka in forum Hosting Security and Technology
    Replies: 14
    Last Post: 09-11-2009, 08:22 AM
  2. ERROR: The partition with /var/lib/mysql is too full!
    By jjk2 in forum Programming Discussion
    Replies: 6
    Last Post: 06-19-2009, 03:07 AM
  3. /usr nearly full, move and symlink check/ effect on Apache?
    By tfc in forum Hosting Security and Technology
    Replies: 9
    Last Post: 08-17-2004, 05:52 PM
  4. / partition is getting full
    By MGCJerry in forum Dedicated Server
    Replies: 3
    Last Post: 01-06-2004, 07:19 AM
  5. Creating a SymLink for MySQL
    By Sonic Blue in forum Hosting Security and Technology
    Replies: 1
    Last Post: 11-22-2002, 09:40 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts