June 19, 2013

Post: How to estimate time it takes Innodb to Recover ?

file time may have recovery time of 5-10 minutes. To understand things affecting recovery time you better to understand how… but again this does not normally take …large number of hard drives. So how do you estimate howhandle and crash Innodb few times to see how … sure all OS/RAID caches are clean …

Post: Heikki Tuuri Innodb answers - Part I

Does Innodb has any protection from pages being overwritten in buffer pool by large… ascending order of the file address, then InnoDB … experiment with. Q17: How InnoBD handles blobs/text fields (needs …1 write than flush 10 non sequential pages from … not have RAID with BBU. With good RAID with BBU…

Post: Rendundant Array of Inexpensive Servers

… component can fail it does not matter how redundant it is inside…. detection and automated handling in mind as Google File System. In particular…RAID question is if Hot Spare should be used. I normally do not use it because it a large…expensive. If instead you have 10 pairs $10K boxes having couple…

Post: Living with backups

does backups. Usually it’s some nightly batch job that just dumps all MySQL tables into a text file…. The storage is handling reads issued by…but also such large I/O … fastest drives or RAID configurations, the performance…allows to affect how I/O …€¦ if ($$row[1] < 10) { $is_running= 1; } if ($$row[1]…