creating cache in mysql

Discussion in 'Databases' started by wordgeist, Jul 26, 2010.

  1. #1
    Any of you knows how to create of increase the cache in mysql?
     
    wordgeist, Jul 26, 2010 IP
  2. Deacalion

    Deacalion Peon

    Messages:
    438
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If you are trying to do this with a web host and you don't have a dedicated server, forget about it.

    Otherwise, take a look at query caching - you can change the size by changing the value of query_cache_size - this can be done by either changing a line in the configuration file (usually my.cnf) or by changing it at runtime with SET.

    Example:
    
    SET GLOBAL query_cache_size = 20
    
    Code (markup):
     
    Deacalion, Jul 26, 2010 IP