MySQL Forums
Forum List  »  Performance

Re: insert or load ? best practices and performance
Posted by: Rick James
Date: September 23, 2010 09:27PM

innodb_buffer_pool_size -- performance may improve if you increase it to 400M.
1.5GB of ram is small by today's standards.

Assuming the data is daily stock prices, you should consider normalizing out the ticker symbol and name -- replace them with a MEDIUMINT UNSIGNED. This will significantly shrink the data size, but will make the loading more complex.

Options: ReplyQuote




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.