Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012

    Unanswered: Is MySQL good for small memory allocation?


    I only have 128MB available to develop my DB. I only have 7 tables all together. I wanted to know if I would have enough room on my chip to use MySQL on a linux embedded device.

    Thank you

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    Databases operate by caching data so that instead of reading the contents from disk it reads from memory. The more memory you have the higher the cache hit rate. In most databases the cache hit rate should be > 95%. Meaning that 95% of hits read from memory rather than reading from disk. If you reduce the amount of cache space available your hit rate will go down which means responses from your queries will take longer.

    So to answer your question, yes 128MB should be fine but have a small memory footprint is at the expense of performance.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

  3. #3
    Join Date
    May 2012
    Hi Thank you for your respond, we have decided to go with SQLite as it seems to be smaller.

Posting Permissions

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