The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Changing Mysqld cmmandline for debugging

Discussion in 'General Discussion' started by scjom, Dec 17, 2008.

  1. scjom

    scjom Member

    Joined:
    Dec 14, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I'm curious where the best place in cpanel is to make edits to the mysqld command line. Specifically i'm looking to add the slow-query option to get a list of slow querys and no index sql, to track down the users that are running my poor server insane.

    on a normal machine, i would simply edit the init.d/mysql file; but i want to be sure to not break anything in cpanel.
    Thank you for your time, and im sorry if this is already answered, but 25minutes of searching has given me very little.
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    The same place as on any system with MySQL, in /etc/my.cnf (or /usr/local/etc/my.cnf on FreeBSD).
     
  3. scjom

    scjom Member

    Joined:
    Dec 14, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Thank you

    Thank you for confirming that. I've never worked with cpanel before, and there are many things it's best to avoid doing the 'normal' way; so i felt it better ask then offline my server for a day :)
     
Loading...

Share This Page