…Copying ./ibdata1 to /data/vadim/mysql/export//ibdata1 >> log scanned up to (3 769009554) …done Copying ./mysql/ibbackup_binlog_marker.ibd is skipped. Copying…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
…Copy_data AFTER INSERT on t FOR EACH ROW INSERT INTO t_copy VALUE(NEW.i); mysql> insert into t VALUES(1),(2),(3); Binary… different. If our stored procedure write data to our tables the queries inside the procedure get … steps to enable all the events replicated from the master because as we saw they’…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… the client. I copy and paste the interesting snippets from what I’…checking for default users in the mysql.* tables, running mk-duplicate-key-checker … to use a patched binary, we can use MySQL Proxy, packet sniffing,… the table. Queries can be rewritten. Indexes and data types and table structures …
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
…data was lost: MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table…copy of the data The important tables were all InnoDB Having a backup, customer has first attempted to restore from… 837492636 to it’s binary representation 0x31EB1F9C and ran “bgrep 31EB1F9C…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…copying and conversions while accessing the data, which significantly limits performance compared to basically “zero copy” design one may have streaming data from… level on MySQL side, such as .frm files and binary log files…as running multi-table update joining PBXT and Innodb tables. Operations …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…very large number of tables, slow data load and ALTER TABLE and others. Another big…for MyISAM kills Innodb, such as copying binary tables between the servers. It is …. For example binary copy of one of the databases from the Slave to … so common paths in the MySQL server – in particular Optimizer may …
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
… generate its own copy of the table, for example by running the same cron jobs MASTER runs to refresh this table periodically. Restart… disable binary logging while loading data from mysqldump as you may not want these changes to be replicated. What could have done better ? MySQL…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…the local system performance independently from anything else. Performance This is…data consistency (as SAN users often are) you better have binary log flushed on commit too. MySQL…time if Innodb or MyISAM tables are used. There is read…switching to that backup – no data copy will be required which can…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…mysql replication are independent from…from a traditional Master Slave scenario when the data set is very large? Can you swap in Binaries…data during the synchronization? A: The node synchronizing should get the data from somewhere, it is from…data is copied…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
…slave’s MySQL code. If you want to check the master’s binary log…from backup – because you would need relay logs to roll forward, and they are corrupted. You can either re-clone the data from…when use Maatkit mk-table-checksum to check what tables are out of sync… having extra load of data copied from…
