MySQL has a great feature called “Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are number of things you need to know. First let me clarify what MySQL Query… cache effectiveness – if you have high write application such as forums, query cache efficiency might be pretty low due to this…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… anyway. We also answer a lot of questions on our forum – if you can share your question we will try to… on MySQL Performance the scope of our work proved to be much larger. We handle a lot of architecture design for MySQL and LAMP systems in general, LAMP performance optimization, replication and high availability, scaling, writing whitepapers, helping people with data recoveries, implement MySQL…
Comment: UNION vs UNION ALL Performance
May 18, 2008 By 15 Comments
Hi, Can someone answer my related query posted in the mysql performance forum.Query can be found here: http://forum.mysqlperformanceblog.com/s/mv/tree/743/ Thanks.
Post: Progress with ClickAider project
October 24, 2007 By 21 Comments
… could be good for this work is just not ready. MySQL Performance is in fact the most serious issues we have to… directions for US audience compared to general audience or track performance for referrals from given domain name to see if partnership… any more to see system in action. We used our MySQL Performance Forums site for the demo, which might be a bit low…
Post: MySQL Server Upgrade
August 11, 2006 By 9 Comments
Today I’ve upgraded MySQL Server on the host running MySQL Performance Blog. MySQL 4.1.12 was running here for well over a… did I upgrade now ? Because new forum application was exposing one of the bugs in MySQL 4.1.12 so there was… with MySQL 4.1, they avoid queries which MySQL 4.1 does not optimize well and so MySQL 5.0 will likely reduce performance…
Post: Is it query which needs to be optimized ?
March 6, 2007 By 9 Comments
… I had a lot of a lot of questions at MySQL Performance Forum as well as from our customers regarding query optimization… which… as it needs to traverse a lot of rows to perform group by so for large number of rows you’ve… you’re going to run ORDER BY .. LIMIT can be performed using the index, for example simple JOIN is often showstopper…
Post: Leaving MySQL, MySQL Consulting
July 31, 2006 By 23 Comments
… will provide MySQL Consulting services. We’ll focus on MySQL Performance Optimization but will be able to help pretty much with all MySQL related issues. We can also act as your remote MySQL… this blog, hang around on forum, speak on conference as well as work on couple of MySQL related Open Source projects. If…
Comment: MySQL Performance Forums
November 14, 2006 By 18 Comments
… announced launch of new forums related to MySQL Performance questions. He says: This forum is created as free alternative to MySQL Consulting Services which we provide. If you would like to get some free help to your performance issues please use forums…
Comment: MySQL Performance Forums
August 10, 2006 By 18 Comments
… announced launch of new forums related to MySQL Performance questions. He says: This forum is created as free alternative to MySQL Consulting Services which we provide. If you would like to get some free help to your performance issues please use forums…
Comment: Using MyISAM in production
June 20, 2006 By 36 Comments
Hi peter, I came across your performance blog while searching through performance forum on MySQL site It is a great blog with lot of good information. We are having a weird performance problem… you need. I also posted this on forum and here is the link http://forums.mysql.com/read.php?21,85701,96186#msg…
