…not check that MySQL datadir was empty before –copy-back was run. With this bug fix, innobackupex will now error…exists whentar4ibd has failed. If the file doesn’t exist, it means the table was dropped while innobackupexwas copying other files, so the error…
Comment: What's the recommended MySQL version?
February 8, 2012 By 24 Comments
…tables. I don’t believe I had any InnoDB tables. After upgrading, I can’t start MySQL…error: 120208 13:40:35 InnoDB: Error: trying to access tablespace 1 page no. 252, InnoDB: but the tablespace does not exist… tablespace does not exist or is just being dropped. Then the server shuts down. I ran mysql…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
…table with data as example, column c1 on table t2 references column c1 on table…5, MySQL will stop deleting rows if it encounters constraint errors. To demonstrate on 5.5.17: I delete some rows from t2 so some rows on t1 does not… rows 301 to 400 does not have any existing constraints from t2 …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…MySQL master. I’ll talk more about that in another blog post. FlexCDC does not…error. It will exit with a message “setup completed” otherwise. Verify installation The binary log stores it progress in a metadata table: $ mysql…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…tables you can consume unbound amount of memory. Stored Procedures Recursion – It does not… by having high max_connect_errors variables but this will …MySQL does not have much of resource utilization control you can simply run heavy queries to get MySQL Server barely functional. The limits which exist…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
…can check details in the MySQL Error log file. The error message describes few …This will purge existing relay logs re-fetch all events which have not been executed… you favorite hex editor if mysqlbinlog does not work) to find the next … use Maatkit mk-table-checksum to check what tables are out of …
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…to do a sanity check on existing replication setup. As we’re checking…in versions. We also ran mysql_fix_privilege_tables to ensure all new privileges … Slave to replicate with skip-slave-errors=1105 to see if we get…, even if it includes skilled MySQL DBA typically does not need to go through major…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… to an existing node in… this in the error log. 120619 13:…does not match group state UUID (77c9da88-b965-11e1-0800-ea53b7b12451): 1 (Operation not…mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp-table…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… potential for increase in deadlock errors (see the slides/recording if …mysql user accounts replicated? Yes, provided you use CREATE USER or GRANT. DML on the mysql.* tables directly will not… recommendations from Codership. There does not, however, AFAIK, exist any dedicated checks specifically for…
Post: Getting annoyed with MyISAM multiple key caches.
May 1, 2009 By 11 Comments
…error in key cache creation but it is not possible to later find out such key cache exists… to see where each given table is cached. See other key …Such basic feature either does not exist or is not documented. I’m not sure how relevant … key caches first introduced in MySQL 4.1 was newer quite …
