MySQL: how to enable query cache?

Discussion in 'MySQL' started by funtent, Jan 20, 2009.

0
  1. #1
    According to MySQL Administrator app, the MySQL process is not using query cache at all.

    TIA
     
    funtent, Jan 20, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    You need to add a query cache value to your my.cnf file.

    What type of database are you using: innodb, myISAM, etc. Also what access do you have to your server. You need root access to edit my.cnf, or administrator rights for windows.
     
    jestep, Jan 20, 2009 IP
  3. funtent

    funtent Peon

    Messages:
    8
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    No idea. As reported by phpMyAdmin's Server variables and settings page:

    storage engine: MyISAM (and many other instances of string "MyISAM")

    but

    have innodb YES (and many other instances of string "innodb")

    :confused:

    I do have root access. It's my VPS. Thanks jestep.
     
    funtent, Jan 21, 2009 IP