…, we’ll extract those deleted rows from the ibd file and import them into the database. The time between the deletion of… import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/salaries.recovery’ REPLACE INTO TABLE `salaries` FIELDS TERMINATED BY….01 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 mysql (employees) > select * from salaries where emp_no=10008; +——–+——–+————+————+ | emp_no…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
… table definition from MyISAM to Innodb Discard the tablespace Replace the table ibd file with the one provided by the customer Import… Ubuntu 10.04 EC2 instance, installed MySQL and provided the customer the credentials to upload their files. Then, I proceed. Loading the… | head -3 | tail -1 | awk ‘{print $6$7}’`; mysql -u root -e “insert into tables (name,spaceid) values (‘$tname’,conv(‘$spaceid’,16…
Post: Living with backups
November 6, 2008 By 28 Comments
… batch job that just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a… a database of such size. Everything is wiped out and replaced by random “garbage” for no good reason. Since the hit…, other MySQL data files do not comply with this requirement. The trick could be used here perhaps to read the file with O…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… deal by intentionally creating a new tiny deadlock which will replace the previous one in the output thus reducing the space… make InnoDB to write the full status output into innodb_status.
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… example I actually went ahead and manually edited test.ibd file replacing few bytes so corruption is mild. First I should note…) mysql> insert ignore into test2 select * from test where id>250; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> insert ignore into…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…omitting the dimension columns from the projection, instead replacing them with the dimension keys: select dim…. Baseline: The MySQL command line client was used to execute the a script file containing the … a data into multiple files (for each shard, for later loading) or it can load files directly, …
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
…MySQL you might need to deal with RAID … mdadm to change status of rebuilding drive into “failed” and removed in “active sync” but …this is valid thing to do even without replacing any hard drives, from my experience I …. This is why I prefer to know files affected by bad blocks on the first place….
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
…my experience, and you are likely to need to replace one, for example. If you rent this array …aggregate over long periods of time in my sample file so we can see performance throughout the day. …time. In some time periods, the write latency gets into the 30s of milliseconds, and the read latency …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… running PostgreSQL instead of MySQL or having Sun box replaced with comparable Dell or HP…mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql…nologging mysqld moved into the FX scheduling class via priocntl -s -c FX mysql-pid “…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock run [root@localhost msb_ps_5_5_15]# time mysqldump –defaults-file… note MySQL actually uses midpoint insertion for its buffer pool replacement policy … also look into changing how buffer pool is split into young …
