… do not quite understand why MySQL + Memcache has so large regression in the first case. Considering memcache can do 17K gets per second… overhead for constant misses should be small. Was MySQL somethat affected on having memcache on the same box (which I assume was… see if you fit everything in memory memcache is about 2x-2.5x better than MySQL for primary key lookups. Am I…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… growths however and you implement some form of caching, ie memcache you end up reducing number of reads from database dramatically… pushing few updates back to MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the… it in the database for example each hour. If your memcache is sized so objects which touched within last hour are…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… box started deploying their custom solutions – Sharding and Caching. Indeed Memcache is the most known caching technologies today, at large extent… you look at this – people do not really enjoy adding memcached – cache handling with all its invalidation and consistence issues is… with Map Reduce. Indeed I think MySQL Replication usage will reduce, but I would not expect Memcached to be leading pushing factor.
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… have. Here you can see it has couple of memcached connections. Few MySQL connections (to the same host, which if usually bad… php stream functions not from libmysql or memcache.so, which means it is not MySQL or memcache connections leaving last candidate as the… process are not only helpful to debug sleeping connections with MySQL but many other cases when you see web application locking…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
… asynchronous which causes problems if you would like to use MySQL Slave as it can contain stale data. It is true… and better cached in something like memcache. This technique especially works great with caching things in memcache as it means actively updated and read stuff will be read from memcache and old stuff can…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… if you want) and when there come various wait times – mysql, memcache, sphinx, web services etc. For web applications doing processing in… which is not accounted for. Large portion probably comes from memcache accesses which are not instrumented for this application. In this… for complex applications using mutliple components (like sphinx and MySQL) or multiple MySQL Servers because in these cases you often can’t…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… critical updates. Third one is to use cache – something like memcached, besides pure caching it can be used to store object… 140GB as total amount of cache memory you have. Using memcached or similar solutions on the top of things for caching… replication ? Not really this is great solution which offers great MySQL Performance in many cases. It is good however to understand…
Post: Active Cache for MySQL
January 10, 2010 By 11 Comments
… means it only stores cached data. This means application using Memcache has to has to special logic to handle misses from…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…is similar to storing the results of a query in Memcache. When the cache “expires”, the contents must be fully … | +——————+ | 155187034 | <-- too high +------------------+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_customer_sales ; +——————+ | sum(…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… Marketing side perhaps the speaker kept quoting benefits of MySQL Enterprise from MySQL Marketing Materials . There is not much of technical insight… of MySQL Cluster – for example quite possible their solution could help a lot to shorten latency dealing with MemCache servers etc. MySQL High…
