… compared to 5.5, such as bug #69258, and bug #69318, and I think it might take one or two …simple query, but it’s always possible to build something more involved if that’s what you need. Q: What MySQL … up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL…a “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight …InnoDB performs better when a larger number of rows must be joined together (Q4.1, Q4.2…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…two cases covered in the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries…reportedly Dimitri was using 8 tables with 1M rows each (about 2.1GB) for his tests,… culprit for the results difference. We then compared results across all 3 boxes to see …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…in a two-part series comparing Virident’s vCache to FlashCache. …of data (32 tables, 10M rows each) and a 4GiB buffer … –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ …thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…of course I wanted to compare InnoDB performance vs TokuDB. …GB. Workload: I will use two different schemas. The first …TokuDB tables with 1bln of rows on this SSD, and…_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min… 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… summarize data. Using the aggregated data can significantly improve query response times compared to accessing the non-aggregated data. Keeping MVs up…. Insert data in one transaction (two rows): mysql> insert into test.demo values (NULL,2),(NULL,3); Query OK, 2 rows affected (0.00 sec…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… on the columns of table t1 that are two be used to join rows with table t2. This step is called the… is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5 the query time decreases when the… that the query on MariaDB 5.5 is slow as compared to MySQL 5.6. Next interesting thing are the last two columns of…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… MySQL queries would make them even slower, I’m sure. Indeed, the result set of 20 rows from SphinxQL queries…best? No, I didn’t compare relevancy. I was focused solely on query response time for this test….to support changing data. One is to store two indexes, one for historical data, and the other…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…query in the right way. But vanilla MySQL does have its limitations, it reports only a subset of stats, however if you compare…Query_time: 0.117904 Lock_time: 0.002886 Rows_sent: 1 Rows_examined: 655360 Rows_affected: 0 Rows…_blog_two (34/22%)… 1 more # Query_time distribution # 1us # 10us # 100us …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row…compared to Innodb, 8:1 compared…
