…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 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…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…_vtable_mode). mysql> show warnings; +——-+——+————————————————————+ | Level | Code | Message | +——-+——+————————————————————+ | Error | 9999 | …c1 from ontime group by Year; Time: 9.54 sec Ok, so there …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…requires some knowledge of source code – you only get file …next section is about deadlock errors: ———————— LATEST DETECTED DEADLOCK ———————— 060717 4:16:…InnoDB 442 mysql tables in use 1, locked 0 MySQL thread …57973114, created 251137, written 10761167 9.79 reads/s, 0….
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…YouTube, Yahoo, are not good for like 99.9% of the applications because they are not …me simple is best. Complex architectures are more error prone harder to maintain (upgrades etc) and troubleshoot… because of bad code or something unpredicted. Summary: So am I denying all MySQL industry practices (…
Comment: When should you store serialized objects in the database?
January 21, 2010 By 42 Comments
…), you know that this process is extremely tedious and error prone. It just isn’t worth it if you … 99.9% cache hit rate in production. In practice, that means that even if the queries through to MySQL are …. It stinks of a lack of understanding of how code actually gets written. It’s like DBAs aren’t…
