MySQL Forums
Forum List  »  Optimizer & Parser

Re: MySQL cash optimization
Posted by: Peter Brawley
Date: November 27, 2014 04:34PM

> second time server can do it for 1min.


> Is there any way to prevent from the mysql making this cashing?

To make repeat runs as slow as the first? Why would you wish to do that?

> Is there any way to do some changes for make it faster?

Let's see the results of Show Create Table for each table, and of Explain Extended for each query.

Also, if these are InnoDB tables, what's innodb_buffer_pool_size, how much RAM is there?

> '.$id_cat.'

BTW, what API language wants dots surrounding var refs?

Options: ReplyQuote

Written By
November 27, 2014 06:33AM
Re: MySQL cash optimization
November 27, 2014 04:34PM
December 09, 2014 04:33AM
December 09, 2014 12:28PM

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.