…record 1, cache record 500,001 …. get record 1, miss, read from disk, expunge record 500,001, cache record…talk about performance in a 100% pure memcached environment. Part … can then compare using MySQL to using MySQL + Memcached, and then … random # between 1 and 2 Million and looks up the result …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… per-day, an ad that gets a million impressions takes one row, and an ad… have the clicks column record the total, and the blue_clicks column record only blue clicks;…by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and …it for things that it’s not 100% optimal for. But if the costs…
Comment: Full text search for all MySQL Storage Engines
February 28, 2007 By 37 Comments
… main post you outline that sphinx can be used by MySQL 5.1 as storage engine? Can you please explain this… the fulltext index for two forums. Size is 2 Million records and 100,000 records. Average new rows per day 400. Average page hits…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…/mysqltest/mysql- –with-falcon mysqld startup params: Falcon: libexec/mysqld –no-defaults –user=root –falcon_min_record_memory=1G –falcon_max_record_memory… Method of benchmark: 1. Prepare table with 1,000,000 records (about 350Mb of data on disk) 2. Run each query…) FROM $tableName The hardest query performs a scan of all million rows. InnoDB is better than MyISAM by ~30% with 4…
