From: Johan De Meersman Date: February 5 2010 2:40pm Subject: Re: Help optimizing settings? List-Archive: http://lists.mysql.com/mysql/220587 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0050450181022f1510047edb6ed0 --0050450181022f1510047edb6ed0 Content-Type: text/plain; charset=ISO-8859-1 Using "load index" might help, but you'll have to make sure you allocate plenty of space to your keycache. If the queries are identical, the query cache might also be a good candidate, but that seems unlikely. The memory will also be used by your OS to cache often-used parts of the filesystem, including the data- and index files. This will also help. Consider using compressed (archive) tables, as they require less disk I/O for a given amount of data to be retrieved. Consider additional indexes, maybe even clustered indexes if the dataset you need is very close to what you use in the where-clause. On Fri, Feb 5, 2010 at 3:26 PM, Ken D'Ambrosio wrote: > I've got a fairly large -- 100+ GB -- MySQL database. It isn't accessed > often -- it's acting more as an archive right now than anything else. > That being said, when it does get accessed, the indeces seem to take > forever to load. Being as I just bumped the RAM from 2 GB to 6 GB, what, > generically, would be the best way to go forward to take advantage of the > extra RAM? > > Thanks! > > -Ken > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegivamp@stripped > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0050450181022f1510047edb6ed0--