… you ever want to use MySQL on top of something like that? I can’t imagine the performance being all that fantastic, and I could see network latency wreaking havoc with MySQL‘s internal understanding… to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it…choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER… and reinitializing the sequence after making certain insert/update/delete operations. If you have …
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users… the cluster, this is to avoid collisions when INSERTs are happening on not only a single node. However… without PK imposes an additional overhead, and because cluster performance is somewhat dependent on the slowest node – this …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication…an lower bound on performance, only a upper bound. The best performance you can expect … also updates groups with some metadata: BEGIN; INSERT INTO users_groups (user_id, group_id) …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload… fast inserts, but it is suitable for range selects by `id`. However it will interesting how both InnoDB and TokuDB performs if…/insert-roll-2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters… vCache performance results were obtained with the default vCache configuration, I think vCache can be declared the clear winner. Base MySQL & Benchmark… read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…, performance is not bad. (The last 2-3 partitions tend to stay in the buffer_pool.) If I recall correctly, any INSERT… (within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time. (Please provide specific… find otherwise.) I would argue that single-row queries (SELECT, INSERT, DELETE, UPDATE) are similar in speed between PARTITIONed or non…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…. I have not reviewed or tested semi-sync in official MySQL so I am surprised by this and don’t understand… we will verify this. “Semi-sync performs dismally under concurrency. Think about it, our single inserts took ~100ms, so we are effectively…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS… a solely in-memory bottleneck to solely on-disk. The insert performance is quite variable, more so than I would like to… them. Finally, a single-threaded insert workload is not very revealing. To understand the sustained write performance of an RDS instance, we…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that … software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
