The feature I announced some time ago http://www.mysqlperformanceblog.com/2009/06/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now I am going to show how to use it (the video will be also available on percona.tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume we want to copy order_line [...]
Copying InnoDB tables between servers
Filed Under: Percona Software Tagged With: export, import, InnoDB, Tips, xtrabackup, XtraDB
The tool I’ve been waiting for years
I’ve just been pointed to the nice tool which I was waiting for years to see. It is fincore – little perl script which allows you to see what pages of file are cached in OS memory. This is really cool.
Filed Under: Insight for DBAs Tagged With: Operating Systems

