…you would have beautiful page > rendering as well as much more queries per page which will make > …will however start > to crawl. > So developing you PHP applications use test database with reasonable > amount …hand, an index that has very low cardinality (1/2 a million rows with an index on a Boolean…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…i in 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql …directory or because random updates to 10000 distinct pages for index header updates not to mention modification time…at different rate. Interesting enough it dropped just 2 times and was about same for 10 …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…indexes) # du -sh * 203M ibdata1 128M ib_logfile0 128M ib_logfile1 988K mysql 2.1G ontime1 2.1G ontime10 2.1G ontime11 2.1G ontime12 2…shards (adjust to your number of nodes) php genconfig 20 > shards.ini Running the test…stats-on-metadata=0 innodb-stats-sample-pages=256 innodb-stats-update-need-lock=…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… beautiful page rendering as well as much more queries per page which …offering MySQL and LAMP Consuilting Services. 2. Not using auto_increment functionality …have to fix have number of indexing missing which requires queries to do… to crawl. So developing you PHP applications use test database with …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…A query thread normally posts about 64 page read requests per a readahead. The…fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to… upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs…can run to show any table / index fragmentation, without having to run the OPTIMIZE…
Post: MySQL automatic data truncation can backfire
January 9, 2007 By 10 Comments
… problem I found out PHP and MySQL are both to blame. PHP is to blame because in 32bit PHP version result of crc32… was returned as signed integer, in 64bit build of same PHP version it became signed. The system worked on 32bit platform… truncating this value to 2^32-1, then performing index ref lookup (traversing about half of the rows in pages as cardinality for…
