GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Curious output from Percona Configuration Wizard

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Curious output from Percona Configuration Wizard

    I've been experimenting with Oracle MySQL alternatives and I found Percona and tried the configuration wizard for comparison to what I've been using. It may just be late, but at the top it provides a client section heading like this: # CLIENT # instead of [client]. The other sections are there and the port and socket settings are there under the odd client heading. Am I missing something? Why does it not add the proper heading? Will this still work? I added a link to the whole thing below. Thanks much.

  • #2
    The output from the tool should look like this:

    Code:
    [mysql]
    
    # CLIENT #
    port                           = 3306
    socket                         = /var/lib/mysql/mysql.sock
    
    [mysqld]
    
    # GENERAL #
    user                           = mysql
    default-storage-engine         = InnoDB
    socket                         = /var/lib/mysql/mysql.sock
    
    ...
    The client section is labeled as [mysql], while the server section is labeled as [mysqld].

    Comment


    • #3
      Thank you, Scott. That's what I got, but I guess what I'm curious about is what happened to the [client] section. For example:

      Code:
      [client]
      port        = 3306
      socket        = /var/run/mysqld/mysqld.sock
      
      [mysqld_safe]
      socket        = /var/run/mysqld/mysqld.sock
      nice        = 0
      log_warnings    = 1
      
      [mysqld]
      #
      # * Basic Settings
      #
      user        = mysql
      pid-file    = /var/run/mysqld/mysqld.pid
      socket        = /var/run/mysqld/mysqld.sock
      port        = 3306
      basedir        = /usr
      datadir        = /var/lib/mysql
      tmpdir        = /tmp
      language    = /usr/share/mysql/english
      skip-external-locking
      log_warnings    = 1

      Comment


      • #4
        The [mysql] group applies to the default mysql client specifically, and is what you commonly see. The [client] section you are using applies to all client applications.

        If you want more details the manual has more information:

        http://dev.mysql.com/doc/refman/5.5/...ion-files.html

        Comment


        • #5
          Thanks again, I'll read up.

          Comment

          Working...
          X