…logs created because SELinux restricts console output as MySQL changes name to “mysql“. Come On, as I remember MySQL…MySQL binary and if you’re standard MySQL…MySQL but find the database is gone now. mysql…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…major components: Percona XtraBackup for MySQL for binary backups mydumper for logical backups…through each DB write out ALTER DATABASE DEFAULT CHARACTER SET
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…namely Florian Haas and Raoul Bhatia, I have been able to modify the existing MySQL…outdated_slaves=”false” \ binary=”/usr/bin/mysqld_safe…MySQL. Default is to run select count(*) on mysql…log_slave_updates = OFF” (default value). In some cases, if slaves are logging… the application database use doesn…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… `/home/macko/work/mysql-5.0.51a’ The new database binary should be now available in sql subdirectory: (garfield:~/work/mysql-5.0.51a… log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults logging to hostname-slow.log file. Must be enabled to activate other slow log…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
MySQL 5.1 introduces row based binary logging. In fact, the default binary logging format in GA versions of MySQL…database with row-based logs. Take as an example a DELETE statement which does not modify any rows. No binary logging…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…database. The first step is to find out what MySQL…defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql… Variable_name | Value | Value | …binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log…
Post: Converting Character Sets
March 17, 2009 By 22 Comments
…binary logs…MySQL user –version|V Display version information and exit defaults are: ATTRIBUTE VALUE ————————– —————— askpass FALSE charset utf8 collate No Default Value database No Default…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…default format is COMPACT. More information about row format on the following link: http://dev.mysql…log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name… it in our database: mysql (employees) > LOAD DATA INFILE… you have a binary backup. Just use constraint_…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
…name (last_name) -> )ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.56 sec) # ./page_parser -f /var/lib/mysql…”PENELOPEGUINESS” pages-1345220873/FIL_PAGE_INDEX/ Binary file pages-1345220873/FIL…_id belongs to which database/table. Sometime it’s…written to the redo log right before a …
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… = (“%s –apply-log –no-timestamp –use-memory=500M…against database software…MySQL / Percona server and the appropriate xtrabackup binary. The tests live in dbqp/percona_tests/xtrabackup_basic and are named…mysql –xtrabackup-path=/mah/path –innobackupex-path=/mah/other/path –default-server-type=mysql…
