Temp space full?

[steve]

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

[Felix Geerinckx]

On 19/04/2005, steve wrote:

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.

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

--
felix

[steve]

"steve" wrote:

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.

bump

[steve]

"Felix Geerinckx" wrote:

On 19/04/2005, steve wrote:

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.

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

--
felix

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