…how we do a performance audit (it’s our most popular service). I thought I should write a blog…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…work for a while and then emerge with a report, it’s not that way a…
Post: Site was down today, support and web hosting.
August 31, 2007 By 27 Comments
…and a half year we had pretty good track record with MySQL Performance Blog – there were times when site was…work reasonably well. This time I got less lucky and in about a week after we moved MySQL Performance Blog… me to tell them how happy I was with service provided. How does one suppose to feel …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…a fair chance they will talk about how hard they have to work on I/O capacity. What does… data is coming from a partner site, and you upload …a three-part article on data archiving on my own blog a…work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work on a…
Post: MySQL Performance Blog now uses Sphinx for Site Search
February 15, 2008 By 52 Comments
…how build in Wordpress search works. it shows full documents rather than snippets it does not search comments and it does…something on MySQL Performance Blog. Today we have published new search functionality for our site which is…open source software in a few weeks – just want to test it a bit more …
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…a webinar today about SQL Injection, to try to clear up some of the misconceptions that many other blogs…does something similar, interpolating parameter values into a …how to escape input that contains non-printing characters. The standard API function mysql… performance, your site is working well if …
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…sites you would see a counter how many time given object – blog post, forum thread, image, … table as counter table (can well work if you do not run into … solutions you can use memcache + another mysql instance (or simply the database which … group by query ? Sure it does but it does not have to do it…
Post: Can having information public hurt consulting business ?
April 30, 2008 By 9 Comments
… blog they would find information in MySQL Manual or on thousands of other sites, … figuring out how to apply it. In general “Googling” usually works for… with diagnoses. There are surely a lot of information on the…is another reason having information available does not cause competition. Though these…
Comment: MySQL wins C'T Database Contest
August 30, 2006 By 27 Comments
…a press release. Exactly the things as Peter/Vadim were speaking about regarding benchmark results in previous blog entry on this site…mysql result was using memcached, how…how much time you need to put into a solution before it gets decent performance. We who have been working with a…
Post: Beyond great cache hit ratio
May 19, 2010 By 2 Comments
…worked…MySQL queries. The hit ratio is 90%. Imagine now you have found a…blog entries cachable at least for several minutes. There are many development implications, component dependencies etc on how…. Does …a lot of art and science in designing optimal cache solution. The good thing is most web sites…
