… the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached… ones. What is the difference? Let’s see an example. If we execute: mysql> ALTER TABLE test ADD INDEX (col2); Query OK…-key-checker, but it does not detect all cases. For example: mysql> alter table test add index redundant (col2, id); Query OK…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… row? We call rows that are updated heavily “hotspots”. Examples of hotspots Example 1: Your application is an online game and you… counters one at a time (from Example 1, above), how about maintaining the counter in memcache or redis and only flushing to…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…-focused it on its primary objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was…, MySQL, Perl, etc.) are either out of date or are known bad versions. For example, there are two versions of the DBD::mysql Perl module that have problems. And there are certain versions of MySQL that…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… things faster without adding complexity to the application (as memcached does for example). Query Cache is also one of the few cache… is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so it is lockless… API which would allow one to use local memory, Memcache or for example local flash storage for storage. Compression You can see…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
…Reilly’s. The A/V and room layout teams, for example, have a lot of experience from previous events, and they…, partitioning, community toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding, memcached, high availability, DevOps, Big Data, SSD…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…. Using this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant or… most part they are designed to be simple. A classic example is a simple online game. An online game may only… do. Using this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant or…
Post: Maatkit Now Supports Memcached
July 24, 2009 By 11 Comments
….e. query MySQL too much) Suffer a fate too horrible to contemplate. Percona does a lot of consulting around Memcached, so we try to take a quantitative, scientific approach to measuring memcached performance, just like everything else we do. memcached is…_print but the keys are not fingerprinted so the two examples above are different classes because “user_123″ != “user_456″. This…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 2
October 16, 2009 By 8 Comments
… performance! Using Memcached::Fast was kind of a mixed bag when looking at the benchmarks for mixing MySQL and Memcached in my tests… with the Fast api, MySQL gets hammered. This type of thing happens a lot. For example an application is CPU… performance! Using Memcached::Fast was kind of a mixed bag when looking at the benchmarks for mixing MySQL and Memcached in my tests…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
… unpredictable nature of the the query cache, external caches like Memcached are usually employed. When rows in the database change, the… must be recalculated. This recalculation may be very expensive. For example, suppose we need to calculate the total count of items… not accessed very frequently. Use what you need Both Memcached and the MySQL query cache are limited in size. If you try…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
… problems if you would like to use MySQL Slave as it can contain stale data. … balance them if you have underloaded master. For example search queries or reporting queries are very good…cached in something like memcache. This technique especially works great with caching things in memcache as it …
