MySQL Forums
Forum List  »  Performance

Re: About performance for Database of millions of records
Posted by: Rick James
Date: May 27, 2008 11:29PM

If InnoDB, set innodb_buffer_pool_size to about 70% of RAM.

If MyISAM, set key_buffer_size to maybe 1/3 of RAM (depends on relative size of index files (.MYI) and data files (.MYD).

Can't go any further without knowing what kinds of queries you do. Also please SHOW CREATE TABLE.

What do you mean by "tuple"? RDF? If so, back off! One table row per tuple is grossly innefficient. Use Property tables. Toss tuples that you aren't using for searching into blobs that your application parses. Etc.

In some situations, a million rows is no problem; in others it is a nightmare.

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.