…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
…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…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…mysql_ratio ,avg(sphinx_time/wtime) sphinx_ratio, avg((wtime-mysql_time-sphinx_time-utime)/wtime) lost_ratio from performance_log_081221 where…not accounted for. Large portion probably comes from memcache accesses which are not instrumented for this application. In this case this portion is not…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
…performance standpoint)? In this post I’d like to present a small benchmark which shows MySQL performance …TABLE IF NOT EXISTS `states` ( `id` tinyint(3) NOT NULL auto_increment, `name` char(40) NOT NULL, PRIMARY …SQL_NO_CACHE city from cities_varchar WHERE state=’Minnesota’ limit 10000,5; Result time…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…in set (4 min 58.63 sec) mysql> select count(pad) from large where…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: 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…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… replication in master side vs slave side?…In this scenario, not all queries could scale out to slaves, because some of the data would exist…in the buffer pool. But the read/write split solution is intended for cases where…performance cost? A: Connecting to a MySQL database isn’t a great performance…
