Walt Weaver wrote:
Hi,
I have a job runnning that's modifying a column on a 15-million-row table
and is throwing out the following error:
Output: Replication Error 1114, slave: replicatenj07, error: Error 'The
table '#sql-5303_3c' is full' on query. Default database
'customer__upgrade'. Query: ALTER TABLE inc_performance MODIFY COLUMN.....
This indicates to me that the temp table is full. Problem is, I'm not sure
what config parm or whatever needs to be changed to allow the temp table to
grow sufficiently.
Can someone push me in the right direction on what to change, or if I'm
barking up the wrong tree, show me which tree to bark at?
Thanks,
--Walt Weaver
Bozeman, Montana
Walt,
Run
mysql> show variables;
There are several config options for temp stuff such as size &
directory. I don't know the syntax to change these off the top of my
head but it should point you to the correct "tree".
:-)
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
