…for MySQL Performance optimization tasks but there are number of things you need to know. First let me clarify what MySQL…query parsing step is … to retrieve data from table….for certain application. It is not that fast Query Cache is fast compared to running the queries but it is still not as fast…
Post: Countless storage engines
May 3, 2007 By 6 Comments
… Oracle bought InnoDB, MySQL did one step – announced MySQL supports Plugginable Storage Architecture…fast way aggregative functions on massive data sets. As I understood they use special index to store pre-calculated values for limited number of functions, and then engine can retrieve values…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…stepping : 6 cpu MHz : 1995.004 cache size : 4096 KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for… call MyISAM uses to access data and retrieving from OS cache is not…fast. READ_PK_POINT_INDEX Query: SELECT id FROM $tableName WHERE id = %d Simple but very quick query to retrieve…
