MySQL Forums
Forum List  »  Performance

Re: caching table
Posted by: Rick James
Date: September 01, 2013 12:11PM

There are multiple techniques of caching available. Please provide some examples of SHOW CREATE TABLE and SELECTs. Then we can discuss what might work your you.

> Is there any other way to improve the performance?

This is an even bigger topic. The answers:
* Tunables (quick answer: http://mysql.rjweb.org/doc.php/memory)
* INDEXes (quick answer: http://mysql.rjweb.org/doc.php/index1)
* Reformulating the queries
* Redesigning the schema
* Redesigning the application.

Again, please provide specifics.

The LONG answer: read all the items in this forum, plus the literature on MySQL performance, such as the 3 editions of the book by that title.

Options: ReplyQuote


Subject
Views
Written By
Posted
2084
August 15, 2013 03:40PM
Re: caching table
1022
September 01, 2013 12:11PM
890
September 01, 2013 10:26PM


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.