SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Guru
    Join Date
    Sep 2008
    Posts
    977
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    db admin question

    HI, So far all of 'my' queries work well but so far, I am having relatively low levels of demand. ie not a lot of traffic causing many queries. the tables are mostly innodb.

    I read in another post about putting a table 'into memory' if there are to be many queries made on it so as (if I understand it), to redcue demand on the hdd. (presumably ram is cheaper than a hdd?)

    But what does into memory mean? is it a table view? (I doubt it) and can anyhone show me a link so I can learn how to do it?

    bazz

  2. #2
    SitePoint Zealot
    Join Date
    Dec 2010
    Posts
    187
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, saying to dump a table in the ram isn't really accurate, but I'm too used to the term.
    Anyway, some reading:
    http://www.mysqlperformanceblog.com/...fer_pool_size/

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,270
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by IBazz View Post
    But what does into memory mean? is it a table view? (I doubt it) and can anyhone show me a link so I can learn how to do it?
    dude...

    http://dev.mysql.com/doc/refman/5.0/...ge-engine.html
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    SitePoint Guru
    Join Date
    Sep 2008
    Posts
    977
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks to you both. Some reading there and I already have more questions. I'll try to find answers to as many as I can before asking them here.

    bazz


Bookmarks

Posting Permissions

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