June 20, 2013

Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs

February 23, 2012 By 3 Comments

… unsigned not null default 0; Query OK, 300024 rows affected (13.28 sec) Records: 300024  Duplicates: 0  Warnings: 0 mysql> update…_log_pos 336797275 Query thread_id=47 exec_time=1 error_code=0 SET TIMESTAMP=1329980395/*!*/; DROP TABLE `salaries` /* generated by server…

Filed Under: Insight for DBAs

Post: Air traffic queries in InfiniDB: early alpha

November 2, 2009 By 19 Comments

…mysql> show warnings; +——-+——+————————————————————+ | Level | Code | Message | +——-+——+————————————————————+ | Error | 9999 | Subselect in From clause …And times for InfiniDB: 1y: 8.13 sec 2y: 16.54 sec 3y…

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…mysql> show warnings; +———+——+————————————————–+ | Level | Code | Message | +———+——+————————————————–+ | Warning | … FULLTEXT KEY (details); ERROR 1795 (HY000… affected (8 min 13.13 sec) Records: 245051 Duplicates…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Connecting orphaned .ibd files

May 13, 2011 By 19 Comments

…very often you’ll get an error in the log: InnoDB: Error: tablespace id is 10 in …= ‘actor’G *************************** 1. row *************************** SCHEMA: sakila NAME: actor ID: 13 N_COLS: 2147483652 TYPE: 1 MIX_ID: …16k long (UNIV_PAGE_SIZE in the source code). Let’s take a look at the page…

Filed Under: MySQL

Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes

July 25, 2012 By 6 Comments

…:45:30 [Note] WSREP: applier thread exiting (code:7) 120723 23:45:30 [ERROR] Aborting Of course all the data that was… | kenny | | 5 | percona1 | liz | | 9 | percona1 | ewen | | 11 | percona1 | vadim | | 13 | percona1 | miguel | | 14 | percona1 | marcos | | 15 | percona1 | baron | | 16 | percona1…

Filed Under: MySQL, XtraDB Cluster

Post: Percona XtraBackup 1.6.4

December 19, 2011 By 9 Comments

… MySQL 5.5.17, Percona Server 5.1.59-13.0 and Percona Server 5.5.16-22….xtrabackup did not use STDOUT and STDERR conventionally. Sometimes errors would go to STDOUT and sometimes normal operating …slave-save-info. This bug fix simplifies the connection code so that such problems are harder to create …

Filed Under: MySQL

Post: NDB API examples, the trivia to make ndbapi_scan works!

November 15, 2009 By 4 Comments

…’s that? Wow… look at the create_table code… void create_table(MYSQL &mysql) { while (mysql_query(&… ENGINE=NDB”)) { if (mysql_errno(&mysql) != ER_TABLE_EXISTS_ERROR) MYSQLERROR(mysql); std::cout << "MySQL Cluster already ... Pink 11 Toyota Pink 1 Mercedes Blue 13 Toyota Pink 6 BMW Black 2 Mercedes …

Filed Under: Insight for Developers, MySQL Tagged With:

Post: Beware the Innodb Table Monitor

November 29, 2011 By 2 Comments

…contents of the Data dictionary to the mysql error log, which looks something like this: =========================================== 090420 12…_NAME ID INDEX: name REF_IND, id 0 13, fields 1/2, uniq 2, type 0 …’ state, uh-oh. I dug through the source code and found a few interesting things about the…

Filed Under: Insight for DBAs, MySQL

Post: pt-online-schema-change and default values

June 21, 2012 By 1 Comment

… cleanup) Error copying rows from `sbtest`.`sbtest` to `sbtest`.`_sbtest_new`: Copying rows caused a MySQL error 1364: Level: Warning Code: 1364 Message…

Filed Under: Insight for DBAs, MySQL

Post: Impossible - possible, moving InnoDB tables between servers

June 8, 2009 By 9 Comments

… run alter table IMPORTEDTABLE import tablespace; 7) enjoy progress in error.log like: InnoDB: import: extended import of test/img_… 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 …mode and XtraDB innodb_expand_import available only in source code for now, you can get them from Launchpad projects …

Filed Under: Percona Software Tagged With: ,
Newer Posts »