Most mysql query cache related news are at:
More mysql query cache related news:
MySQL Query Cache and InnoDB Considerations vekseid.com 24 May 2011 | 07:49 pm
In this article we will be going over a higher level view of MySQL optimization - InnoDB versus MyISAM, whether or not you should use the Query Cache, and the new InnoDB Barracuda file format. We disc...
MySQL Query Cache bradino.com 21 Jul 2009 | 12:20 pm
According to MySQL.com the query cache stores the text of a SELECT statement together with the corresponding result that was sent to the client. If an identical statement is received later, the server...
MySQL Query Cache myforce.ru 10 Jan 2013 | 03:12 pm
В MySQL есть очень полезная функциональность — кеш запросов. Кеш запросов доступен в MySQL начиная с версии 4.0. Многие СУБД имеют подобную функциональность, но в отличие от MySQL они кешируют планы в...
MySQL Query Cache 小结 isky000.com 31 Aug 2012 | 12:16 pm
最近经常有人问我 MySQL Query Cache 相关的问题，就整理一点 MySQL Query Cache 的内容，以供参考。 顾名思义，MySQL Query Cache 就是用来缓存和 Query 相关的数据的。具体来说，Query Cache 缓存了我们客户端提交给 MySQL 的 SELECT 语句以及该语句的结果集。大概来讲，就是将 SELECT 语句和语句的结果做了一个 HAS...
Using REGEXP in MYSQL Query marieconbgdlr.files.wordpress.com 14 Sep 2007 | 05:33 pm
Regular Expression (REGEXP) is a “powerful way of specifying a pattern for a complex search”. REGEXP is a set of string that describes what you’re looking for. Here are the operators of REGEXP that c...
Using EXPLAIN to Write Better MySQL Queries shameerc.com 10 Apr 2012 | 02:45 pm
When you issue a query, the MySQL Query Optimizer tries to devise an optimal plan for query execution. You can see information about the plan by prefixing the query with EXPLAIN. EXPLAIN is one of the...
Product Review – Jet Profiler for MySQL shameerc.com 8 Mar 2012 | 08:10 pm
It was few days back I came to know about Jet Profiler an excellent tool for profiling MySQL queries. Thanks Mr. Bjorn Melinder for offering me a professional version for free. Jet Profiler is a tool ...
labs | CodeIgniter/ActiveRecord setup to use master + slave db replication fotis.posterous.com 21 Sep 2011 | 01:03 am
This is how you can set up CodeIgniter to direct mysql queries to different read/write hosts in your db replicated environment, using a db_slave for your SELECT’s, and a db_master for the INSERT/UPDAT...
How to log all MySQL queries in Drupal rndblog.com 23 Dec 2011 | 02:16 am
In order to benchmark a Drupal site performance you need to see all the database queries related to your Drupal site. In case you don’t have access to the my.cnf file If you don’t have access to the m...
Insert into multiple MySQL tables with one-to-one relationship rndblog.com 21 Jun 2011 | 06:14 am
I have been asked if there is a way to insert data into two MyISAM tables that connected by a one-to-one relationship in one MySQL query. For example: mysql> CREATE TABLE `user` ( `id` int(10) unsigne...
