… more IO than MyISAM when the database is cold, but uses less CPU time when the database is hot. I am only… is faster than InnoDB when the database is cold, but the opposite is true when the database is hot. SSB Flight #3… the working set fits in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version used: 5.6…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… described in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases… that trouble is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s starting to…
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
… of memory, did you limit the ARC to 4GB? Also wondering if any one is using ZFS and MySQL to thin clone databases meaning using a snapshot of a source database and provisioning clones from those… multiple copies of the source database. Would be interested if someone wanted to contribute on the MySQL side. Interesting that on Wikipedia…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be…). Percona Server for MySQL would re-create the test database when using rpm on server upgrade, even if the database was previously removed…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… and MaxDB database looked like it had a solid future. MySQL Cluster and MySQL Press were announced during this event; “High Performance MySQL” 1st… other databases and technologies in NoSQL and BigData space – PostgreSQL, EnterpriseDB, Hadoop,Hbase, MongoDB, CouchBase providing compliments and alternatives to MySQL. The MySQL… Percona Live MySQL Conference and Expo in Santa Clara, Calif., April 22-25. Share a memory you have from past MySQL user conferences…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be…). Percona Server for MySQL would re-create the test database when using rpm on server upgrade, even if the database was previously removed…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… obvious how they will affect your database workload. For example: Transaction commit takes …or work around it with by fsyncing to memory (Battery or capacitor-backed write cache), etc… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL …
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…- It’s all about performance. Suppose I have a 2TB database, but maybe my working set is only 500GB. What are… card, not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the PCIe…’m effectively allowing my database to run in memory (not actual RAM, that’s true, but much closer to memory speed than a…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… am using wordpress and drupal, and i converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp table… 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
…memory is being used by current MEMORY tables: mysql> select sum(data_length+index_length) from information_schema.tables where engine=’memory‘; …memory allocated 2623331 Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database …
