… which means LVM is pretty much unusable for backups or required space is …while scanning the files to somewhat random IO – because blocks which need … our question of space requirements for MySQL Backups using LVM. As you …well. If you want to get really accurate number you better to use your …
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
…MySQL storage engine which defaults to HASH index type by default, instead of BTREE which makes indexes unusable…per second while converting table to MyISAM I get about 600 deletes per second and about …directly in memory. MyISAM however had to perform number of random writes to the key file and data …
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
… erasing cycles, after which it gets unusable. And obviously the SSD card … 220200747 where 8492649856 is the number of sectors written since the reboot… sequential writes and it gets a maximum value for fully random writes. This value …write throughput 273.45MB/sec from MySQL to disk. And it helps …
Post: Living with backups
November 6, 2008 By 28 Comments
…I/O scheduler over random I/O coming from MySQL, but also such large… long as it does not get flushed. MySQL obviously takes advantage of this … It happens by replacing old and unused blocks with the newly read ones….to check MySQL status every second and in case the number of connected threads …
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…number…getting a lot of random writes. OK. Now lets move to testing MEMORY tables for the same queries: mysql…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…unusable. To be honest I do not really like averages Innodb provides as it is hard to get…mysql tables in use 1, locked 0 is number of tables used by transaction in question (meaning it was accessed) and number…read” shows average size of read requests. For random IO these should be 16K – page size, …
