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 »
Access to MySQL You have to be root to set those settings # mysql -u root -p Maximize all Buffer and Packet Set network buffer length to a large byte number and set maximum allowed packet size to a large byte number set global net_buffer_length=1048576; set global max_allowed_packet=1073741824; SET foreign_key_checks = 0; SET UNIQUE_CHECKS = 0; SET AUTOCOMMIT = 0; Import your SQL file Import your sql dump file, you can import more than one file source file-to-import.sql; Set back to default Reme[…]
Hints on import big sql 50GB above to MariaDB or MySQL 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 »
