… the results of a query in Memcache. When the cache “expires”, the contents must be…supports basic queries which use select/group by/join/where. You may not use sub-queries or … available for querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK, 0…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
…–use_global_long_query_time. Added the –query_cache_strip_comments option to strip comments from query before using it in query cache. Added a …based packages. RPM are named as: Percona-Server-<sub package>-
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
…does not take you that far. MySQL concept of Single Query=Single Thread works well when few rows…(especially in modern age of AJAX applications with sub second response requirements). Note you will have …have to do careful indexing build summary/cache tables hunt queries which traverse a lot of data …
Post: Living with backups
November 6, 2008 By 28 Comments
…Since the hit ratio becomes worse as the cache is being filled with random information additional … MySQL data directory will result in a total disaster after MySQL stops responding to the incoming queries quick… you need to query your block devices. In case of the SCSI sub-system (devices named sda,…
Post: Intro to OLAP
July 12, 2010 By 9 Comments
…(or online analytical processing) tools using MySQL and other free open source software… must generate to answer those queries. Performance challenges with larger databases,… both the category AND a sub-category. A time dimension includes year… featuring an in-memory OLAP cache. Mondrian is part of the…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… but it is extremely important for MySQL Performance Optimization. In fact I probably… analyzed – count queries, group by, order by without indexes, search queries etc. Basically as…if you have some form of caching on top of that. For IO…be much slower than (user_id,sub_id) combined primary key as this…
Comment: Multiple column index vs multiple indexes
August 25, 2008 By 13 Comments
…query is SELECT SQL_NO_CACHE…cache was set at 4 GB. Mysql version 5.0.67 ( i was doing testing for bug 29857). mysql…
