… applying Callaghan’s law to single-server Innodb, we’d get: [On a single node Innodb server] a given row can’t… fsyncing every transaction (innodb_flush_log_at_trx_commit != 1), or work around it with by fsyncing to memory (Battery or capacitor… your hotspots were really bad in standalone Innodb, you might consider relaxing the fsync: set innodb_flush_log_at_trx_commit to…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… regarding to memory allocation. So we did some memory allocation setting in my.cnf file. On first day after doing memory allocation setting… – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware: Node:2…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… API diminishing importance of the Innodb storage engine. The Falcon storage engine was announced as a potential Innodb successor. A “MySQL Network… will be separate from MySQL Server, providing a more scalable Innodb version with more features. Gearman and MemcacheD storage engine plugins… Expo in Santa Clara, Calif., April 22-25. Share a memory you have from past MySQL user conferences on Twitter – directing…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 30, 2013 By 10 Comments
… to http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-internals.html there are some caching settings to play…: “Table cache_policies specifies whether to use InnoDB as the data store of memcached (innodb_only), or to use the traditional memcached…, if memcached cannot find a key in memory, it searches for the value in an InnoDB table.” I’d like to see…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view… transactions are seen in the view later. To this end, InnoDB scans trx_list (i.e. the list of currently open… states is then a matter of copying a relatively small memory block which, depending on many factors, can be from few…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… where the MySQL working set is significantly larger than the InnoDB buffer pool (thus leading to a lot of buffer pool… building a separate kernel module in addition to whatever flash memory driver you’ve already had to install, and then further…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
…. This could not be related to primary key worth distribution, memory or CPU as repeating the same test on uncompressed table… we are facing more and more big data challenges where innoDB and TokuDB will have to be compare with LevelDB at…
Comment: The write cache: Swap insanity tome III
April 22, 2013 By 5 Comments
Yes, very likely MySQL Innodb Buffer pool since it the biggest memory consumer.
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… wordpress and drupal, and i converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp table , server… tables Note! BLOB and TEXT columns are not allow in memory tables. If you are using these columns raising these values…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… in set (0.00 sec) Innodb Memory Usage Finally it is often helpful to check how much memory Innodb has allocated. In fact this…. Run SHOW ENGINE INNODB STATUS and look for memory information block, which can use like this: ———————- BUFFER POOL AND MEMORY ———————- Total memory allocated 132183490560…
