…you’ll get roughly 1.67x the throughput of a single port. [Don’t try more than 2; the additional … query, but it’s always possible to build something more involved if that’s what you need. Q: What MySQL…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
…of queries. The query optimizer analyzes queries for common patterns the MySQL …a query automatically would be more costly than just running the query …1..MAX(id)? Yes, there’s a risk if you have irregular distribution of matching rows… sequence after making certain insert/update/delete operations. …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…more than 4x data compression on this dataset. We can easily fill TokuDB tables with 1bln of rows…insert-roll-2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql…query_cache_size = 0 query…
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…query traffic. This is an important step because update statements that match no rows or insert statements that have duplicate key errors may be faster than…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…(32 tables, 10M rows each) and a …it make more sense to configure MySQL as if… better and more consistent performance than vCache without …_size = 1000 query_cache_size = 0 query_cache_type = 0…insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… Re: #1); let me…single-row queries (SELECT, INSERT,…more efficient than DELETEing the equivalent 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
…t answer the ‘Insert‘ part. 1. With a…, resulting in more disc reads. 2…queries on any other column, these could easily be quicker on a partitioned table, as Mysql…Inserts, its also about what you do with the table. Removing partitions is easier and quicker than deleting a few hundred thousand rows…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…more than…1. row *************************** Last_Errno: 1146 Last_Error: Error ‘Table ‘test.t’ doesn’t exist’ on query. Default database: ”. Query: ‘insert into test.t(a) values(1…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… dependencies, but that would be much more complicated in a cluster. It’s…mysql> insert into autoinc (j) values (‘node2′ ); Query OK, 1 row affected (0.00 sec) node2 mysql> insert into autoinc (j) values (‘node2′ ); Query OK, 1 row…-spots– this is probably easier said than done in most cases, but in…
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… mysql> insert into percona values (0,’percona1′,’vadim’); Query OK, 1 row affected (7.77 sec) percona1 mysql> insert into percona values (0,’percona1′,’miguel’); Query OK, 1 row affected…
