…for memcached. For instance, if you have 1…accessing this data will destroy the use of cache: get record 1, miss, read from disk, cache record 1 …. get record 500,001, miss, read from disk… using MySQL to using MySQL + Memcached,… scream other times it won’…random # between 1 and 2 Million and …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1-falcon for…1. Prepare table with 1,000,000 records (about 350Mb of data on disk) 2. Run each query for 1…million…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… can’t get access to the time of day of … ad that gets a million impressions takes one row,… column record the total, and the blue_clicks column record …using MySQL 5.1‘s row-based replication, or in MySQL …Â A day at a time, for example. There are a…sharding for a long time and run on many fewer disk …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… million rows and one secondary key: mysql…mysql> ALTER TABLE t ADD COLUMN v VARCHAR(1); Query OK, 4194304 rows affected (1 min 1.97 sec) Records: 4194304 Duplicates: 0 Warnings: 0 mysql…to do random disk seeks to…also optimize index access for subsequent DML … compare the restore time for a regular …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…record is updated by another user. Now PBXT does acquire locks for 2 reasons: to support SELECT FOR…1.0.09) supports the MySQL Backup API which was originally implemented in MySQL 6.0. This feature is now scheduled for…access times…millions…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… workloads. This time I tested …access patterns: primary key single row lookup, primary key range lookup, same access types for…mysql- –with-innodb Method of benchmark: 1. Prepare table with 1,000,000 records (about 350Mb of data on disk) 2. Run each query for 1… scan of all million rows. General …
