… virtual disk is basically nothing more than a file on the host filesystem rather than an actual physical volume. … it. One way is to set up replication filters on the slave, as described in the MySQL manual…. 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 query automatically would be more costly than just running the query …up the row with “=” instead of “>” and be guaranteed to find exactly one match… the sequence after making certain insert/update/delete operations. If you…. It was more efficient in this case to force MySQL to scan the …
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re more…, that is if you have more than one PXC node. This is because…this is to avoid collisions when INSERTs are happening on not only a…if your async master can use ROW based binlog format as well …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…] a given row can’t be modified more than once …MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much worse than…of updating global counters one at a time (from… parent group row so often? INSERT INTO users_groups (user…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…more about MySQL buffer pools or anything else that’s on your mind! There are numerous solutions for MySQL… match no rows or insert statements that have duplicate key errors may be faster than an actual database…warmed up the buffer pool for the next one. As an additional experiment we tried replaying…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… data (32 tables, 10M rows each) and a 4GiB …would it make more sense to configure MySQL as if it … this configuration B. The next one contained four SSD-specific… produces better and more consistent performance than vCache without time-…_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…one at a time. (Please provide specific references if you find otherwise.) I would argue that single-row queries (SELECT, INSERT…rows. This is, in my experience, the main use case for PARTITIONing. I go into more details (and code) here: http://mysql…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…read records will be cached, resulting in more disc reads. 2. If you need to… quicker on a partitioned table, as Mysql can fire off one thread per partition (at least…Inserts, its also about what you do with the table. Removing partitions is easier and quicker than deleting a few hundred thousand rows…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… to select a PC and guarantees that there is no more than one primary component in the cluster. In our 2 nodes setup… insert, this first insert will take longer: percona1 mysql> insert into percona values (0,’percona1′,’vadim’); Query OK, 1 row affected (7.77 sec) percona1 mysql> insert…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…one or more “CREATE TABLE db.schema … AS SELECT” and/or “INSERT…rows in set (43 min 10.11 sec) As an added benefit, if you build more than one…
