June 20, 2013

Post: ANALYZE: MyISAM vs Innodb

… 3 rows in set (0.00 sec) Very interesting result – after loading the data … stats accuracy at the order of magnitude is enough. …computation method by default. Lets check how stats change for MyISAM if we change the stats computation method: mysql

Post: Is VoltDB really as scalable as they claim?

…; high availability is ensured by keeping more copies of each…. We’re focused on MySQL software and services. I am…order to use the model. Finally, I had to adjust the computed 1-node performance slightly (ranging from 1/2 of a percent to 8 percent) to avoid unphysical parameters as a result

Post: Predicting Performance improvements from memory increase

… 32GB can improve performance order of magnitude by converting very IO bound … anyway. Interesting enough because of MySQL scaling issues it is also…for that. Besides pure CPU based computation you should account for locking…. performance you may get misleading results if reports are typically done …