… serious bugs are. Large Team, Tricky Code During MySQL 3.23 and MySQL 4.0 team the small tight knit team was working… of them use 5.1 vs row level replication or events. I think less than 5% are using both features. MySQL 4.1 was out for years and yet I would say no more than 5% of…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 … # Rows sent 7.15M 0 56.36k 4.19 0.99 360.95 0.99 # … # Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # … kind of hardware provides better balance of CPU vs IO utilization as well as as simple …
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… fix for this scalability problem and it is merged into MySQL 5.0.30 “Enterprise” but according to the tests I’ve… see MySQL 4.1 actually scaled pretty well with Niagra, suffering slow regression with increased concurrency rather than quick drop. In MySQL 5.0… seen much better on this picture Linux vs Solaris comparison is also pretty interesting. With MySQL Linux has higher peak but Solaris…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… to my MySQL Performance 5.0 vs 4.1 presentation to have some fun. What can we see ? Out of all MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show MySQL 5.0 is faster were selected… be able to do the same ? This was similar with MySQL 4.1 – number of great performance fixes but good number of…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO… xfs 4 threads: 97 MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs…. This is to another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/… lower, the difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an important metric …540} dm-0 447.1 34.0 7.4 0% 2.4 5.4 23.4 49.6 0.6 0% 0.0 0….
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… schema and queries are described here Used hardware CentOS release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name… RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5… ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with-falcon mysqld startup params: Falcon…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… So let us first take a look at MySQL 5.1.23 vs 6.0.4 results for 10GB data set which “fits in… by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5… it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We can see MySQL capabilities to run…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… KEY state_id (state_id) ) ENGINE=MyISAM; 4) Dictionary table for cities_join: CREATE…id) WHERE s.name=’Minnesota’ limit 10000,5 \G *************************** 1. row *************************** id: 1 select_type…join performance degraded dramatically. Here is why: mysql> explain select SQL_NO_CACHE c…
Post: Benchmarking Galera replication overhead
October 13, 2011 By 12 Comments
… to minimize IO overhead Software: Percona-Server-5.5.15 regular and with Galera replication. During …regular replication we have better result: 11180 for MySQL replication vs 10384 for 2 Galera nodes. However …For Galera replication this is NOT a problem. 4. Now it is interesting how Semi-Sync …
