… asynchronous which causes problems if you would like to use MySQL Slave as it can contain stale data. It is true… certain period of time. It is best to use this technique with assigning visitor to the dedicated slave for the duration… memcache. This technique especially works great with caching things in memcache as it means actively updated and read stuff will be read from memcache…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… where to read sensor data, talk to memcache or external search engine . As MySQL 5.1 and plugable storage engine interface matures… of projects being interested in special techniques applying to optimizes certain types of queries with MySQL, it is not easy to do… be evolving and how more parts in MySQL will become pluggable and so hopefully more innovative tools and techniques will be developed.
Post: Percona sessions at the MySQL conference
March 15, 2010 By 6 Comments
…to MySQL and InnoDB Fernando Ipar: PHP Object-Relational Mapping Libraries In Action Baron Schwartz: Read-Write Splitting: Techniques, Challenges…Choosing Hardware and Operating Systems for MySQL Peter Zaitsev: Instrumenting your Application for MySQL and Memcached Peter Zaitsev: InnoDB Architecture …
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… the cache (ie memcache) is often implemented to offload MySQL. When it comes to large scale data processing other techniques are used. Google…, though even single node does not take you that far. MySQL concept of Single Query=Single Thread works well when few… need, even on the roadmap. Indeed MySQL has MySQL Cluster but it is quite different. MySQL Cluster at this point is a cluster…
Post: Cache Miss Storm
September 10, 2010 By 29 Comments
… can decode memcached wire traffic. For second you can have instrumentation in your applications or take a look at MySQL Slow queries… Cache Especially with memcache it is you who decide how to populate the cache. There is number of techniques you can use… you’re better wait rather than starting populating it. For MySQL Query Cache the solution should have been to make queries…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… summary tables, significant schema changes, use of replication, caching, using memcached, sphinx, implementing proper web caching etc. These changes are not… growth forecast. So you go ahead and implement memcache, sharding, replication or other techniques which allow you to scale out to the… variety of companies on he market offering services around MySQL and LAMP and MySQL is one of them. Plus for large companies…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… they tell me about number of creative techniques they heard on the conferences, read on … Sure. Unless you’re using memcache or other caching option. Successful memcache implementations often report 90% cache… the application is only related to the MySQL redundancy for very high quality/high scale …
Post: Caching techinques
August 8, 2006 By 11 Comments
… some Web Service. For smaller short lived objects things like memcached (or local shared memory for small installations) can be more… is how MySQL Query Cache works by removing all queries derived from the table if that table is updated. This technique requires… control of what has to be invalidated – approach used by MySQL Query Cache is too coarse invalidating a lot of queries…
