Here’s my memory — not for prize. I started blogging late 2008. Till then I was doing MySQL consulting in Israel, but… guy I contacted to have my blog aggregated into planet.mysql.com. He wrote how he likes my blogging and that… asks. Weirder. So keynotes, …., community awards. And the community member of the year awards go to: “Marc Delisle, Ronald Bradford, Shlomi…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… case 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… certain situations. Winner: FlashCache. Operational Monitoring: Both solutions offer plenty of statistics; the main difference is that FlashCache stats can be…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… InnoDB, mysql tunning script gives below results for temp table , server has 4G ram, which almost uses, as many sites of both… to reduce the number of disk-based temporary tables Note! BLOB and TEXT columns are not allow in memory tables. If you are using these columns raising these values might not impact your ratio of on disk…
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… specifies whether to use InnoDB as the data store of memcached (innodb_only), or to use the traditional memcached …the last case, if memcached cannot find a key in memory, it searches for the value in an InnoDB table.” …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… exactly memory is allocated. This was not much of the problem in MySQL 3.23 when there would only handful of places where memory could… too. Memory Leaks There are many kinds of memory leaks and I would say these are rather rare in MySQL. Most suspected memory leaks end… future releases of MySQL, MariaDB or Drizzle bring improvements in this space allowing us to see directly for what purpose memory is allocated…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
One of the big “Selling Points” of MySQL is support for Multiple Storage engines, and from the glance … Optimizer – such as in memory nature of MEMORY storage engine, clustering by Primary key in Innodb and distributed nature of NDB makes it more… very actively because of potential complications involved. Now lets think what we could have if we have a version of MySQL Server which…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… trying to solve with these plugins? Why yet another set of MySQL monitoring plugins? The typical problem with Nagios monitoring (and indeed… include starting two instances of MySQL on the same files in the data directory, and refusing to shut down MySQL so that it… pmp-check-unix-memory plugin checks for a single process consuming too much memory and/or for too little free memory in general…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…. So how we can use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per… #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is pretty idle test system… memory amount having same workload. You will often see increasing amount of memory not only helps you to reduce wait time and number of…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
… to know how MySQL scales as you add more memory to the server. Vadim recently benchmarked the effects of increasing memory and CPU core…. The outcome of the research, which was sponsored by Virident, is that as you add CPUs and increase memory size, MySQL doesn’t…. You can read the full details in our Scaling MySQL With Virident Flash Drives and Multiple Instances of Percona Server white paper.
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot of good changes… with number of hosts which can potentially connect to the server ? We also speak about just pennies in terms of memory usage so… etc referring to amounts of memory we have in the phones these days, I made in my Optimizing MySQL Configuration Webinar were heard…
