…’m happy to announce availability of MySQL Performance Forums on MySQL Performance Blog. This forum is created as free alternative to MySQL Consulting Services which we provide… MySQL Performance. There is MySQL for MySQL Performance topics. LAMP Forum for Web Application scaling and performance topics, whatever database you’re using and Full Text Search Forum…
Post: MySQL Performance Forum: Hot Topics
August 18, 2006 By Leave a Comment
As I already announced last week I started MySQL Performance Forums project focusing on MySQL Performance discussions as it names says. I spend planty of… list for last week: Ways to perform full text search on Chinese texts with MySQL Replication of Summary tables only Overhead of…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
… to Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with any other domain to search forums from that domain. For example you can use this link to search our MySQL Performance Forums Second – note the… which pages and domains forum users tend to link to. So far reporting period is restricted by performance reasons – there is too…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… performance, we already know Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance…| 139448919 | 2735703 | +————+——–+———-+———–+———+ 10 rows in set (32.47 sec) MySQL mysql> select max(forum_id) as m,author_id as a from …
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
…MySQL instance — that took ten seconds. And then I set up an SSH tunnel from my laptop to the MySQL Performance… | mpb_forum.f.PRIMARY | fud26_forum_i_c,fud26_forum_i_c,fud26_forum_i_lpi | 6095451542512376951,11680437198542055892 | 20 | | mpb_forum…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, … documentation or forums. So I…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…for MySQL. Performance comparison of MySQL 5.0, MySQL 5.1 and MySQL 6.0 Come to see how performance of MySQL 5.1 and forthcoming MySQL … billion of forum posts. Transactional Storage Engines Performance We’re looking at performance at Open Source Transactional Storage engine MySQL – Innodb, Falcon, …
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
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 13 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.
