… let’s understand first what’s going on and why InnoDB refuses to use suggested .ibd file. There is an InnoDB dictionary… is updated successfully It is possible that space_id from actor.ibd is already used by some other table. In this case if ibdata was updated MySQL…
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
… tell what is using it ? This look from another side would help me dramatically to find out what is causing cache pressure and what needs… files on Linux because it is not aligned. [root@DB01 mysql]# du -h ibdata* 246G ibdata1 [root@DB01 mysql]# perl /tmp/fincore –justsummarize ibdata1…
Comment: Btw xtrabackup is not only backup..
February 13, 2010 By 12 Comments
…/lib/mysql/xtrabackup_suspended’ xtrabackup: suspend-at-end is enabled. xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: Target instance is…_path in my.cnf back xtrabackup: to what it was, and remove the new ibdata files InnoDB created xtrabackup: in this failed…
