…name, c_address, c_comment order by revenue desc LIMIT 20; In-memory workload Now…in MySQL 5.6, is that because of a bug in MySQL 5.6 code? As MRR was used in both MySQL…and not all index tuples could fit in the buffer. If this is > 0 …SIMPLE nation eq_ref PRIMARY PRIMARY 4 dbt3.customer.c_nationkey 1 …
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… all get used to that, and in fact in our benchmarks, sysbench and tpcc-mysql… in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments… (in sec) between events: 0.61, 0.43, 1.55, 0.18, 0.01, 0.76, 0.09, …’;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…core of original implementation which appeared in MySQL 4.0 Query Cache was designed to … now when you update the table all queries have to be invalidated from…in by different developers. Supporting different comments is especially important as many application put extra information in the comments…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…` date NOT NULL, `l_shipinstruct` char(25) NOT NULL, `l_comment` varchar(44) NOT NULL, `l_shipmode` char(10) NOT NULL… able to find is Baron’s bug with no mention in MySQL 6.0 manual. No mentions about Using MRR also, but I….83 0.61 2570.49 4.92 1285.25 2.46 8.09 1.02 3.21 3.21 102.11 almost all…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 53 Comments
… appeared in MySQL 5.0 and quite frequently VIEWs are used to help in writing …*************************** id: 1 select_type: PRIMARY table: type: ALL possible_keys: NULL key: NULL key…comments type: index possible_keys: NULL key: PRIMARY key_len: 8 ref: NULL rows: 1792695 Extra: Using index 4 rows in…
Post: Beware of MySQL Data Truncation
February 7, 2009 By 4 Comments
…in set (0.00 sec) MySQL optimizer behaves rather strange in such case (at least in MySQL 5.0…mysql> set sql_mode=STRICT_ALL_TABLES; Query OK, 0 rows affected (0.00 sec) mysql> insert into article_comment…
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
… post on MySQL Query Cache Gerry pokes me as I’m all wrong and both comments and whitespace are fixed in MySQL 5.0. This was not what I remember seeing in production so… list output we can see the comments are actually skipped: | 798009298 | root | localhost | test | Query | 4 | Sending data | select count(*) from fact…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with multiple threads. Not all…this matters — please fill in whatever’s missing in the comments. There can be … was originally coded for MySQL 6.0, but is available now in MariaDB. Unfortunately …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…siblings : 4 core id : 3 cpu cores : 4 fpu : …commands | 255868807 | 11893 | | Com_alter_db | 0 | 0 | …snip This…’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ |…all my analysis for sending, add in things I may have noticed along the way (comments…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…have it all in place, we …mysql‘ ‘–infodir=/usr/share/info’ ‘–includedir=/usr/include’ ‘–mandir=/usr/share/man’ ‘–enable-thread-safe-client’ ‘–with-comment=MySQL…mysql-5.0.51a/ mysql-5.0.51a/bdb/ mysql-5.0.51a/bdb/Makefile.in mysql-5.0.51a/bdb/btree/ mysql-5.0…-buffer-size=4 -m64 -mtune=generic’…
