… in Percona Server showed fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of… 1M rows each (about 2.1GB) for his tests, while in our original tests we used a much larger one, 16 tables… there is a non-trivial amount of updates to the database, all SELECT queries, even those participating in read-only transactions…
Comment: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
I am confused about how this tests flashcache. The use case for flashcache is to put some … benchmark database is small (78gb) and the flash device is huge (2.2tb). To test flashcache I think you should use a database… doesn’t completely fit in flash. So you need a database that is much larger than 1tb, a flash device that…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… it isn’t always obvious how they will affect your database workload. For example: Transaction commit takes approximately the worst packet… counter in memcache or redis and only flushing to the database periodically? if( $last_count % 100 == 0 ) { $db->do( “UPDATE achievements… about the tradeoffs, but we’re making them (anyone obsessively testing slave position to ensure it’s caught up with the…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…- It’s all about performance. Suppose I have a 2TB database, but maybe my working set is only 500GB. What are… data might just be sitting idle? Or what if my database is really large, say in the multi-terabyte range? I… flash For example, see http://www.ssdperformanceblog.com/2013/04/testing-the-micron-p320h/ – the card referenced there is a Micron…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… 5.0 and 5.1 were rushed and not properly tested but 5.5 and 5.6 were significantly improved and… still much more common than even the most popular NoSQL database when viewing indicators such as inclusion in LinkedIn bios Oracle…’s summary of 451 Research’s database survey by viewing the research report “451 Research database survey points to MySQL gravitational tug…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… file name. Back in 1979, Monty developed an in-house database named UNIREG. UNIREG was a text-based program for entering records into an ISAM-style database. It would have an 80×24 text UI for entering data… not very interesting and just says “Can’t create table ‘test.t’ (errno: 139)”. This is because InnoDB has a hard…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… running the memcached plugin. Here are some details about the test: Minimal hardware (vBox instances on MacBook Pro) Centos 6.4… average fetch time. Here are the raw results from this test run (100,000 store operations, 1,000,000 fetch operations… of warmup time to application Cost of disk space on database server Now, there are definitely other NoSQL options for persistent…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…=101, and gives you an indication of the numbers of database connections the thread pool supported. I was not part of… tens of thousands of actual connections. As with any functionality, testing and benchmarking is necessary. I would also caution people to clearly understand and test, what are “connections” and what are “active connections” when determining…
Comment: MySQL and Percona Server in LinkBench benchmark
May 15, 2013 By 18 Comments
I used maxid1=1B for my tests. That might be 100X given the terminology used in this blog post. Databases were several hundred GB on disk.
Comment: Is Synchronous Replication right for your app?
May 15, 2013 By 18 Comments
… can move to sync repl simply by monitoring your live database rather than do analysis or tests.
