Temp space full?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • steve
    #1

    Temp space full?

    Hi,
    I am trying to help my hosting company figure out how to support my
    db. I have a huge db, and they did not set up their box to have a
    large enough temp(?) space for mysql to play in. As such I was
    getting weird index corruptions.

    They are telling me that they cannot reorganize their disks, since
    there are other users on that machine.

    Is it possible to do a symbolic link (or something like that) so that
    the temp space for mysql is moved to another space on the directory
    tree that has more space. What are the mechanisms to do that. I am
    using the word ’temp’ loosely, since I don’t know exactly how that
    works.

    Please help me figure this out.

    --
    Posted using the http://www.dbforumz.com interface, at author's request
    Articles individually checked for conformance to usenet standards
    Topic URL: http://www.dbforumz.com/mySQL-Temp-s...ict215765.html
    Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=739459
    Tags: None
    • Felix Geerinckx
      #2
      Re: Temp space full?

      On 19/04/2005, steve wrote:
      [color=blue]
      > I am trying to help my hosting company figure out how to support my
      > db. I have a huge db, and they did not set up their box to have a
      > large enough temp(?) space for mysql to play in. As such I was
      > getting weird index corruptions.
      >
      > They are telling me that they cannot reorganize their disks, since
      > there are other users on that machine.[/color]

      See http://dev.mysql.com/doc/mysql/en/temporary-files.html

      --
      felix

        Comment

        • steve
          #3
          Re: Temp space full?

          "steve" wrote:[color=blue]
          > Hi,
          > I am trying to help my hosting company figure out how to
          > support my db. I have a huge db, and they did not set up
          > their box to have a large enough temp(?) space for mysql to
          > play in. As such I was getting weird index corruptions.
          >
          > They are telling me that they cannot reorganize their disks,
          > since there are other users on that machine.
          >
          > Is it possible to do a symbolic link (or something like that)
          > so that the temp space for mysql is moved to another space on
          > the directory tree that has more space. What are the
          > mechanisms to do that. I am using the word 'temp' loosely,
          > since I don't know exactly how that works.
          >
          > Please help me figure this out.[/color]

          bump

            Comment

            • steve
              #4
              Re: Re: Temp space full?

              "Felix Geerinckx" wrote:[color=blue]
              > On 19/04/2005, steve wrote:
              >[color=green]
              > > I am trying to help my hosting company figure out how to[/color]
              > support my[color=green]
              > > db. I have a huge db, and they did not set up their box to[/color]
              > have a[color=green]
              > > large enough temp(?) space for mysql to play in. As such I[/color]
              > was[color=green]
              > > getting weird index corruptions.
              > >
              > > They are telling me that they cannot reorganize their disks,[/color]
              > since[color=green]
              > > there are other users on that machine.[/color]
              >
              > See http://dev.mysql.com/doc/mysql/en/temporary-files.html
              >
              > --
              > felix[/color]

              Thanks, that does it!

              --
              Posted using the http://www.dbforumz.com interface, at author's request
              Articles individually checked for conformance to usenet standards
              Topic URL: http://www.dbforumz.com/mySQL-Temp-s...ict215765.html
              Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=740272

                Comment

                Previous template Next
                Working...