Blog entries  |  Home » Posts tagged with » mysql database

Very high Mysql CPU usage and low memory usage with Nginx+php-fpm solution

Just a very short post here as I wanted to share some finding on a problem I recently encountered.
On one of my websites I was implementing a Jcart Shopping cart instead of just the previous ‘buy now’ button to do some A/B testing to see what does better. When the implementation was done everything was […]

Mysql 2 Search PHP class made public

Mysql 2 Search PHP class made public

I decided to release a search class which I use for several of my website to the public to use. The collection of 2 classes use 3 techniques to search a mysql database which are:

Full text search (for MyISAM or InnoDB with Mysql version 5.6)
Like search (simplest method, not recommended)
Sphinx search (needs Sphinx installation, recommended)

The […]