MySQL Forums
Forum List  »  Install & Repo

Memory settings
Posted by: Michael Gautereaux
Date: November 10, 2006 01:57PM

I am running Mysql 5 on Windows 2003 sever with 3 gigs of memory. I have a table that has 120m rows about 3gigs of data and 2gig in the index. I have other tables that I run queries against this table that have 3-5 m rows. What would the best engine be for these size tables to enhance the access speed. What memory settings
would also enhance the process.
Thanks for your time!

Options: ReplyQuote


Subject
Written By
Posted
Memory settings
November 10, 2006 01:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.