…yet using CMAN. Let’s have look at what happens if we have a cluster with 3 …[ percona2 ] Slaves: [ percona3 ] Stopped: [ p_mysql:2 ] After the update and after fixing some small issues like the one …-y install pcs [root@percona2 percona]# pcs status Last updated: Thu May 23 09:24:37 2013 Last change:…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…html after each run, so I find it convenient to set it up on crontab so that schema changes are…a little help in the form of metadata files. Installation of SchemaSpy and Dependencies Download the latest copy …to automate SchemaSpy via crontab once you’re done. What are some ERD tools you use and how …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… If the IO::Socket::SSL Perl module is installed (easily available through your package manager), it … sure to re-read tools’ documentation to see what has changed. As the first release in a new… we may change things like the pt-query-digest –output json format in future releases after receiving real…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… way is to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings. I’m… are really important for most common workload. After you get these settings right other changes will most commonly offer only incremental performance…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
…together not to mention infamous timestamp format change which forced to change a lot of applications. MySQL 5…/var/lib/mysql symlink I’m not sure what is the problem about having this a a symlink…or MySQL install script but simply I find no mysql user after upgrade. MySQL Does not start after upgrade…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…installations that would upgrade or are in the process of upgrading to MySQL 5.5, I thought it necessary to discuss what… | setup | 0.000016 | | creating table | 0.168283 | | After create | 0.000061 | | copy to tmp table | …. Consequences The consequences of these changes in metadata locking is that, …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… instance, and I tried to show the minimal installation required for XtraDB cluster. Unfortunately enough, I didn’… be 5 ms each time. Q: Can I change the replication method between servers? A: If you … the raw data. Q: What are the steps to automatically restart a Percona Cluster after an outage? A: …
Comment: What to tune in MySQL Server after installation
June 4, 2007 By 118 Comments
[...] MySQL Performance Blog » What to tune in MySQL Server after installation Good for basic setting up changes. (tags: mysql linux) [...]
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… 64-bit CPU. From this and what I saw earlier I can see whether someone installed a 32-bit OS on 64… MegaCli is installed, and use it to get information about the physical drives installed; then I can find out exactly what they are… completely change the performance profile and workload of a server, so it’s often worth another iteration, and sometimes even more after…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… make sudo make install valgrind –version # check version to be same as what was downloaded (3…are still too small, you can easily change them before compiling. An often bumped up…initiate Massif snapshots just before, during and after executing any commands which may alter memory …
