memory help: MySQL Optimization - Large Memory Systems? - Help.com

MySQL Optimization - Large Memory Systems?

I’ve got this crazy great server machine and I’m currently trying to figure out the best way to set it up for optimal MySQL usage.

The kicker to this question is that the server has 16GB of memory, so the question I have is, is it a good idea to setup a LARGE ram disk and let the MySQL datafiles live in that, or is it just better to let mysql live on the Harddrives and use tons of cache memory.

   

This open post was written 7 years, 2 months ago | V/U/S: 864, 3, 0 | Edit Post | Leave a reply | Report Post


Reciprocity (0) Reciprocation Failure -- The poster has NOT helped anyone else yet!

Since writing this post Jeff may have helped people, but has not within the last 4 days. Jeff is a verified member, has been around for 7 years, 6 months and has 71 posts and 2,630 replies to their name.

Post Tags (4)

MySQL, linux, ram, memory (How Tags Affect Reciprocity)

Replies (3)

Where were you?

Click and drag to move the map around. FAQ: How we place people on this map »
You can also watch events on Help.com as they happen
Mouse over the map for 2 seconds to see an expanded, interactive view

softwareengineer99 offline Verified User (7 years, 2 months) Long Term User Shouts: 0 #
Astoria, NY, US | 7 years, 2 months ago (11 hours, 18 minutes after post)

Hey Jeff,

I got you an answer from MySQL AB’s Arjen Lentz
Come read it at my blog:

http://mysqldatabaseadministration.bl…

Thanks
Frank

Quote this reply Report this reply to moderators
m offline Verified User (6 years, 10 months) Long Term User Shouts: 0 #
An Unknown Location | 7 years ago (1 month, 3 weeks after post)

Yeah I would stay away from RAM disks, modern OSes (especially Linux) already do what you describe dynamically. If you have the space, innodb with a huge buffer pool really flies, especially if you have all your indicies set up properly.

Quote this reply Report this reply to moderators
Jeff offline Verified User (7 years, 6 months) Long Term User Shouts: 1 #
Gamla Stan, 26, SE | 7 years ago (1 month, 3 weeks after post)

That’s actually what we ended up doing. Something like a 1gb buffer pool and 500 mb query cache. Might increase these later.

Only problem with this route is that right after a restart, the system is gashtly slow while the cache gets regenerated.

Quote this reply Report this reply to moderators
Help me with: Help needs email alerts for more stuff.

Invite Others to Help

A logged in and verified Help.com member has the ability to setup a Friends List and invite others to help with posts.