Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    109

    Unanswered: changing system variables

    hi ,

    can I please know how to change a system variable ?
    I gave a query like this :

    set GLOBAL max_connections=500;

    but this is not working out . The mysql front end that I use reports that I have an error in this statement . Am I missing any thing here ?

    Selin

  2. #2
    Join Date
    Nov 2003
    Posts
    8
    should max_connections not be

    MAX_CONNECTIONS or $max_connections

  3. #3
    Join Date
    Aug 2003
    Location
    India
    Posts
    109

    reply-system variables

    Thanks pal,
    I did try this one but it didn't work out . I am able to view these variables but I have a requirement that needs me to change the max_connections variable ..
    Is it possible for me to directly go and edit it in some file ?

  4. #4
    Join Date
    Jul 2003
    Posts
    35
    Hi,

    You could edit your /etc/my.cnf file (you may need to create this), adding something along the lines of (under the [mysqld] group of the file)...

    [mysqld]
    max_connections=500

    Just change the 500 value to whatever you want.

    http://www.mysql.com/doc/en/Option_files.html

    Cheers,
    Ash

  5. #5
    Join Date
    Aug 2003
    Location
    India
    Posts
    109

    edit-system variables worked

    Hi,
    It worked . Thanks a lot Pal .
    Selin

Posting Permissions

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