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 Continue reading “Optimize Redis on CentOS 7”
Tag Archives: optimize
Hints on import big sql 50GB above to MariaDB or MySQL
Understanding fastcgi_cache_path, levels, keys_zone, max_size, inactive, use_temp_path
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 Continue reading “Understanding fastcgi_cache_path, levels, keys_zone, max_size, inactive, use_temp_path”
Optimize MySQL order by RAND()
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 Continue reading “Optimize MySQL order by RAND()”
