Find the answer to your Linux question:
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. ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux 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

  2. #2
    Linux Newbie athlon_crazy's Avatar
    Join Date
    Sep 2007
    Location
    Malaysia
    Posts
    132
    hmm since mysql can't read the variable. Try replace it with "

    key_buffer=2M

  3. #3
    Linux 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •