Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Location
    St.Petersburg, Russia
    Posts
    19

    Unanswered: sort_buffer_size problem

    Hi!

    I have the following my.cnf file in Unix

    Code:
    [mysqld]
    socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock
    datadir=/var/lib/mysql
    #sort_buffer_size=32M
    [mysql.server]
    user=mysql
    basedir=/var/lib
    
    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    [client]
    socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock
    And when I uncomment the highlighted string, I can't start MySQL server - it says undefined variable, but I definetely should change the value of sort_buffer_size, it workds fine in Windows.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Could you be running different versions of MySQL? For example, running post 4.0 on Windoze and pre 4.0 on Linux? The name changed from sort_buffer to sort_buffer_size in 4.0.

    -PatP

  3. #3
    Join Date
    Sep 2003
    Location
    St.Petersburg, Russia
    Posts
    19

    Nearly!!!

    Quote Originally Posted by Pat Phelan
    Could you be running different versions of MySQL? For example, running post 4.0 on Windoze and pre 4.0 on Linux? The name changed from sort_buffer to sort_buffer_size in 4.0.

    -PatP
    Thank you for you helping, Pat!

    Yes, I have 4X version while they have only 3.23.58, I amended my.cnf - renamed sort_buffer_size to sort_buffer, but it didn't help! What else can I do?

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Leave the offending line commented out. Start MySQL normally. Execute the mysqld to see what variables it sees, look for anything that resembles sort_buffer and see what turns up.

    -PatP

  5. #5
    Join Date
    Sep 2003
    Location
    St.Petersburg, Russia
    Posts
    19
    Quote Originally Posted by Pat Phelan
    Leave the offending line commented out. Start MySQL normally. Execute the mysqld to see what variables it sees, look for anything that resembles sort_buffer and see what turns up.

    -PatP
    I found this variable: sort_buffer 2097144
    Last edited by Mike Borozdin; 08-13-04 at 12:40.

  6. #6
    Join Date
    Sep 2003
    Location
    St.Petersburg, Russia
    Posts
    19
    I figured it out finally - the proper syntax turned out to be set-variable=sort_buffer=4M

Posting Permissions

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