…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…query script will run one more more semicolon terminated SQL statements. The queries for the benchmark are in ~ec2-user/shard-query/queries…pages…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…queries if you need. I would also note for many PHP…page rendering as well as much more queries per page …own, offering MySQL and LAMP Consuilting Services. 2. Not …MySQL you might be better of using several queries than doing complicated ones…have number of indexing missing which requires queries to do…
Post: MySQL automatic data truncation can backfire
January 9, 2007 By 10 Comments
…found out PHP and MySQL are both to blame. PHP is to blame because in 32bit PHP …. This one is kind of expected. What was unexpected however is how MySQL executed select queries if…MySQL truncating this value to 2^32-1, then performing index ref lookup (traversing about half of the rows in pages…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…queries are going to be affected same way, for example point select reading single page… ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create …updates to 10000 distinct pages for index header updates not… enough it dropped just 2 times and was …as I did only one run (It took more …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…I would also note for many PHP applications abstraction layer is > not… have beautiful page > rendering as well as much more queries per page which …MySQL you might be > better of using several queries than doing complicated ones. …index that has very low cardinality (1/2 a million rows with an index…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…query thread normally posts about 64 page read requests per a readahead. The InnoDB buffer is 256 page… http://bugs.mysql.com/bug.php?id=29560…Mysql server for a client, upgrading their main database (from 16GB, 2…(of which Mysql is the main one with…show any table / index fragmentation, without having …
