…_SCHEMA.INNODB_SYS_INDEXES table, which exists in Percona Server 5.1, but doesn’t appear in MySQL until 5.6 (if the manual… a performance impact, but it seems to be the most stable. In this case, it turned out that the indexes were not out… the existing index in Innodb, which might not be desirable, but at least you can re-add it later. However, it’s not the…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…1 – Mysql 5.5 vs 5.6 response times are in seconds …performance of the query with the join in both directions. Explain for query Q1.1: mysql…EXISTS lineorder; CREATE TABLE IF NOT EXISTS lineorder ( LO_OrderKey bigint not null, LO_LineNumber tinyint not null, LO_CustKey int not null, LO_PartKey int not…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…see in OLTP or Web applications – medium size rows, auto increment primary key and couple of extra indexes. CREATE TABLE IF NOT EXISTS…in alpha stage and performance parameters may vary a lot in next releases) Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql…
Page: Presentations
May 3, 2006 By
…MySQL Performance 5.0 vs 4.1 MySQL Users Conference 2006, Santa Clara, CA This presentation shows in numbers performance differences in MySQL…MySQL Benchmark Group was working at the time. Does not have too much meat about MySQL Performance. Download MySQL…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…not meet our goal, which is pages which take more than 1 second to generate in given example. For goal driven performance…MySQL) or multiple MySQL Servers because in…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… really necessary (from performance standpoint)? In this post I’d like to present a small benchmark which shows MySQL performance when you use 3… cities_join: CREATE TABLE IF NOT EXISTS `states` ( `id` tinyint(3) NOT NULL auto_increment, `name` char(40) NOT NULL, PRIMARY KEY (`id`), UNIQUE…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
… regular MySQL / Percona Server setup. The point is that you can convert your existing MySQL… in write throughput when you run write traffic to 2 nodes vs… can shutdown any Node to perform maintenance or make configuration changes…. LOCK command). Xtrabackup SST does not require READ LOCK for full time…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…exists…not forget about performance implications designing the system and do not expect joins to be be free. Finally I should mention one more MySQL…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… MyISAM tables instead. The process completed in 12 seconds for 1000 rows in a batch vs 40 seconds for single row statements. So… performance bug of 5.0. At row0sel.c:row_search_for_mysql() “PHASE 3:”, InnoDB judge whether the SQL is “SELECT” or not…->mysql_thd != NULL && thd_is_select(trx->mysql_thd)) { /* It is a plain locking SELECT and the isolation level is low: do not…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…in OLTP or Web applications – medium size rows, auto increment primary key and couple of extra indexes. CREATE TABLE IF NOT EXISTS…performance and scalability in this simple cases. We also use CPU bound workload in…MySQL version We used MySQL…
