Category

MySQL

Sphinx, MySQL
Sphinx is live and kicking
02.24.08 | Permalink | Comment?

As I have mentioned in my previous post, I have started using Sphinx as a search engine on my site. It was a very exciting week for my site with a record breaking number of visitors. Sphinx has handled it great. I must say that MySQL full text search have done a great job too. […]
Solr, Sphinx, Lucene, PHP, API, MySQL
Sphinx and Lucene search engines, first impressions
02.15.08 | Permalink | 2 Comments

MySQL full text search is the easiest way to provide full text functionality on your site. It is easy to implement and easy to use. You just have to specify MySQL FULLTEXT index, and after that you search the tables with appropriate SQL queries.
However, there are some disadvantages. On a large databases full text search […]
Caching, MySQL
How to improve MySQL query cache hit ratio
12.13.07 | Permalink | Comment?

I have already mentioned one of the downside of MySQL query cache, query invalidation. Each time when you insert/update/delete records from the table, cached queries from that table will be invalidated even if the edited records are not in the cached subset.
The simple way to improve MySQL query cache hit ratio is not to update […]
Caching, MySQL
MySQL query cache
12.09.07 | Permalink | 1 Comment

On the Internet, caching is everything. Domain name servers cache your DNS records, proxies and browsers tries to cache your content, your’s server’s OS cache frequently used files into the memory… Although these are all different types of caching, they all have one thing in common, they improves overall performance of the system.
If you want […]