SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Aug 2009
    Posts
    71
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Memory Management in MYSQL

    I wanted to know about the memory management mechanism in mysql.

    In MS SQL Server the mechanism is if we create a field of varchar(100) lets say and store only 2 characters in it , the remaining 98 will be unused and iwll not affect the memory and if the field is empty then again no memory will be used.The same thing applies with all fields.

    Is it similar in MYSQL as well or in MYSQL the entire memory is used irrespective of the content stored in it.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,215
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    it's the same
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •