Results 1 to 3 of 3
Hello all,
Mysql version - 4.0
while starting mysql i am getting following error, but when i comment it is working perfectly. Is it something related to mysql version specific.
...
- 04-14-2008 #1Linux Newbie
- Join Date
- Feb 2008
- Location
- Bangalore, India
- Posts
- 112
[SOLVED] Unknown variable : write buffer while starting mysql.
Hello all,
Mysql version - 4.0
while starting mysql i am getting following error, but when i comment it is working perfectly. Is it something related to mysql version specific.
Error 1 :
080414 10:23:52 mysqld started
/home/y/libexec/mysqld: ERROR: unknown variable 'write_buffer=2M'
080414 10:23:52 mysqld ended
Error 2 :
Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line
/home/y/libexec/mysqld: File '/home/y/logs/mysql/slow_query.log' not found (Errcode: 13)
080414 10:38:08 Could not use /home/y/logs/mysql/slow_query.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
InnoDB: Fatal error: cannot allocate 1073758208 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 24482732 bytes. Operating system errno: 12
InnoDB: Cannot continue operation!bigunix.blogspot.com
Registered Linux User: #476440
- 04-15-2008 #2
hmm since mysql can't read the variable. Try replace it with "
key_buffer=2M
- 04-15-2008 #3Linux Newbie
- Join Date
- Feb 2008
- Location
- Bangalore, India
- Posts
- 112
1. it was permission problem.

2. I forgot to enable [myisamchk] parameter which was causing second problem.
Anyway thanks for the help athlon_crazy.bigunix.blogspot.com
Registered Linux User: #476440


