…MySQL 5.5, you will succeed without errors or warnings: mysql…mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code… Summary of indexes # ######################################################################## # Size Duplicate Indexes 9 # Total …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… Query thread_id=7 exec_time=0 error_code=0 SET TIMESTAMP=1359714099/*!*/; BEGIN /*!*/; # at 726 # …| select * from test_2 order by id | | 9 | msandbox | localhost | test | Query | 169 | Waiting for…; When using MySQL 5.1 the second CREATE would just fail immediately with the error “ERROR 1050 (42S01…
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
… corresponding warning or error message is present in the mysql error log file. Those error can also …COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #120715 9:45:56 server id 1 end_log_pos…Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log FIRST, end_log_pos 106, Error_code…
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
…at the create_table code… void create_table(MYSQL &mysql) { while (mysql_query(&mysql, “CREATE TABLE” ” GARAGE”…ENGINE=NDB”)) { if (mysql_errno(&mysql) != ER_TABLE_EXISTS_ERROR) MYSQLERROR(mysql); std::cout << "MySQL Cluster already has example table:…BMW Black 3 Mercedes Blue 9 BMW Black 10 Toyota …
Post: Percona Toolkit 2.1.9 is ready
February 15, 2013 By Leave a Comment
… 918056: pt-table-sync false-positive error “Cannot nibble table because MySQL chose no index instead …errors by using “INSERT IGNORE”, it now handles the MariaDB case by also ignoring duplicate entry errors in the code… pt-online-schema-change 2.1.9 handles another case of changing the primary …
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction percona1 mysql> insert into percona values (0,’percona1′,’peter’); ERROR…code:7) 120723 23:45:30 [ERROR…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
… to MySQL 5.1.55, MySQL 5.5.9, Percona Server 5.1.55-12.6, and Percona Server 5.5.9-20.1 code bases. The xtrabackup_55 binary is now based on Percona Server 5.5, rather than MySQL 5… option could cause xtrabackup to fail with the “cannot mkdir” error. (Alexey Kopytov) For more information, please see the following links…
Comment: How to check MySQL Config files
December 27, 2011 By 7 Comments
…MYSQL_PASS”, “password”); define(“MYSQL_DB”, “test”); $conn = mysql_connect(“”.MYSQL_HOST.”", “”.MYSQL_USER.”", “”.MYSQL_PASS.”") or die(mysql_error()); mysql_select_db(“”.MYSQL_DB.”",$conn) or die(mysql_error…
Post: xtrabackup-0.9.5rc
October 24, 2009 By 13 Comments
… Network site for the sponsorship. Windows conscious change more Impoved error messages in innobackupex Windows conscious experimental change Suppress purge when… as well as source code of the XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.9.5rc/. The Debian package…
Post: xtrabackup-0.9
August 20, 2009 By 4 Comments
Dear Community, The release 0.9 of the opensource backup tool for InnoDB and XtraDB is …: “InnoDB: Error: space id in fsp header 143088, but in the page header 0″ Bug #394374: “Can’t compile with MySQL 5… as well as source code of the XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.9/. The project lives on…
