Optimizing Redis configuration involves various parameters that you can tweak based on your specific use case and workload. Below are some key configurations that you might consider tuning in your Redis setup on CentOS 7. The configuration file for Redis is usually located at /etc/redis.conf. Steps to Apply Changes: Remember, the above options are general […]
Optimize Redis on CentOS 7 Read More »
A note for myself to exaplain fastcgi_cache_path, levels, keys_zone, max_size, inactive, use_temp_path As documentation said, nginx will keep all active keys and information about data are stored in a shared memory zone, whose name and size are configured by the keys_zone parameter. As a matter of completeness, lets break down per part /var/cache/nginx is the place where the actual cache stored. Inside the
Understanding fastcgi_cache_path, levels, keys_zone, max_size, inactive, use_temp_path Read More »
It is not recommended to use ORDER BY RAND() only, it will slow for query large database like over 50,000 rows. The easiest way to optimize existing code, just add RAND()< (SELECT ((1/COUNT(*))*10) FROM Table_name) after the WHERE before the ORDER, this sub query will speed up the select random from the table. Using this
Optimize MySQL order by RAND() Read More »
