…database is cold, but the opposite is true when the database is hot. SSB Flight #3 Here in…in this series. Regardless, when the working set fits in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… load on the host system, DRBD can end up in a split-brain situation. Typically DRBD is run in …as described in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, … is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL… MySQL would re-create the test database when using rpm on server upgrade, even if the database…t be loaded with Perl and Python clients when plugin-dir option was set in the […
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL… MySQL would re-create the test database when using rpm on server upgrade, even if the database…t be loaded with Perl and Python clients when plugin-dir option was set in the […
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… slower (and more CPU-intensive under high load) than PCIe flash For example, see http://…card, not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional …allowing my database to run in memory (not actual RAM, that’s true, but much closer to memory speed …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… pages in memory. What it says though is that, if this query would run on a cold MySQL instance, … which typically (not always) shows queries causing highest load on the server. As we can see here … its run. The “Databases” section of the output also shows the name of the databases where this query …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option and…wait_timeoutblogpercona.commanual locked_in_memoryblogpercona.commanual logblogpercona….shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona.commanual show…heartbeat_periodblogpercona.commanual slave_load_tmpdirblogpercona.commanual slave_net…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
…, they’ve added more EBS volumes to keep up with load. Between the time I sampled statistics last week and now… running databases in various cloud services with great results. In particular, it can be made to work really well if the database fits in memory and… stops fitting in memory, or if a lot of transactional writes are required, then performance takes a severe hit. In conclusion, in a knock…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… in many cases. There is really no gain in dumping table via mysqldump and loading it… (including memory) available. Another thing to mention having multiple instances of different MySQL versions …features which are marked as making database binary incompatible with MySQL. Our focus on compatibility …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…load average, memory sizes, and a bunch of other stuff. In this case I’m on a machine with 32GB of memory…’s up with the database. The first step is to find out what MySQL instances are on the … an in-memory temporary table will be converted to an on-disk table, which is an expensive operation. In …
