http://www.mysqlperformanceblog.com Everything about MySQL Performance Thu, 15 May 2008 00:22:58 +0000 http://backend.userland.com/rss092 en Recently I had an interesting surprise with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were blocking and the process list was filling up with queries in Locked status. My first thought was that the customer had deleted from the table, which ... http://www.mysqlperformanceblog.com/2008/05/14/concurrent-insert-select-myisam/ Looking at Kaj's Blog Annoucement MySQL has pulled back on the plans to release portions of the servers as close Source only. I am extremely happy to hear these news ! This is good for MySQL as a company, MySQL customers and MySQL users. I'm hoping Community feedback was ... http://www.mysqlperformanceblog.com/2008/05/13/mysql-is-back-to-open-source-camp/ As you know we love to analyze performance of various MySQL features, benchmark, compare, analyze things and post our findings on MySQL Performance Blog. However recently we got too busy with serving out customers and the backlog of things to take a look and write about is just growing ... http://www.mysqlperformanceblog.com/2008/05/13/mysql-performance-engineer-opening/ In the previous post I mentioned a way I use to preload Clustered Index (data) for Innodb tables. Though I thought this topic would benefit from a bit more information. But lest first start with feature request for Innodb Team: All ways I mention here are hacks and ... http://www.mysqlperformanceblog.com/2008/05/01/quickly-preloading-innodb-tables-in-the-buffer-pool/ Recently I was working with the customer who need quick warmup - to get Innodb table fetched in memory as fast as possible to get good in memory access performance. To do it I run the query: "SELECT count(*) FROM tbl WHERE non_idx_col=0" I use this particular ... http://www.mysqlperformanceblog.com/2008/05/01/learning-about-mysql-table-fragmentation/ Sun is aggressively pushing T2000 as Scalable MySQL Platforms, and indeed it is Scalable in terms of high concurrency workloads - it is able to execute a lot of concurrent threads and so speed gain from 1 thread to say 32 thread will be significant. But thing a lot ... http://www.mysqlperformanceblog.com/2008/05/01/t2000-cpu-performance-watch-out/ People frequently ask me if the fact we keep information public can hurt our consulting business ? Lets keep aside for the moment amount of new business publishing this information brings to us but think it also have significant negative effect because people find information on MySQL Performance Blog ... http://www.mysqlperformanceblog.com/2008/04/30/can-having-information-public-hurt-consulting-business/ If you've missed our presentations on MySQL Users Conference you can catch up now by taking a look at the slides, which are now published in presentations section of our company web site. You can also find a lot of old presentations in the same location. Enjoy ! http://www.mysqlperformanceblog.com/2008/04/30/percona-team-presentations-from-mysql-users-conference-2008-published/ Well these days we see a lot of post for and against (more, more) using of MySQL and DRBD as a high availability practice. I personally think DRBD has its place but there are far more cases when other techniques would work much better for variety of reasons. ... http://www.mysqlperformanceblog.com/2008/04/28/mysql-replication-vs-drbd-battles/ In my post on estimating query completion time, I wrote about how I measured the performance on a join between a few tables in a typical star schema data warehousing scenario. In short, a query that could take several days to run with one join order takes an hour with another, ... http://www.mysqlperformanceblog.com/2008/04/28/the-mysql-optimizer-the-os-cache-and-sequential-versus-random-io/