… disk space? Taking real-world data, I have for example a table that looks like this from the query in this article… -rw-rw—- 1 mysql mysql 58G 2012-04-24 13:41 tablename.ibd On disk vs the information_schema query, there is around 9GB discrepancy. Does this have any real world meaning? Thanks
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… of CPU usage. In real life workload results are likely to be very different. The schema and queries are described here Used… 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…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… different response time guidelines for pages which are requested for real humans vs search engine bots (which are often quite different in… of the stack. If you look at MySQL log you may find some queries which are slow but it is hard to… to run the query to see what are contributing factors to the response time of the problematic pages: mysql> select count(*),avg…
Page: Presentations
May 3, 2006 By
…queries optimization for MySQL including application based tuning such as avoiding queries… of MySQL build in full text search functionality using real medium…MySQL Performance 5.0 vs 4.1 MySQL Users Conference 2006, Santa Clara, CA This presentation shows in numbers performance differences in MySQL…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… ? Out of all MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show MySQL 5.0 is …practice. During my work for MySQL I recommended not to use MySQL for certain applications (ie when queries and schema could not …to often have nothing to do with performance in your real environment.
Post: Large result sets vs. compression protocol
December 20, 2007 By 6 Comments
mysql_connect() function in PHP’s MySQL interface (which for reference maps to mysql_real_connect() function in MySQL C API) has a $client_flags… can be used. We’re interested in a specific one, MYSQL_CLIENT_COMPRESS. This flag tells the client application to enable…. That’s almost 1.5x improvement in total run time. MySQL query time improvement is even greater. On the other hand 1…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs… In real life workload results are likely to be very different. The schema and queries are…: 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for …
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
July 8, 2007 By 1 Comment
… rather typical for some applications to have long delays between queries. If query is being read or result set is being sent… server with partial query received. Result set however comes back in multiple pieces and if you’re using mysql_use_result you… data because there is buffering happening inside MySQL client library so you never know when real network read will happen. As net…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
…, draw trends. Compare engines in statistical queries for end users, which can be executed in real-time. I.e. How many times that or another page was accessed yesterday vs today. Understand specific… 20; I am going to load data and run queries against available engines: MySQL MyISAM / InnoDB (to have reference results) InfoBright InfiniDB…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… rows if they were not matched by query where clause when it was not … and it would write at 100MBps vs 33MBps. Any plans to enable tuning …: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency…of any index. Can you describe a real-world use case where it would …
