… TV show. Couldn’t you have used a SUBQUERY to fetch and compare MAX(episode_id) as an option there? Yes…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the data is not cached (the cold run) but is slower in the hot (cached) run. I did some investigation during…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
… = Deriv1.parent WHERE a.parent=” . $parent); echo “”; while ($row = mysql_fetch_assoc($result)) { if ($row['Count'] > 0) { echo “” . $row['label'] . “”; display…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… on. It’s pretty fast. But it’s still significantly slower (and more CPU-intensive under high load) than PCIe flash…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… modifying a given row once per RTT, it could get slower if apply times start to lag. So what about my…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… that N threads doing concurrent load will be a lot slower than 1 for some N. Eventually you change from having…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… data infile concurrently results for two threads is 20 times slower then 1 file after the other. This could not be…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
… query by a secondary index? I heard that TokuDB is slower than InnoDB on SELECT but it’d be interesting to…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…-partition equivalent. Even single-row writes are likely to be slower in PARTITIONed tables unless you include something to facilitate pruning… little difference. * If it cannot prune, then partitioned would be slower, since it would attempt the DELETE in all partitions. * A…
