…how data was lost: MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table… them was deleted files on xfs – we all agreed on few things: recovering files from xfs is … Dictionary was not overwritten by an attempt to restore from the backup, actually second part …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…MySQL. Good design will help dictate how many tables are required in order to get the job done. To…how to create indexes. Foreign key references may add processing time to inserts, updates, and deletes…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
…to Innodb tables decent size of innodb_log_file_size is important for MySQL…MySQL in the middle and watch it to recover. Doing this several times you should be able to estimate how…deletes can be sized to…
Post: Innodb undo segment size and transaction isolation
January 12, 2011 By 3 Comments
… to check: mysql> select * from information_schema.innodb_rseg;…deleted on rollback, update and delete however need to…to be recovered from undo space and it will contain correct pointer to appropriate blob version. Now lets move on to the main topic – how…to require state of any row in Innodb table…
