Percona is glad to announce the release of Percona XtraBackup 2.1.0 for MySQL beta on April 22, 2013. Downloads are… the time of writing). This release contains all of the features and bug fixes in Percona XtraBackup for MySQL 2.0.6… #1116177. innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could trigger a bug if the server being backed…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…. You have to do couple of changes to enable core files. First you need “core-file” option to my.cnf which will instruct MySQL to dump core…. To check the if it works you can do kill -sigsegv `pidof mysqld` which will trigger the same code as if MySQL crashes….mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…tend to happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and … existing plugins, so there was no need to write new ones. For example, the plugins that … to a query. The pmp-check-mysql-status is also very flexible and can be used to trigger …
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…’ll write the output to /tmp/massif.out. If you prefer to use another location (and are therefore bound to set proper file rights etc…) in order to point mysqld to your settings file etc. After mysqld is properly started (check if you can login with your mysql client), you would execute whatever steps you think are necessary to increase memory usage/trigger the memory problem…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 5 Comments
…’re using MySQL Replication when your master goes down it is possible for some writes to be executed … failover to Slave happened and they can be dumped to local file (in case one wants to synchronize them… schema and when you do not have to mess with complex features like triggers or multiple storage…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to …file_sizeblogpercona.commanual innodb_log_files_in_groupblogpercona.commanual innodb_log_group_home_dirblogpercona.commanual Innodb_log_waitsblogpercona.commanual Innodb_log_write…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…to identify rows that have changed Triggers to capture changes synchronously Database log reading to…MySQL installations which allow connections as root with no password from localhost. It is possible to read from and/or write to…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
…trigger … -rw-rw—- 1 mysql mysql 1073742171 Nov 2 15:15 /var/lib/mysqllogs/db1-bin-log.003229 -rw-rw—- 1 mysql mysql…files), then write operations in MySQL will suffer since that very same mutex is used inside MYSQL_LOG::write…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… potentially be a very serious problem that is fixed in MySQL 5.1.60. I’ll repeat here the full documentation… leads to the tablespace being extended, crash recovery could see BLOB writes to pages that are off the tablespace file bounds. This should trigger an… leads to the tablespace being extended, crash recovery could see BLOB writes to pages that are off the tablespace file bounds. This should trigger an…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… DB write out ALTER DATABASE DEFAULT CHARACTER SET
