…no-data orig > /tmp/orig.schema.sql Create the new target database: mysqladmin create orig_old Load the schema into the target database: mysql…values (potentially corrupted via user error or other issues) with SQL…=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, …_pushdownblogpercona.commanual error_countblogpercona.commanual…newblogpercona.commanual no_defaultsblogpercona.commanual…Select_full_joinblogpercona.commanual Select_full_range_joinblogpercona.commanual Select_rangeblogpercona.commanual Select_range_checkblogpercona.commanual Select…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…upgrade or make any configuration change on your MySQL database the first advice usually is: – Benchmark! How …Percona Playback will run both SELECT and DML queries. There is still no –read-only parameter 
So … We also see that some queries had errors. Those error are shown on the stderr so you …
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
… with the ALTER. No surprises yet. But …database oops4; ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./oops4′, errno: 39) (root@localhost) [oops4]> create table dos2 (i int); ERROR… recovery SELECT * FROM `#sql2-3c13-14`; But your database is… inconsistency present when MySQL won’t allow …
Post: Logging Foreign Key errors
September 27, 2012 By Leave a Comment
…MySQL on host 127.0.0.1 and storing all the errors on the host 10.0.05, database…mysql> select * from test.foreign_key_errors\G *************************** 1. row *************************** ts: 2012-09-26 14:28:31 error: Error…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…(with their IDs) to the error log. mysql (employees) > CREATE TABLE innodb_…to import it in our database: mysql (employees) > LOAD DATA INFILE ‘/… 0 Warnings: 0 mysql (employees) > select * from salaries where emp_no=10008; +——–+——–+————+————+ | emp_no | salary | from_date | …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… should see this in the error log. 120619 13:20:17 [… requested state transfer from ‘*any*’. Selected 1 (ip-10-112-39-… disable = no flags = REUSE socket_type = stream port = 9200 wait = no user = nobody…database and a userfor it. mysql> create database sbtest; Query OK, 1 row affected (0.01 sec) mysql…
Post: CVE-2012-4414 strikes back in MySQL 5.5.29 (and what we're doing in Percona Server 5.5.29)
January 13, 2013 By 4 Comments
…Oracle does not take patches (that no user cares about), having Oracle …error in the slave: Last_Error Error ‘You have an error in your SQL syntax; check the manual that corresponds to your MySQL… “!”)’ at line 1′ on query. Default database: ‘db1`; SELECT ‘oops!”. Query: ‘LOAD DATA INFILE ‘../../tmp…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… the local node, but it has no idea about the rest of the cluster….mysql> commit; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction node1 mysql> select * from … some databases this may be perfectly natural, but I believe most conventional relational databases will…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…percona1 mysql> use test ERROR…mysql> select * from percona; +—-+—————+——–+ | id | inserted_from | name | +—-+—————+——–+ | 2 | percona1 | lefred | | 3 | percona2 | kenny | +—-+—————+——–+ 2 rows in set (0.00 sec) percona2 mysql> select… database … is no…
