…at all interested in MySQL. We really want you to be there — and that’s why we’re giving away free tickets and books, and making it easy for you to enter the contest! Here’s how …, we can direct-message you. Official contest rules: You agree to let us mention you in the winner’s …
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…MySQL 5.4.2 for tests which should be as good as it gets in terms of optimizations in this space. To…trx_commit=0) go giving 550 and 380 …to be applied just about number of tables. With innodb_open_files=64 I got bunch of warning messages…files in the list. I guess Heikki knows how to implement LRU in…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
… MySQL honestly was never good at is giving good helpful error messages. Start with basics for example – The error message in case of syntax error gives… is perhaps my favorite one. How do you expect to decode from this message this means storage engine in question is unavailable ? This is…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the…necessary, I find out which are the most likely to give the greatest gains. I use a dual approach …I’m going; or just get on an instant messaging chat and tell the customer “here’s the …
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 53 Comments
…in MySQL 5.0 and quite frequently VIEWs are used to help in writing the queries – to keep queries simple without really thinking how…message` text NOT NULL, PRIMARY KEY (`user_id`,`comment_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 So how… 1 row in set (0.95 sec) So we create the view which gives…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…, main marketing message – Storage Engine partnership with IBM…to for data and for various indexes. How many “fragmented” pages do we have in…giving you problems if you have a lot of concurrent inserts happening to…in MySQL 5.2 or even MySQL 5.1. I surely would like to see it sooner at least in…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
…to try it with 76 GB. The error message was an assert due to a failed malloc() in ut_malloc_low() in…in ut_malloc_low(), so to get an idea of the pattern of requested allocations I added a debugging fprintf() to tell me how… to have the largest possible innodb_buffer_pool_size. Do not forget to give…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…see how “compact” they would be in real world cases and how much performance it will give. …not implemented in MySQL anyway though). Very interesting to see how this one will compare to transparent gzip…in table ‘t’” error message. If you find Falcon or Innodb behavior better still prepare for this to…
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
…to limit number of connections to MySQL and so let application to err when it tries to put too much load on MySQL as MySQL…to get in. It is a lot better than having it done on page basics when you randomly have some pages giving error messages. In…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
…in my case the client is not interrested in “relevance” of a message but rather that the message which popups in…exists but google decides to not give you the hit until … words” benchmark is to easily see how different solutions deals … to “10 most common words” search the mysql fulltext in boolean…
