MySQL Forums :: Performance :: Memory mirror for read-only tables?


Advanced Search

Memory mirror for read-only tables?
Posted by: Thomas Courl ()
Date: August 11, 2009 05:43PM

Hi,

I'm facing the following challenge: I have a couple of fairly large tables (~15 million rows that each contain 3 columns: 1 BIGINT, 1 INT and 1 FLOAT) and I need to significantly improve the read performance (Select commands need to improve by factor 20 to 30).

As those tables are read-only (i.e. they contain "expert" values that will never be changed), my best guess to improve the performance is to create a stored routine that will automatically mirror the concerned tables in MEMORY tables (not sure yet how to do this).

Would this approach make sense? Any better ideas?

Also: while the BIGINT column is the primary key, I'm using the INT field as condition in my Select commands (each returning ~5000 rows). Hence I created a BTREE Index for this column. How should I decide between BTREE and HASH or other options?

Many thanks!
Thomas

Options: ReplyQuote


Subject Views Written By Posted
Memory mirror for read-only tables? 3850 Thomas Courl 08/11/2009 05:43PM
Re: Memory mirror for read-only tables? 1799 Rick James 08/11/2009 10:05PM
Re: Memory mirror for read-only tables? 1714 Thomas Courl 08/12/2009 02:31AM
Re: Memory mirror for read-only tables? 1647 Rick James 08/12/2009 07:56PM
Re: Memory mirror for read-only tables? 1555 Thomas Courl 08/13/2009 03:15PM


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.