… 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 performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This… and logical design, you can make certain workloads, such as insert-heavy, work better in the Amazon cloud platform. But this…
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
… we love to analyze performance of various MySQL features, benchmark, compare, analyze things and post our findings on MySQL Performance Blog. However recently we… what happens on all layers (MySQL, Operation System, Hardware) when for example row is being inserted into Innodb table on Linux stored…
