----- Original Message -----
From: "Egor Egorov" <egor.egorov@stripped>
Sent: Monday, September 06, 2004 1:21 PM
Subject: Re: MySQL 4.1.4 RPM Distribution startup problem
> >> >error log:
> >> >
> >> >040902 21:47:53 mysqld started
> >> >040902 21:47:53 [ERROR] Warning: Asked for 196608 thread stack, but
> >> >126976
> >> >/usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibezxsoi'
> > (Errcode:
> >> >13)
> >> >
> >> mysql does not have permission to write to /root/tmp
> >> Why do you have the temp directory set here?
> > I've wrote that I have following lines in my.cnf:
> > [mysqld]
> > tmpdir=/var/mysqltmp
> Then temporary give a+rw on /root/tmp (don't forget to +x /root)
> and see what's mysqld_safe gonna write there. Maybe it's a bug in the
> Also please check the environment for TMPDIR.
After this mysql started successfully but it didn't write anything in
#mysqladmin -u root variables | grep tmp
| tmpdir | /var/mysqltmp |
# stat /var/mysqltmp/
Size: 48 Blocks: 1 IO Block: 131072 directory
Device: 306h/774d Inode: 29292 Links: 2
Access: (0755/drwxr-xr-x) Uid: ( 72/ mysql) Gid: ( 72/ mysql)
Access: 2004-09-06 17:54:33.000000000 +0400
Modify: 2004-08-17 12:17:13.000000000 +0400
Change: 2004-09-06 17:55:21.000000000 +0400
Does MySQL need rights to /root/tmp to work well?