June 20, 2013

Post: MySQL Consulting - Being on your own

…Sales before, while I acted a lot as Sales Engineer. It turns out however selling is not that … We also answer a lot of questions on our forum – if you can share your question we will …good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching for them, Yahoo is also on …

Post: Ultimate MySQL variable and status reference list

… in the Percona documentation or forums. So I present to you…_show_engine_logsblogpercona.commanual Com_show_engine_mutexblogpercona.commanual Com_show_engine_statusblogpercona… optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer_switchblogpercona.commanual…

Comment: Full text search for all MySQL Storage Engines

… storage engine? Can you please explain this in detail? I’m currently using MyISAM becasue of the fulltext index for two forums… table locking reasons and issues. The combination of complicated (long) search + insert + many parallel small selects gives terrible performance with MyISAM… that don’t use FT search could run without slowdown from the normal table … A FT search for Inno would propably the…

Comment: Sphinx: Going Beyond full text search

… as a pluggable storage engine for mysql? Currently we have a forum with about 17million posts, and a dedicated search server (a supercomputer…. I’m thinking of migrating vbulletin to use sphinx for searching. http://sphinxsearch.com/doc.html#sphinxse Michael

Post: Why MySQL could be slow with large tables ?

…been reading enough database related forums, mailing lists or blogs you probably heard … MySQL and other way around. Even storage engines have very important differences which can affect performance… is less of the problem. Data retrieval, search, DSS, business intelligence applications which need to …