Solved

16Gb Table, how much Ram and Optimization

Posted on 2008-10-14
3
579 Views
Last Modified: 2012-08-13
We have a SQL 4 server running a single large database. The database has 7 tiny tables and one very large 16Gb table. The index file for this table is also 1Gb.

Currently queries often need to query this table and are very slow. Querying the table results in very heavy disk read traffic. The server currently only has 10Gb RAM, if I got a new server with 32Gb RAM (And space for 64Gb) I'm sure it could be made to work properly but do I need to worry about settings like key_buffer_size? (Would this need to be set to 2Gb?)
0
Comment
Question by:smj001
3 Comments
 
LVL 9

Accepted Solution

by:
michofreiha earned 250 total points
Comment Utility
it's a very good idea to use 2Gb as memory ..upgrade to 2G and try the script again...I'l sure it'll be better..

I had to do a large import (> 9 million records) for a customer on a shared database machine.  It's 2.4Ghz with 1.5Gb RAM, so close to your specs.  The inserts hammered on it, and slowed down the response on the console, but requests from the web server (a separate machine) still came through perfectly.  There are a few very touchy customers who complain if a page takes 1 full second to load, and we had no problems through the entire insert cycle
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now