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.

Caching.

> 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


Subject
Views
Written By
Posted
2514
November 27, 2014 06:33AM
Re: MySQL cash optimization
1499
November 27, 2014 04:34PM
1177
December 09, 2014 04:33AM
1048
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.